Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 43 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 278 Oracle Analytics and AI News
- 54 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 19 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
How to combine stacked bar graph in OBIEE 12c for multiple dates
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.
Answers
-
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.
0 -
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.
0 -
Hi Robert,
My requirement is to create a clustered stacked graph:
Can u please let me know how to create it in obiee 12c?
0 -
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.
0 -
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).
0
