Grouping data in charts in WebI
Recently I came across a requirement wherein we had to show 2 different colors on the same chart (blue and yellow) for one dimension which has 7 different values.
Ex: Mon, Tues, Wed, Thurs, Fri, Sat, Sun are the dimension values. The customer wanted the value on the chart for Monday coming in Yellow whereas for others in blue.
This is only possible in SAP BO 4.0 + as there is an option on the chart to put formulas in charts. This is the way I achieved it. Below is the sample table I created from efashion to demonstrate the way I did it.
Then I changed the above table to column chart.
Notice I have set the graph to change colors based on the state. Hence for each state I will get a different color. After this I used a simple formula for grouping
In the State Dimension, i placed a formula like if([State]=”California” then “California” else “Other States”. This formula will group California and remaining states as 2 different sub-sets of data on the graph as seen below.
In a similar way I achieved the desired reults for me showing yellow color bar for Monday in each week and blue for other days in the week so that the customer can easily understand the beginning of the week when they look at the chart directly.
Hope this helps you in some way.