random selection of lowest rated statements | XM Community
Solved

random selection of lowest rated statements

J
Hi,

I am new to Qualtrics and I have a survey with the following:

-----------

How would you rate your financial planner on each of the following statements:

[PROGRAMMER: RANDOMIZE]

Q8a. Being available at times convenient for you
Q8c. Being sensitive to your personal situation
Q8d. Listening carefully to your questions and concerns
Q8e. Demonstrating a warm and caring attitude
Q8g. Advising you about the right investment products and services for your needs
Q8i. Explaining financial matters in a way that you could understand
Q8j. Acting in your best interests
Q8k. Asking appropriate questions to understand your needs
Q8l. Being familiar with your accounts and business at RBC
Q8n. Discussing topics other than just advice on investing

Poor Superior Not Applicable
1 2 3 4 5 6 7 8 9 10 11


[PROGRAMMER: If respondent rated 1-6 on any of Q8a to Q8n, ask Q9 based on specific question. If a tie for lowest score, select at random.]

Q9. Earlier you gave a rating of [score] for [attribute]. What could your Financial Planner do to improve their performance in that area?

---

Basically, I have to determine the lowest rating (1-6) and then see which statements match the lowest rating value. If there is only one, then the one statement is selected. If there is more than one, then randomly select among those that match the lowest rating value. (see programmer instruction before Q9).
icon

Best answer by Akdashboard 6 July 2018, 18:26

View original

2 replies

TomG
Rank
Userlevel 7
Badge +27
You'll have to pipe all your ratings into either a web service or JavaScript that determines and sets embedded variables for the attribute you want to ask about. Personally, I would opt for a web service script unless it is in a loop & merge block in which case you would have to use JavaScript.
Akdashboard
Rank
Userlevel 7
Badge +6
@joemp - There are a few ways to achieve this without JavaScript. I demonstrated one of the ways in the attached .qsf (qualtrics save file a.k.a. a survey I built to demonstrate this). Save the .qsf and upload it as a new survey to understand what I did.

A couple of things - You only wanted to display a question for the respondent to provide feedback for only one of the categories they may have rated low. I would not recommend this and would either ask for feedback in all areas they rated low _or_ ask for feedback on how their performance could be improved agnostic of their rating. Not only is this by far the easiest to program, you also avoid potentially loaded question wording.

In any event, please refer to the .qsf for further explanation. Note - most of the programming is done in the survey flow section.

Feel free to PM if you have any questions.

Leave a Reply


Terms & Conditions