Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Rolling 12 Month Measure

I am trying to make a report to calculate net promoter score based off of a survey sent to customers. My data has: a unique number for each response details about the person who responded the da...
Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    6 years ago

    Solved my problem using unpivoting. Made columns for each of the 12 months following the submission date and unpivoted it, then used the date as my x axis and measures as the y axis

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Solved my problem using unpivoting. Made columns for each of the 12 months following the submission date and unpivoted it, then used the date as my x axis and measures as the y axis

mchandler's avatar
mchandler
Frequent Visitor
4 years ago

I hope that this reached the person who posted this. I am tryiojg to accomplish the same as you are for NPS so that I can get a line graph that has the 12 month NPS score for each month.

 

January = February  1 2020 to January  2021 NPS Average

February = March 2020 to February  28 2021NPS Average

and so on.

I reviewd your answer hefre but I was not able to follow what you suggested if you could, would you go into a little more detail?

 

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    4 years ago

    Hi,

    Share some data and show the expected result.