Skip to main content
Contributor ⭐️
Dec 2, 2024 4:19 PM UTC
Question

Report with counts of individual dropdown items

I’m building an activity report based on activities submitted by our CSMs that include a dropdown list, where multiple items can be selected. I’d like to have the report show a count of submissions that count the number of individual dropdown items, not the combined amount of dropdown items. For example, I’d like it to show this:

Count of dropdown 1: ###
Count of dropdown 2: ###
Count of dropdown 3: ###

Instead, it’s showing this, which is too cluttered:

Count of dropdown 1: ###
Count of dropdown 1;dropdown 2: ###
Count of dropdown 1;dropdown 2;dropdown 3: ###
Count of dropdown 1;dropdown 3: ###
Count of dropdown 2: ###
Count of dropdown 2;dropdown 3: ###
Count of dropdown 3: ###

Is it possible to do this in the Report Builder? Thanks!

2 replies

Padolfi
Contributor ⭐️⭐️⭐️⭐️
Dec 3, 2024 7:48 AM UTC

Hi ​@stevej! 

The only way I found to handle this is a Data Design that either uses transforms to filter individual values and then does a union of each branch obtained, or a Pivot table that already does the grouping and counting in one step. 

The pivot table won’t give you the possibility of drilldown while the Transform+Union does. 

Translate
Padolfi
Expert ⭐️
Dec 4, 2024 8:40 PM UTC

A little bit slicker solution is to store each option as a new row in a different table. Then bring in the that data and cartesian merge with your data and then do a filter where if multi select contains the row value in the new object.

Translate