Streak Value calculation for a KPI

[chiru_thota]

Hi All,

Any ideas to calculate streak value easily ?

o   We need to calculate a Streak value for each KPI.

o   For example we have a KPI that has been green (Better or equal to Goal)  for the last 3 weeks then the Streak should be G3.

o   Similarly for Red /Yellow. Like bellow:

  o

Thanks,

Chiru

[agni_gold]

Go to properties of the table or chart and under visual clues , you can write the conditions.

[chiru_thota]

Any other Ideas ?