I’m to create a report that will tell me all the customers who have always had a red overall health score, dividing them into 3 categories: more than 6 months, 3 - 6 months and less than 3 months.
I’m guessing Data Designer would be the best option to create this dataset using case fields? I’ve only just started using DD so excuse my ignorance.
Would Account Scorecard History of Fact be the right data source to choose? I’m having a hard time wrapping my head around which fields to use.
Thanks!
Hi
One idea here would be to filter the data in the Account Scorecard Fact History to only report on the red scores, and then count the number of weeks that the health score was red (assuming you are updating health scores weekly). So then you’d get a number for each account. >26 means it was more than 6 months, <13 equals less than 3 months and 13-26 is your inbetween time.
https://community.gainsight.com/events-office-hours-8
Will do
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.