Dashboard data - mapping 2 fields from the same survey into 1 field | XM Community
Question

Dashboard data - mapping 2 fields from the same survey into 1 field

  • 1 March 2024
  • 2 replies
  • 22 views

Userlevel 3
Badge +11

I am mapping in historic surveys and need to map 2 questions into 1 field (in the past we asked for a CSAT on invoicing and a CSAT on billing, this year it’s combined into 1 CSAT asking about billing/invoicing). I have a widget on the dashboard where we see year over year trends so I am wanting to combine the historic separate questions into a single field.


2 replies

Userlevel 6
Badge +21

Hello @kgillis ,

You can attempt to add an embedded variable and map the answers from both separate questions into it. Subsequently, you can utilize the same variable in the dashboard.

Userlevel 5
Badge +11

Are you trying to take the mean of billing and invoice combined?

If thats the case you can go to the field editor section

 

and add the below formula.

 

 

So you can report this as combined score. You need to change the widget variable to the newly created one.

 

Leave a Reply