Skip to main content
New Idea

Count Distinct for Picklist Values

Related products:None
  • December 16, 2021
  • 3 replies
  • 107 views

bradley

If you want to use a report widget to find and display the count of unique values, you cannot do this if your field is a picklist.

 

For example, if you are reporting on timeline entries, and you have a picklist on them and want to answer “in this subset of timeline entries, how many different picklist values from [field] were used?” you would not be able to do that. Your picklist would need to be converted into a string field, which would involve either doing the whole thing in Data Designer, using a rule to convert your picklist to string data in another field, or not using picklists to begin with.

 

If you do end up using a string field instead of a picklist, regardless of the method you use to get there, you lose the functionality of a picklist, especially in filters.

3 replies

jordan_cook
Forum|alt.badge.img+2
  • Contributor ⭐️⭐️⭐️⭐️
  • 46 replies
  • January 28, 2022

Just ran into this need today. I wanted to count up the number of field values used. Count Distinct is not an option.


benwanlessmenlo
Forum|alt.badge.img+4
  • Contributor ⭐️⭐️⭐️⭐️⭐️
  • 115 replies
  • October 13, 2022

It would also be useful to enable count unique/distinct values for Boolean fields.

 


benwanlessmenlo
Forum|alt.badge.img+4
  • Contributor ⭐️⭐️⭐️⭐️⭐️
  • 115 replies
  • October 13, 2022

I was just going to add that I noticed in Rules Engine I can use Count_Distinct on a boolean field. It is only in Reports that this option is not available.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings