Formula to count the unique values in a column

Highlighted
Contributor

Formula to count the unique values in a column

Hi

 In the attached screen shot of my dashboard,I want to count the number of unique values in the Item column and display the count value near the title 'Comp Reservation Details'.Any help for the formula/workaround is appreciated.

 

Thanks

Regards

Prabakaran

1 REPLY 1
Highlighted
Master Anaplanner/Community Boss

Re: Formula to count the unique values in a column

@praba71 

 

Try this out....If that column is not a list, go ahead and create a list using a view with a filter using isfirstoccurrence().  In this module, create a new line item called Count with a hardcoded 1 as the value and create another line item which has the formula Finditem(new list name, Item).  In a new module using the list you just created, do a sum of the count line item: SourceModule.Count[sum:line item using the Finditem()].  This will give the number of times the item has occurred.

 

Rob