Can you create calculated variables/values in EX Dashboards? | Experience Community
Skip to main content

Can you create calculated variables/values in EX Dashboards?

  • January 17, 2023
  • 3 replies
  • 209 views
Nogstai
QPN Level 1 ●
Forum|alt.badge.img+6

I have an engagement survey that I need to compute the NPS score of a 5-point scale question.
Formula:
[ Responses with 5's - ( Responses with 1 + 2 + 3) ]
_______________________________________________
Overall responses
Can we create custom metrics or values with a specific formula in EX dashboard?
I saw in the support pages that it's possible for CX dashboards, but can't seem to see it in EX dashboard features.

    3 replies

    jmborzick
    QPN Level 5 ●●●●●
    Forum|alt.badge.img+41
    • jmborzick
    • QPN Level 5 ●●●●●
    • January 17, 2023

    Nogstai , Custom metrics aren't available in EX, but Subset Ratios might do the trick in this case.

    Nogstai
    QPN Level 1 ●
    Forum|alt.badge.img+6
    • Nogstai
    • Author
    • QPN Level 1 ●
    • January 17, 2023

    https://community.qualtrics.com/XMcommunity/discussion/comment/54103#Comment_54103It worked for individual responses, but I wasn't able to create a formula where I can subtract the 1-3 rating. :(
    Thanks though!

      patlestes
      Level 1 ●
      Forum|alt.badge.img+1
      • patlestes
      • Level 1 ●
      • October 3, 2023

      https://community.qualtrics.com/XMcommunity/discussion/comment/54103#Comment_54103It worked for individual responses, but I wasn't able to create a formula where I can subtract the 1-3 rating. :(
      Thanks though!

      It’s bizarre to me that there are so many math functions available in multiple parts of Qualtrics, but no where have I found (in Stats IQ, data table/editor, dashboards, etc.) the ability to substract one value/variable from another. This would be an incredibly helpful function to have for numerous reasons and I’m frankly surprised Qualtrics doesn’t provide the ability to calculate differences in scores within a widget in a dashboard (e.g., table widget, using a calculation column or row).

       

      Pat

        Terms & ConditionsAccessibility statement