Always Red Report - Data Designer?

  • 9 October 2020
  • 1 reply

Userlevel 3

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.



1 reply

Userlevel 7

Hi @jriva - interesting use case. 


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.