Forum Discussion
Ramendra
Helper IV
Helper IVRunning net promoter score
Hi team, I want to make a graph where I want see the nps progress from day 1 to current day for a current month. I don't want nps per day but I want running nps. For example if first day positive, ...
RamendraHelper IV
Helper IVHi,
Thankyou for your help amitchandak .
Yes the calculate function is working fine if I want to see cumulative NPS for a month as per my requirement.
But I am not able to identify what to do to see the next level of same hierarchy which is like , I want to see the cumulative NPS for this month in three cotegories like morning status , afternoon status and then evening status.
Is there any way to add hours in date heirarchy like filter(date,date[hour] to get the result
amitchandak
Super User
Super UserRamendra , Can you share sample data and sample output. I will try
- Ramendra
Hi Please find Sample input and expected output format
Happy number TASK number Created Score Type Vendor HAPP00001 Task0001 01-04-20 0:00 Positive X HAPP00002 Task0002 01-04-20 1:00 Positive Y HAPP00003 Task0003 01-04-20 2:00 Positive Z HAPP00004 Task0004 01-04-20 3:00 Positive Z HAPP00005 Task0005 01-04-20 4:00 Positive X HAPP00006 Task0006 01-04-20 5:00 Negative Y HAPP00007 Task0007 01-04-20 6:00 Negative Z HAPP00008 Task0008 02-04-20 7:00 Negative Z HAPP00009 Task0009 02-04-20 8:00 Negative X HAPP00010 Task0010 02-04-20 9:00 Negative Y HAPP00011 Task0011 02-04-20 10:00 Negative Z HAPP00012 Task0012 02-04-20 11:00 Positive Z HAPP00013 Task0013 03-04-20 12:00 Positive X HAPP00014 Task0014 03-04-20 13:00 Positive Y HAPP00015 Task0015 03-04-20 14:00 Positive Z HAPP00016 Task0016 03-04-20 15:00 Positive Z HAPP00017 Task0017 04-04-20 23:00 Positive X HAPP00018 Task0018 05-04-20 15:00 Positive Y HAPP00019 Task0019 06-04-20 15:00 Neutral Z HAPP00020 Task0020 07-04-20 15:00 Neutral Z HAPP00021 Task0021 08-04-20 15:00 Neutral X HAPP00022 Task0022 09-04-20 22:00 Neutral Y HAPP00023 Task0023 10-04-20 15:00 Neutral Z HAPP00024 Task0024 11-04-20 15:00 Neutral Z HAPP00025 Task0025 12-04-20 15:00 Neutral X HAPP00026 Task0026 13-04-20 15:00 Neutral Y HAPP00027 Task0027 14-04-20 15:00 Neutral Z HAPP00028 Task0028 14-04-20 3:00 Neutral Z HAPP00029 Task0029 14-04-20 8:00 Neutral X HAPP00030 Task0030 14-04-20 12:00 Positive Y HAPP00031 Task0031 14-04-20 15:00 Positive Z HAPP00032 Task0032 14-04-20 15:00 Positive Z HAPP00033 Task0033 14-04-20 15:00 Positive X HAPP00034 Task0034 14-04-20 15:00 Positive Y HAPP00035 Task0035 14-04-20 15:00 Positive Z Sample output
Month Apr-20 Date 03-Apr-20 Time NPS till the time for this month 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 x NPS Value NPS Value NPS Value NPS Value NPS Value NPS Value NPS Value NPS Value NPS Value NPS Value NPS Value NPS Value NPS Value NPS Value NPS Value NPS Value NPS Value y NPS Value NPS Value NPS Value NPS Value NPS Value NPS Value NPS Value NPS Value NPS Value NPS Value NPS Value NPS Value NPS Value NPS Value NPS Value NPS Value NPS Value Z NPS Value NPS Value NPS Value NPS Value NPS Value NPS Value NPS Value NPS Value NPS Value NPS Value NPS Value NPS Value NPS Value NPS Value NPS Value NPS Value NPS Value