Oracle Analytics Cloud and Server

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

How to Display Total at the Top of Stacked Vertical Bar Chart

Received Response
252
Views
6
Comments
User_S35K3
User_S35K3 Rank 4 - Community Specialist

Hi,

I am working on OBIEE 12.2.1.3.0. I am facing an issue while creating while creating Stacked Vertical Chart I am not able to show the total of stacked values on the top of Bar. This is same like as the total of any value is showed in table. I am also attaching screen shot of the issue.

Answers

  • Shane.S
    Shane.S Rank 2 - Community Beginner

    Hi,

    Someone may come in with a quicker solution, but you could create an additional measure with a formula which just adds each of your other measures together (acting as a subtotal) and stick that measure value at the top

  • Jerry Casey
    Jerry Casey Rank 6 - Analytics Lead

    This is as close as I can get using OOTB tools. It's a stacked line-bar graph, with the line-style set to width=0px and symbols turned off.

    I offset the line scale to raise the data markers.  I left the scale visible so you can see the offset, but I would make it invisible in the final version

    pastedImage_0.png

  • User_S35K3
    User_S35K3 Rank 4 - Community Specialist

    Hi,

    So looks like directly it is not possible

  • User_S35K3
    User_S35K3 Rank 4 - Community Specialist

    Hi,

    Can you please share a document of your work around, as I did not find stacked line-bar graph option in OBIEE.

  • Jerry Casey
    Jerry Casey Rank 6 - Analytics Lead

    I'm working in 12.2.1.4.0.  Line-Bar is one of the standard graph options, and "Stacked" is an option:

    pastedImage_0.pngSet-up looks like this:pastedImage_1.png

  • User_S35K3
    User_S35K3 Rank 4 - Community Specialist

    Hi,

    Thanks Jerry. I was looking the option in Bar Chart.