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
J Kirsch on
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