Using the new Results: can't select question when trying to visualize average

Wow, I forgot I asked this question. No one has any answers for me?

Make the field as number set. Please check this.

Starting with Shashi’s suggestion, I found this: https://www.qualtrics.com/support/vocalize/dashboard-settings-cx/dashboard-data/data-compatibility/ . I can’t figure out how to change the data type for the survey question. In the data table under “Data & Analysis”, it gives me the option to view the answers as numeric values (the recode values). I’m not sure why I can’t use those recode values to create the gauge chart.

Apparently in a Survey Project Results Dashboard you are unable to change the data type/field type: https://www.qualtrics.com/support/survey-platform/reports-module/results-dashboards/results-dashboards-widgets/#QuestionFieldTypes

This didn’t use to be the case, as I had built tables that used averages of recode values per question that no longer work. I get the same error message as you. Frustratingly these calculations work fine in Reports visualizations, so I don’t know why it is different in the supposedly new and improved interface.

I have discovered a workaround for this issue, which is to use the Field Editor on the Data & Analysis tab to create a corresponding Formula Variable for each question: https://www.qualtrics.com/support/survey-platform/data-and-analysis-module/data/add-new-fields/formula-variable-creation/

This new field will have a numeric value set by your recode value, which you can then use in metric fields in your dashboard. I’ve attached a screenshot of how I set up one of these. It is a huge pain to have to do this for every question, but I can at least confirm that it works.