Skip to Content

Conditional bar chart in WebI

Hello,

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.

Thanks,

Vishal.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 27, 2015 at 11:02 PM

    HI, can you share a mockup of what you're expecting?

    regards,

    ROgerio

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 27, 2015 at 09:48 PM

    Hi Vishal,

    This is a tough one, please sign up on BI Ideas, check out these ideas and Vote up on them, so that, SAP implements Alerters in Charts as a feature.

    Conditional Formating (fromer Alerter) on graphs : View Idea

    Change color of single bar in a bar chart : View Idea

    Thanks,

    Mahboob Mohammed

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 27, 2015 at 10:44 PM

    Hi Vishal,

    On a second thought, I was able to get it like this. Do you this works for you? Can you persuade the users to live with this?

    • In the Bar for Small (category), we're seeing Percent (i.e., Profit / Total Profit for that category).
    • In the Bar for Medium (category), we're seeing the actual Profit value.
    • In the Bar for Large (category), we're seeing just the Company.
    • Obviously, I included the sample data that I'm using, its exactly what you have.

    Hint: Those are 3 Tree Maps (1 for each category) 😉

    Let me know what your users thinks and if you want to proceed this way.

    Thanks,

    Mahboob Mohammed


    Snap 01.PNG (29.5 kB)
    Add comment
    10|10000 characters needed characters exceeded