How to get 3 measures to display as 3 columns in chart?

building reports webintelligence
1

Hi all,

I have a report that utilizes three measures, along with a dimension to display in three (one for each measure) columns in a stacked vertical bar chart. What I get when I build the chart the usual way is one column each for each of the dimension values, rather than one column each for each of the measures. How can I “rotate” things so that the columns represent each of the measures, and each column displays the percentage that each dimension value contributes to the total? Let me know if I’m not being clear.

Thanks.

Robin

bobonita (BOB member since 2009-08-06)

2

Does anyone have any suggestions that might point me in the right direction on this, even if you don’t have the complete answer?

Thank you!!

Robin

bobonita (BOB member since 2009-08-06)

3

HI,

I too have same requirement.

Anyone have any solution or a possible clue on to how have Measure objects on the X- axis.

Thanks
MUnikumar

nagas (BOB member since 2009-03-18)

4

It can be done (charts in BO are dangerous to make a statement like this).
Attach a sample set of data. I will have a better view of the data and the request you have mentioned.

KhoushikTTT :us: (BOB member since 2005-02-24)

5

What kind of measure object are you having in your production databse that should be presented in X-axis.

The previous request was not presenting measure objects in X-axis!

KhoushikTTT :us: (BOB member since 2005-02-24)

6

HI,

Thanks for your Quick reply.

Please refer the attached image.

All the numbers in Red color indicates variables calculated at report level. and all the varibale logics is same as

=Count(Case Number) where Status=“ABC” and Type = “Shipper”
=Count(Case Number) where Status=“ABC” and Type = “Network”

Similarly all variables have some different status in variables like ABC in above. So all these variables are converted as MEasures.

Please sugegst how can i get the attached graph.

Thanks
Munikumar
Graph expected.zip (14.0 KB)

nagas (BOB member since 2009-03-18)

7

HI Robin,

Do you have any clue for me. Let me know if my requirement is not clear.

Thanks
Munikumar

nagas (BOB member since 2009-03-18)