How to combine stacked bar graph in OBIEE 12c for multiple dates

DollyG

Hi,

My current stracked graph is:

Currently, data is populating for September, once data of October will appear, 2 more bar graphs will appear alongside and number of bars will keep on increasing in this manner.

So, can anyone please guide me the best way to create bar graphs for this case.

help will be highly appreciated.

[Deleted User]

DollyG wrote:Currently, data is populating for September, once data of October will appear, 2 more bar graphs will appear alongside and number of bars will keep on increasing in this manner.

So..what? You want them also as stacks? Not sure if I misunderstand you  because you just pull the moth column into "Vary By Color" and that's it.

Robert Angel

Guess 1 - you want only one graph but many periods - answer; go to display on the graph display and drag the period into the 'Not Displayed Area'

Guess 2 - you want only the current month / selected month - answer; add a filter to your report month field and create a corresponding prompt to drive its content

Guess 3 - you want all months and want them differentiated on the stacked barcode - see Christian's answer

Guess 4 - you want something else - answer; provide a less vague specification of what you want than -> 'please guide me the best way to create bar graphs for this case'

Kindly note there are some very knowledgeable people here who don't mind sharing their knowledge, but usually are not keen on guessing games, so the best way to get the most out of this board is to provide specific detail on your exact requirement and what you have tried to do.

DollyG

Hi Robert,

My requirement is to create a clustered stacked graph:

Can u please let me know how to create it in obiee 12c?

[Deleted User]

That's simply not how the tool works. It does what you see. If this is an absolute requirement then go for D3 or JET.

Gianni Ceresa

By ordering the columns you use on your X axis correctly you get the same, with axis labels not grouped and without the big spacing in between products.

But you get the same kind of output ... from an information point of view ...

As said by Christian: if you want exactly that then a JS charting library like D3 is what you look for (OBIEE is a web page in the end).