Can anyone help here to find how to calculate overall CSAT for all issues reported over period of time. I can give Time filter
But would like to get CSAT Avg on Gadget using eazyBI, same like we have under Reports Section for Satisfaction Report.
We do have one field which store Team Data, so I can add that as filter to gadget so if I change Team it gives Avg rating for that Team and total issues reporter under that team.
I dont want percentange as per per rating basis which I can get as per Issuers with Satisfaction date and Average Satisfaction with Satiscation date.
Basically I want Average Rating with percentage against issues where survey filled
I’ve got an average score by creating a user defined measure of just this.
“[Measures].[Satisfaction closed] / [Measures].[Issues with Satisfaction date]”
It looks like the “Satisfaction closed” measure will total up the score of all the scores, and divided by the other measure is just the amount of tickets that have received a rating.
The approach suggested by @Terry86 is very close to the suggestion below. The only difference is both metrics are tied to the same date - the issue resolution date.
I recommend the hidden measures “Satisfaction resolved” and “Issues with Satisfaction resolved” to calculate the average score:
[Measures].[Satisfaction resolved]
/
[Measures].[Issues with Satisfaction resolved]