I've done this many times and YES it involves as many business rules as you think it does. The saving grace here is that you can copy business rules. Luckily you only have three choices. So as you said, 3 questions, 3 choices, you need 9 rules. Just bite that bullet and make the 9 business rules to set the three integer fields (of course these fields should not appear on the customer form, only the agent form). Then you need a 10th business rule to calculate the Total Score by adding up all the integer fields and dividing by three. It shouldn't take too long. Maybe 15 minutes with a 3x3 survey.
i was afraid of that Kam. For this piece - " Then you need a 10th business rule to calculate the Total Score by adding up all the integer fields and dividing by three." - i was actually going to do this as an aggregate value in the report, but do like this approach as well. THANKS!!
Are you trying to do this for an ex-SDE customer? We used to do this for calculating the survey score and then sending out a notification if the score was below a threshold.
While you can obviously replicate this, what I tend to recommend is we dont score a survey in this method anymore. Instead, if any question is answered with a "Did Not Meet Expectations" then I send a notification.
nope, they are a spiceworks customer.
The thing is that I want them to have the metrics for each question, and average that out across time. This way I can use the overall average score that each assignee gets on each question. Just because the tool doesnt handle it as cleanly as I like, i'm not going to back out of a good practice.
Thanks for your input! It seems like Business Rules are the way to go, i was hoping someone had some sort of magic bullet to consolidate the logic and prevent 9 rules.