Recoding likert-scale to a 10-point scale | XM Community
Skip to main content
Michael_Cooksey
Administrator
22 days ago
Solved

Recoding likert-scale to a 10-point scale

JohannesCE
Level 6 ●●●●●●
Forum|alt.badge.img+12

Hi! I have likert-scale questions in my survey that I would like to show as 10-point scores in my dashboard. In other words, in the dashboard I would like to show the responses to a statement such as “I am satisfied with the service” as a score (for example 7,9) and then compare it to our benchmark.

Completely aree = 10

Agree: 7,5

Neutral: 5

Disagree: 2,5

Completely disagree: 0

Don't know: null

Recoding does not allow for decimals, so I cannot for example recode “Agree” as 7,5. One solution would be to make it a 100-point scale, so making “Aree” a 75 and “Completely agree” a 100, but that's a last resort.

Also, I'm wondering if it's more efficient to do the recoding in the survey environment or in the dashboard. Perhaps it's not even necessary to recode, but I could add a custom calculation?

Best answer by CxEx

You can go to dashboard seetings -- data set source. Select variable, click on manage labels and assign your recorded value to the variable. 

 

View original
PeeyushBansal
TusharDalwani
2 people like this
  • PeeyushBansal
    PeeyushBansal
  • TusharDalwani
    TusharDalwani

6 replies

Deepak
QPN Level 8 ●●●●●●●●
Forum|alt.badge.img+44
  • Deepak
  • 1549 replies
  • April 20, 2023

You should be able to do this on dashboard easily.

 

JohannesCE
Level 6 ●●●●●●
Forum|alt.badge.img+12
  • JohannesCE
  • Author
  • Level 6 ●●●●●●
  • 144 replies
  • April 20, 2023

Hi @Deepak, good to know! Could you elaborate on the how? In de Dashboard Data view or in de Custom Metrics? Is it efficient to do it in de Dashboard Data view, changing the Field Type to Number Set, then in the Recode Editor recoding the Source with 2,5 etc?

It's just that I would have to do this again for each survey. Is there any way it to automate the actions?

CxEx
Level 5 ●●●●●
Forum|alt.badge.img+13
  • CxEx
  • Level 5 ●●●●●
  • 70 replies
  • Answer
  • April 23, 2023

You can go to dashboard seetings -- data set source. Select variable, click on manage labels and assign your recorded value to the variable. 

 

PeeyushBansal
JohannesCE
2 people like this
  • PeeyushBansal
    PeeyushBansal
  • JohannesCE
    JohannesCE
Deepak
QPN Level 8 ●●●●●●●●
Forum|alt.badge.img+44
  • Deepak
  • 1549 replies
  • April 23, 2023

@JohannesCE

JohannesCE wrote:

Hi @Deepak, good to know! Could you elaborate on the how? In de Dashboard Data view or in de Custom Metrics? Is it efficient to do it in de Dashboard Data view, changing the Field Type to Number Set, then in the Recode Editor recoding the Source with 2,5 etc?

It's just that I would have to do this again for each survey. Is there any way it to automate the actions?

 

It would be on dashboard data view, you can visit this support page for the How?. You would not need to change field type per say but if you would like to use widgets which support just number set I believe you can change them.

There wouldn’t be a way to automate this it’s just if you are mapping different surveys in one dashboard you do get an option to apply to all sources. Which you can leverage to make it near automated.

Hope it helps!

JohannesCE
1 person likes this
  • JohannesCE
    JohannesCE
JohannesCE
Level 6 ●●●●●●
Forum|alt.badge.img+12
  • JohannesCE
  • Author
  • Level 6 ●●●●●●
  • 144 replies
  • April 24, 2023

Thanks @CxEx and @Deepak.

  • I get changing the Field Type to Number Set and using the Recode Editor to change the Source to 0 / 2,5 / 5 / 7,5 / 10.
  • I also get using the Apply Recodes to all sources option
  • I also get that I can make a CSV and use the Import Recodes option to make it a bit faster

But wouldn't it be more efficient to recode in the survey itself, maybe not with decimals but with a 0-100 scale? That way it wouldn't be necessary to recode each and every question in the Dashboard Data. What am I missing here?

Deepak
QPN Level 8 ●●●●●●●●
Forum|alt.badge.img+44
  • Deepak
  • 1549 replies
  • April 24, 2023
JohannesCE wrote:

Thanks @CxEx and @Deepak.

  • I get changing the Field Type to Number Set and using the Recode Editor to change the Source to 0 / 2,5 / 5 / 7,5 / 10.
  • I also get using the Apply Recodes to all sources option
  • I also get that I can make a CSV and use the Import Recodes option to make it a bit faster

But wouldn't it be more efficient to recode in the survey itself, maybe not with decimals but with a 0-100 scale? That way it wouldn't be necessary to recode each and every question in the Dashboard Data. What am I missing here?

 

I presumed two things and hence recommended dashboard

1. You have already collected responses 

2. You mandatorily want decimals in your recodes 

Hence you can do it at survey level whole values if those two assumptions are wrong.

 

 

JohannesCE
1 person likes this
  • JohannesCE
    JohannesCE

Leave a Reply


Terms & Conditions