Reporting on dropdown choices

[KAM30]

Is it possible to create a report that shows the choices in a Dropdown field?

For example, I have a form that has a field with 120 choices. I like to create a report that shows all 120 choices for Field 1, even if it’s never been selected.

We are trying to clean up the list, e.g., determine what fields haven’t been used, verify there are not ones that have similar names, etc.

I found this post - https://experienceleaguecommunities.adobe.com/t5/workfront-questions/is-there-a-way-to-report-on-the... – but I’m not following the text mode.

Thanks for any suggestions!

[Madalyn_Destafney]

Hi, what is you pull that form field into a report filter with ‘is not blank’ and group it by the same field too so you can get all results that have an answer and also how many times the answer is used (shown in report groupings) depending on the timeframe of your report filter…

[KAM30]

Thanks Madalyn, but this only shows me the ones that were selected. I'd like to see all choices. 

[skyehansen · Accepted solution]

It kind of feels like you are just asking to make a parameter (aka custom field) report, filtering for that one field and including a column that shows the options. If so, this post might be more useful:

https://experienceleaguecommunities.adobe.com/t5/workfront-questions/managing-custom-fields/m-p/4765...

The textmode was included in the original post but with all the linebreaks stripped out, so I'm including a tidier version below. (pick your favorite list delimiter to make this work)

displayname=Choices
listdelimiter=
listmethod=nested(parameterOptions).lists
textmode=true
type=iterate
valueexpression=CONCAT({label},";",{value})
valueformat=HTML

[KAM30]

Thank you Skye for your help and cleaning up the text mode! That worked great!