How to customize Data Markers

Question

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?

Jerry Casey · Answer

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

Kari_100683-Oracle · Answer

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:

Jerry Casey · Answer

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: