ChartsPLUS is an add-on for SAP BusinessObjects Design Studio which greatly enhances the visualization capabilities of Design Studio.
In this blog we look at how you can use ChartsPLUS for advanced conditional formatting in Charts.
ChartsPLUS provides the following options to do conditional formatting in Charts:
In the example below there are three bands defined for the conditional formatting rule, the first one is based on a static value, band 2 and 3 are based on measures defined within the datasource, this makes the conditional formatting rule highly flexible and can change based on the selection done within the datasource (filters, drilldown etc.).
The thresholds measures used in the rules does not have to be present in the chart,
In the example below each turbine has different threshold values, the threshold values are based on the measure ("Optimal" and "Over Specification") from the datasource, thresholds are also plotted (steps) on the chart.
Data set used for the chart above:
Another example of conditional formatting with guides in the chart background for displaying the "Optimal" value zone.
In addition to setting the column/bar/line colors you can also set a custom bullet (example below) for the series to represent the outcome of the conditional format rule.
Output of Chart based on negative fill color, all the negative variances are displayed as red (#CB1918).
Chart output based on the "Material Color" dimension value from the datasource above.
You can use the link below for more details on ChartsPLUS for SAP BusinessObject Design Studio. http://archius.com/products/chartsplus-for-sap-businessobjects-design-studio/
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
11 | |
9 | |
7 | |
6 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 |