Custom calculation on a dashboard | XM Community
Skip to main content
Solved

Custom calculation on a dashboard

  • September 25, 2018
  • 5 replies
  • 260 views

Marti
QPN Level 2 ●●
Forum|alt.badge.img+13
  • QPN Level 2 ●●
  • 42 replies
I have a calculation in my survey flow for a field based on questions answered. Once I get to the dashboard, I need to do a calculation that says if Field Name>5 then make Field Name2 5, otherwise Field Name2 = Field Name. Is this possible? We are trying to calculate the average of 5 dimensions, but not all dimensions will have a value so we want to divide by those that do. This has been a struggle so any help would be appreciated!!

Best answer by PeeyushBansal

If you have data ready in CSV you can import it back to Qualtrics by exporting example CSV and inserting this data to this example CSV file.
View original

5 replies

MohammedAli_Rajapkar
QPN Level 5 ●●●●●
Forum|alt.badge.img+20
We won't be able to write any logic/condition in the dashboard... Try to add the same calculation in survey flow and capture the information in embedded data. Then, in the dashboard use the embedded data to show the result.

Marti
QPN Level 2 ●●
Forum|alt.badge.img+13
  • Author
  • QPN Level 2 ●●
  • 42 replies
  • September 25, 2018
Unfortunately, we have 250,000 records that we just ran an API on and doing anything in the survey flow is not an option at this point :( Hoping there may be another workaround for it as we talked through this with Qualtrics before running the API and now seems there is an additional issue.

PeeyushBansal
Level 6 ●●●●●●
Forum|alt.badge.img+39
  • Level 6 ●●●●●●
  • 1148 replies
  • September 25, 2018
You can create custom metrics in vocalize , to do this go to data settings and than in custom metrics and by writting formula you can define your own calculation which on later can be used in widgets For any new variable, you can create embedded variablles in survey and can upload it in survey which on later mapping to dashboard can be accessed in widget

PeeyushBansal
Level 6 ●●●●●●
Forum|alt.badge.img+39
  • Level 6 ●●●●●●
  • 1148 replies
  • Answer
  • September 25, 2018
If you have data ready in CSV you can import it back to Qualtrics by exporting example CSV and inserting this data to this example CSV file.

  • 5 replies
  • September 12, 2019
Hello! I'd like to calculate index in the dashboard. How can I add calculation in the dashboard? For example, I create top-2-box in the dashboard of check-in, lounge and boarding, then I'd like to calculate Ground Service Index of each month by multiplied each service item with correlation figure and sum all the figures divided by sum of correlation figure. Check-in 84.1%*0.47 =39.4 Lounge 63.9%*0.46=29.3 Boarding 79.3%*0.56=44.0 then (39.4+29.3+44.0)/(0.47+0.46+0.56) = Ground Service Index =76.0 Kindly please advise how to create dashboard and add calculation. Thanks and best regards, Tick

Leave a Reply