Count Distinct not working using Summarize Tool

[varun511]

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)

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

[JoaoLeiteV · Accepted solution]

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.

[Tyro_abc · Accepted solution]

Hi

Check it!

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

Regards

Tyro

[tomekgagola · Accepted solution]

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

[JHerzog5839]

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

[nairsatheesh10]

Use Count Words String instead of length

[atxdata]

This is the only solution that yields the expected result!