Hi Qualtrics community :)
I have a secret shopper survey that i am importing the data into Qualtrics. The survey has aprox 5 buckets of multiple choice questions. Some have N/A as a possibility. I need to calculate a score based on how many possible points are available per block and overall. What is the best method? Each question has a possible score of 2 points. I need to have these scores in a dashboard. Here is an example:
INTERIOR
80% (8/10)
1. Was the floor clean? 2/2 Yes
2. Were displays clean? 2/2 Yes
3. Were accessory items pulled to the front, with no empty pegs? 0/2 No
4. Were demo phones working/live? 2/2 Yes
5. Was the music appropriate and at a good volume? 2/2 Yes
6. Were there any TVs present in the store and if so, were they turned on? (N/A if none present) 0/0 N/A
Creating Overall Scores for different blocks and a total
+1
+19You can create different scoring categories with only specific questions included in the scoring for each
+1I tried but How do I further calculate a score (%) that excludes n/as from possible total points?
+19Presumebly, you know what the total high score is for each block. You can then create formulas in your survey flow to calculate the %:
% Score 1 = $e { Score 1 / Block 1 High Score }
+1Thank you , I did that but the high score ranges depending if they pick N/As. Does the $e automatically add the block high score ?
+19Ah, not sure how to do that then
Sign up
Already have an account? Login
Welcome! To join the Qualtrics Experience Community, log in with your existing Qualtrics credentials below.
Confirm your username, share a bit about yourself, Once your account has been approved by our admins then you're ready to explore and connect .
Free trial account? No problem. Log in with your trial credentials to join.
No free trial account? No problem! Register here
Already a member? Hi and welcome back! We're glad you're here 🙂
You will see the Qualtrics login page briefly before being taken to the Experience Community
Login with Qualtrics
Welcome! To join the Qualtrics Experience Community, log in with your existing Qualtrics credentials below.
Confirm your username, share a bit about yourself, Once your account has been approved by our admins then you're ready to explore and connect .
Free trial account? No problem. Log in with your trial credentials to join. No free trial account? No problem! Register here
Already a member? Hi and welcome back! We're glad you're here 🙂
You will see the Qualtrics login page briefly before being taken to the Experience Community
Login to the Community
Welcome! To join the Qualtrics Experience Community, log in with your existing Qualtrics credentials below.
Confirm your username, share a bit about yourself, Once your account has been approved by our admins then you're ready to explore and connect .
Free trial account? No problem. Log in with your trial credentials to join.
No free trial account? No problem! Register here
Already a member? Hi and welcome back! We're glad you're here 🙂
You will see the Qualtrics login page briefly before being taken to the Experience Community
Login with Qualtrics
Welcome! To join the Qualtrics Experience Community, log in with your existing Qualtrics credentials below.
Confirm your username, share a bit about yourself, Once your account has been approved by our admins then you're ready to explore and connect .
Free trial account? No problem. Log in with your trial credentials to join. No free trial account? No problem! Register here
Already a member? Hi and welcome back! We're glad you're here 🙂
You will see the Qualtrics login page briefly before being taken to the Experience Community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.