Question

Quarter to Quarter Overall Health score report with delta values

  • 27 February 2017
  • 3 replies
  • 42 views
lokeshraovn
Hi Folks,



I'm trying to build a Overall health score reports fr my CSM's - My requirement is as follows

Build a Average of Overall health score report for CSM's Quarter over Quarter

Get the delta of the Average health score between the quater and have this delta value on the report



EG - Consider i have a CSM



Q42016 - Overall health score - 78.09

Q10217 - Overall health score - 79.06



Delta - 79.06 - 78.09 = 0.97



I have been able to plot the Quarterly Overall health report for CSM, however i'm stuck at getting the delta values



I'm very new to Gainsight - Any help on this will be much appreciated.



Thanks!

~Lokesh

3 replies

dan_ahrens
Rank
Userlevel 7
Badge +2
Hi Lokesh, I've been working on some of the new capabilities with regard to data management in MDA and calculated fields are now supported very nicely in v5.5. In your example, the calculated fields will allow for in line formula calculation of delta and percentages. See sample below. 







Details on formula fields available here: https://support.gainsight.com/Product_Documentation/Data_Management_and_Integrations/Managing_Data_I... and in the v5.5 (February 2017) release notes



And specifically to your use case, since I'm your Gainsight CSM, I'll reach out via email to schedule some time this week to review this info and help solve your calculation challenge.



-Dan
VP of Customer Success at Forcepoint
ben
Rank
Badge
This is great! We have been thinking about this as well. Thank you for posting and thank you @Dan for the resources!
-Ben
lokeshraovn
Hi Dan,



I was able to follow the Link provided and i created a MDA object with 3 fields for my requirment - BaseLineScore, CurrentScore and DeltaScore

DeltaScore as BaseLineScore - CurrentScore



If you can let me know when we can setup a call to go over this it will be helpfull



Thanks!

~Lokesh

Reply


Terms & ConditionsCookie settings