Is it possible to select the colour of a MashZone traffic light with one KPI parameter and select the shape of the shape of the traffic light using a different parameter?
I need to show the current RAG status of a KPI using the colour of an arrow and the current trend of the KPI by the direction of the arrow.
All ideas welcome.
John Wignall
Hi,
you can do this actually quite easily.
Imagine having 2 kpi columns as seen in the following screenshot.
What you have to do is to calculate a third kpi column (kpi_combined here) that encodes the former 2 kpi columns.
For example by doing this: kpi_combined = kpi_status * 100 + kpi_trend.
Use the resulting kpi_combined column with your traffic light component and define thresholds like in the second screenshot.
This way you describe a status for all possible cross products of 'status' and 'trend'.
Regards
Thanks. A very simple solution which does exactly what I need.
John Wignall