Reporting on dropdown choices | Community
Skip to main content
K
KAM30
Level 3
March 14, 2023
Solved

Reporting on dropdown choices

  • March 14, 2023
  • 2 replies
  • 1457 views

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-choices-from-a-dropdown-field-to/m-p/511027#M42777 – but I’m not following the text mode.

 

Thanks for any suggestions!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by skyehansen

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/476537#M9366

 

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

 

2 replies

Madalyn_Destafney
Community Advisor
Madalyn_DestafneyCommunity Advisor
Community Advisor
March 14, 2023

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…

If this helped you, please mark correct to help others : )
K
KAM30Author
Level 3
March 15, 2023

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

skyehansen
Community Advisor and Adobe Champion
skyehansenCommunity Advisor and Adobe ChampionAccepted solution
March 14, 2023

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/476537#M9366

 

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

 

    K
    KAM30Author
    Level 3
    March 15, 2023

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

    Terms & ConditionsAccessibility statement

    Loading footer...