Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Count Distinct not working using Summarize Tool

varun511
7 - Meteor

HI Team,

 

Have a Data with 3 Columns Song,Artist,year Need to find out No of Unique Artists whose Length of song >=7  (Data Source is Attached)

 

varun511_0-1631645262260.png

 

I tried  below workflow but is not working   i tried Group by artist and Count distinct in summarization but it is not giving desired result

I want to see  how many unique artist names whose  song length >= 7 

 

Any help would be highly appreciated

varun511_1-1631645346384.png

varun511_2-1631645429080.png

 

 

 

 

6 REPLIES 6
JoaoLeiteV
10 - Fireball

Hey there,

 

You could use a filter with a custom formula (Length([Song]) < 7) and then a Unique tool set to Artist. This gives 752 records, Then you could use a select to leave only the artist column enabled.

JoaoLeiteV_0-1631646912968.png

 

Tyro_abc
11 - Bolide

Hi

Check it!

You can get it from the Unique tool as well as the Summerize tool.

Tyro_abc_0-1631647079101.png

Regards

Tyro

tomekgagola
7 - Meteor

@Tyro_abc and that is fine however the answers in cert exam were below 100?

JHerzog5839
7 - Meteor

I feel like they meant to ask something else.  Maybe it was supposed to be <=7

nairsatheesh10
5 - Atom

Use Count Words String instead of length

nairsatheesh10_0-1669019470695.png

 

atxdata
5 - Atom

This is the only solution that yields the expected result! 

Labels