OBIEE12c:How to select different graphs using radio button?

Kari_100683-Oracle

Hi,

I'm using OBiee12.2.1.4.0. I've a requirement to create a bar graph view with toggled functionality.

Below are the columns in my subject area:

Items, Price, Amount_paid, Balance

I've to create a toggle to switch between 'Price' & 'Balance'.

• If toggled to 'Balance', show bar graph view with top items(x-axis) with greatest outstanding Balance(y-axis).
• If toggled to 'Price', show top items with greatest price(y-axis)

Any suggestion or direction on how to proceed on this will be really appreciated.

Gianni Ceresa

You can use a "view selector" if you need 2 very different views, or a "column selector" if the charts are the same once you replaced a column by another.

Kari_100683-Oracle

I've already tried "view selector" and was having issues with sorting columns based on selected view.

In my snapshot, I've applied sorting on "Total Price for sort" and "Balance for Sort" columns. When I toggle to "Balance", it still shows the graph in desc order wrt to Total Price only. I'm not sure how sorting on columns should change based on view selection.

Attaching screenshots for reference.

Kari_100683-Oracle

Jerry Casey

Another option is to create two separate queries for the specific graphs. Use a dashboard prompt that sets a presentation variable for say, "varGraph", with two radio buttons, "Price" and "Balance". In the query filter for Price, include the filter:

'Price'='@{varGraph}{Price}' (if Price is your default)

In the Balance query, include a filter for:

'Balance'='@{varGraph}{Price}' (again, if Price is the default)

Use section Conditions to open the operative section.

Kari_100683-Oracle

Thanks Jerry for your reply. I tried this option. However it refreshes the complete dashboard and we don't want this.