Add "Count" aggregation for optional fields
I have an optional field that is a dropdown list of options. When grouping on that field, I'd like an easy count of items with that selected dropdown option.
I use this to mark tasks with appropriate support type which aligns with support contract. Certain classifications are allotted so many contacts per year. If I can get a count, I can see if the contact is billable or not.
Hi Rob, thanks for sharing your use case! This is interesting, and I'd love to learn a bit more. Is your end goal to see how many tasks have a certain option from the dropdown selected? If so, it's possible to see this count when you filter tasks by that specific answer:
Would this help? Looking forward to hearing your thoughts on this!