You could use a calculation such as the following:
IF [SurveyData] >0 AND [SurveyData] <=6 THEN 'Dislike'
ELSEIF [SurveyData] >=7 AND [SurveyData] <=10 THEN 'Good'
ELSEIF [SurveyData] >=8 AND [SurveyData] <=10 THEN 'Very Good' END
The only problem I see is overlapping data. You may want to use a different scale, such as 1-5 for dislike, 6-7 for Good, then 8-10 Very Good.
Hope this helps! Have a great day!
*If this answered your question, please be sure to mark my response as helpful and answered.
Here I have attached screen shot and twbx file both. Please refer this.
IF [Survey]>=1 and [Survey]<=6 THEN 'Dislike'
ELSEIF [Survey]>=7 AND [Survey]<=8 THEN 'Good'
ELSE 'Very Good'
There are any ways to represent the survey data.
Please let me know if you have any question on this.
Please mark correct and Helpful if it works for you.
Survey.twbx 26.4 KB
Hi Angie Chubb,
No, i want to use same scale only, already i told that option but didn't agree with client.
I want to use same Scale only,
Good luck! I hope the calculation helps, using whichever values the client requests.