IBM Business Analytics

Hi All,

We have a requirement to RAG rate % SLA in a bar chart in the same way that you would do it in Report Studio for a regular report. So for example if % SLA >= 95% then 'G', when >= 90% then 'A' else 'R'. In dashboards there is no capability to do this so I thought that if I create an indicator with the RAG logic and use that to colour the bars in the chart then that should work. This approach doesn't really deliver what I need and it only partially works. As there will be a RAG rating for every line in the data down to the most granular level the indicator sort of needs to work after aggregation so that users can look at the data by day, month, quarter, department, employee and so on and get an accurate RAG rating. It's frustrating that IBM havent thought to add this capability. It does exist in the KPI widget but I need it in a bar chart. Does anyone have any ideas on how this can be achieved. If Cognos Paul is reading this then this would be a cool thing for the CogBox ;)

Regards,

Eric Mueller

No one has replied to this so I'm going to answer my own question here in case others have a similar requirements and struggle with the limitations like I did. To implement a RAG rating in a bar chart within dashboards one method is as follows:

1) Create a calculation which results in a low, mid and high point based on a % range as an example. Here 2 = Green, 1 = Amber, 0 = Red. This needs to happen after aggregation so apply that setting.

Case

when [My Metric] >= 0.8 then 2
when [My Metric] between 0.75 and 0.79 then 1 else 0

end

2) Now create a custom heat pallet so your high point is green, mid point is amber, the low point is red
3) Drag your calculated data item into the column color field

So in my screenshot above there is no mid point set up but hopefully this illustrates the concept of how you might go about RAG rating a bar chart in dashbords. In a perfect world it would be good if IBM added properties to apply conditional formatting to more than the KPI widget and crosstabs. Hope this helps someone out there resolve a similar problem. This could of course be an obvious solution and I just failed to understand the capabilities we have in CA.