Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

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

Received Response
72
Views
5
Comments
DollyG
DollyG Rank 5 - Community Champion

Hi,

My current stracked graph is:

StackedGraph.PNG

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

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner
    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
    Robert Angel Rank 8 - Analytics Strategist

    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
    DollyG Rank 5 - Community Champion

    Hi Robert,

    My requirement is to create a clustered stacked graph:

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

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    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.

  • 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).