Healthscore: Time in Color

  • 1
  • Idea
  • Updated 8 months ago
  • Under Consideration
Would be great to be able to report on how long a HS has been in a certain color.  So, for example, maybe I want to fire a CTA when the HS has been Red for X amount of days.
Photo of Heather Hansen

Heather Hansen, Champion

  • 9,404 Points 5k badge 2x thumb

Posted 8 months ago

  • 1
Photo of Dan Ahrens

Dan Ahrens, Official Rep

  • 25,952 Points 20k badge 2x thumb
Hi Heather,
This is an interesting use case. One way I can think of to solve for this would be to use MDA and bionic rules to create a tracking table that would consist of the following fields:
  • Account ID
  • Last period  (week or day depending on your refresh frequency) health score
  • Current health score
  • Date of last change
After setting all Accounts with the current health score, you'd then use rules to write the value in the current health score field to the last period field, write the actual current health score to the current health score field and then if the last period and current health score are not equal, update the date of last change with the current date (if the two fields are equal, leave the date of last change alone). 
(Edited)
Photo of Heather Hansen

Heather Hansen, Champion

  • 9,404 Points 5k badge 2x thumb
Thanks, Dan!  That's definitely a good idea.  I'll give that a shot.