Satisfaction Survey results

It averages the scores and puts them in the rating field as one value, like you said... it could be possible to do a query of the text that gets put in the comment field of each ticket and parse it out like you showed.

In the workitem_detail_view view of the database, I've only ever seen the individual scores within the workitem_comment field of the row that is the version of the ticket when the satisfaction survey was completed. My SQL abilities are not levelled-up enough to quickly write something that parses out the individual score. However, our satisfaction reports simply rely on the average that lives in the workitem_rating field, not the individual scores.

I'm (slowly) finishing up an article on modifying the satisfaction survey to be more report-friendly.  Included in the customization is a report that will break out scores for individual questions by worker.  I'll try to remember to post back when it's finished.

So the single article I was working on ended up splitting into two - one for customizing the report and the other for reporting on the new data.

The articles were submitted today, and I'll be sure to post a link to them back here when they are published.

Thanks for the heads up...Joe

That will be great!  Please do post back when the  articles get published!  Thanks

bgreen's first article has been published and you can see it here: http://www.symantec.com/connect/articles/building-...

The second article will be posted soon!

Thanks!
Cheryl

You rock :D

And now Part Two is available here: http://www.symantec.com/connect/articles/building-...

Happy reading!

Just to confirm both of those articles look like they will acomplish what you are wanting to do. I am going to play with them next week.