Conditional bar chart in WebI
We have a table with the below details
S/N Company Category Profits
1 G Small 60
2 H Large 35
3 I Large 70
4 J Medium 80
5 K Small 40
6 L Medium 75
I need a column chart in Web-I4.1 which should show
X-axis : Category
3 bars for each of "Small, Medium & Large" count(here count value is 2 for each) and with a condition "differentiate the color of the partial bar if Profits less than 50 and the other partial greater than 50"
Y-axis : Total number of companies(here 6).
Considering the above table, the category "Large" has 2 as count and should show the partial bar with one color and the other partial with other color.
attached are two files :
The first one is the wid file renamed to .txt so I could upload it and the second is the data provided by you.
This was done in BO 4.1 SP5.