I believe this is rather easy to accomplish in Excel, but I’m struggling in Gainsight both with the Report Builder and even with Data Designer. Here’s an example:
I want to report on a rolling 3-month CSAT average, shown week over week. Right now I only have a few weeks’ worth of data, so here’s what I’m dealing with.
- Week 1 (let’s say 11/1-11/7) had scores of 5, 4 and 3
- Week 2 (11/8-11/14) had scores of 5 and 5
- Week 3 (11/15-11/21) had scores of 5 and 3
When putting “Avg CSAT” in the show and “response date” in the by, our report builder shows that as an "average" CSAT as 4.0, 5.0 and 4.0 for those three respective weeks - i.e. it’s putting each week in a silo.
Whereas I want to see it as 4.0 for week 1, then 4.4 for week 2 (5+4+3+5+5=22 (total score) divided by 5 responses), then 4.29 (5+4+3+5+5+5+3 = 30/7) for week 3. Has anyone figured out a creative solution for this?