Hi,
I am working on a project where I have a block of 4 questions. 3 of these questions have a weight of 30% and 1 a weight of 10%. Each question is a multiple choice. Each choice has a decimal scoring associated. I need to calculate a score for the block.
I have 2 questions:
- what is the best design approach? scoring, weighting (survey or dashboard), custom metrics?
- I am planning to go with the use of custom metrics to achieve the block score through a dashboard widget. Use the survey question recode for assigning the decimal scores and use custom metrics in the dashboard to calculate the weight. But I found that I can't seem to add decimal numbers to the custom metrics formula. e.g. [(0.1*Q1score)+(0.3*Q2score)+(0.3*Q3score)+(0.3*Q4score)/4]
Thank you