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

How to customize Data Markers

Received Response
62
Views
5
Comments
Kari_100683-Oracle
Kari_100683-Oracle Rank 3 - Community Apprentice
edited Aug 13, 2024 5:20PM in Oracle Analytics Cloud and Server

Hi,

I am using OBIEE 12.2.1.4.0. I have a vertical 2D bar graph analysis (X-Year,Y- Value) which currently on hover shows "Year" and "Value" as data markers. However, I want to show two more measures in addition to "Year" and "Value" when i hover on a bar.

How can I achieve this?

Answers

  • Jerry Casey
    Jerry Casey Rank 6 - Analytics Lead

    As long as your desired columns are at the same granularity, you should be able to add them to your "bar" drop area.
    This example is a scatter chart, but the same principle applies.

    pastedImage_1.png

    pastedImage_2.png

  • Kari_100683-Oracle
    Kari_100683-Oracle Rank 3 - Community Apprentice

    Thank you for your reply. I could see the two new columns on hover after adding them to "Bar" drop area. But the 2 new values are also visible in Horizontal axis.I want to display only Year value in X axis...

    pastedImage_1.png

    Also Is it possible to change the order in hover like

    Year

    Amount

    Col2

    Col1

    Currently amount is always shown last.

    pastedImage_3.png

  • Jerry Casey
    Jerry Casey Rank 6 - Analytics Lead

    The data values you wish to see should be in the "Vary colors by" drop area.

    You can change the order within the drop area, but the vertical axis measure will always be listed last.

    Here's an example:

    pastedImage_0.png

  • Kari_100683-Oracle
    Kari_100683-Oracle Rank 3 - Community Apprentice

    Thanks for the prompt reply. Much appreciated. I feel i'm closer to fixing this just last few hurdles...

    When I put data values (Col1,Col2) in the "Vary colors by" drop area it shows the sum of Col1 and Col2 values across all records. Refer to the attached screenshot:

    Ideally on hover for bar 2012, Col1 should be 121 and Col2 should be 30. Instead it is 133 and 33 respectively. Any idea on how can this be fixed?

    I could get it working if i 'Edit Formula'  of Col1 and Col2 and mark them as 'Treat as an attribute column' but then the rendered bars are shifted from the corresponding X axis labels. Refer the screenshot:

    pastedImage_2.png

  • Jerry Casey
    Jerry Casey Rank 6 - Analytics Lead

    You'll need versions of col1 and col2 that are aggregated at the same granularity as what you are charting.

    Based on what you've shown, the formula for "chart col1" would be SUM("table"."col1" by "Table"."Year Created").