Expand my Community achievements bar.

Interested in applying to or sharing a Workfront-related job opportunity? Check out the Workfront Job Board!
SOLVED

Reporting on dropdown choices

Avatar

Level 2

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!

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

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

 

0 Replies

Avatar

Community Advisor

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…

Avatar

Level 2

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

Avatar

Correct answer by
Community Advisor

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

 

Avatar

Level 2

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

page footer