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

4701229_DZ2FOSN9.xlsx

JoaoLeiteV

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.