Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

OBIEE 11g - Showing percentages on a graph/line bar

Received Response
232
Views
4
Comments
Dravel
Dravel Rank 1 - Community Starter
edited Aug 13, 2024 5:19PM in Oracle Analytics Cloud and Server

Hello,

This is my first post here, so hopefully I am posting in the right place.

I have an analysis with which I want to display a bar/line graph. I am trying to display a line to show the change in yes/no rate, while the bars represent the volume of both.

I am using two identical measures, one showing data as values and the other as percentage of the column parent. My table is as I want it (though I just care about the "yes" rate and could make without the "no"l rate) but I cannot get the graph to display what I want.

The line remains at 1% instead of varying according to the rate.

This is with using a "graph pivoted result". I tried with a standalone graph, as well as with using calculated measures, but none of them gave me the results I want.

Could you please let me know how best to achieve my goal? Is there a way to indicate that the line should only show the column "Rate.Yes"?

I am a beginner with OBIEE so my understanding is still very basic.

Thanks.

image001 (1).png

Answers

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

    Not really sure what your "rate" is supposed to be there and how you calculate it since you only show the result but not the model or formulae, but those are precisely the kind of things you must ahve an issue with because what you're asking for - at least what it sounds like from the very vague description - is extremely basic functionality that just works ou of the box.

    pastedImage_0.png

  • Jerry Casey
    Jerry Casey Rank 6 - Analytics Lead

    Hi Dravel,

    This is a stacked line-bar pivot table and chart that performs as you've described.

    pastedImage_0.png

    The key is that the calculated percentage column, in this case "Consultant Hrs Pct" is showing the correct amount prior to producing the chart.

    You may need to produce 3 calculated columns: a "Yes Volume" column, a "No Volume" column, and a "Yes %" column.

    You can either use a case statements or a filter formulas to produce the Y/N columns,, and those columns to build the Y% column.

    Jerry

  • Dravel
    Dravel Rank 1 - Community Starter

    Hello,

    Thank you for your reply, I will try what you suggested.

    I guess my issue is that I have only one single measure, which can have the values of either Yes or No (well, approved or refused), and which are sorted based on their status under a column "Decision" (called Volume here).

    I will follow your tip and try to get a filter formula that works to create different columns then.

    Thanks!

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner 
    Dravel wrote: I have only one single measure, which can have the values of either Yes or No (well, approved or refused),

    ....which makes it an attribute and not a measure.