Oracle Communities

Oracle Analytics and AI

Child Item

OAC - show values with 2 different granularities in the same viz

Hello,

There is a way to display the pourcents of a quiz on the same visualisation (Regional vs National) to avoid to duplicate them? I have many question to represent and putting all side by side it's not very pretty.

I would like to display the red values on the left graph also. Make a text box for each value (with a filter) it's not an option for me because I can apply a filter and sometimes I don't have all the values on the left side ( 3 bars on a region vs 8 bars on national version). All the static values are shifted each time.

I use 2 differents indicators for each visualisation (from a presentation table and a alias of the same table with different aggregation)

Any suggetions are welcomes: variables, calculations, all that OAC can offer for moment.

Thanks,

Daniel

Find more posts tagged with

Accepted answers

Mostafa Morsy-Oracle

@Daniel Vornicu

To display chart as you displayed I do not think there is a chart can achieve this (even for other competitors ) what we suggested is to give a near chart to your requirements but will not be 100% match

you also may visit custom extension https://www.oracle.com/business-analytics/data-visualization/extensions/

But again I can not find what matches your requirements 100%

All comments

Steve F-2

What about potentially using an overlay chart to display National vs. Regional?

Bar Graphs

https://blogs.oracle.com/analytics/post/how-to-create-a-rich-multilayer-visualization-in-oracle-analytics-cloud

Other comments, welcomed.

Mostafa Morsy-Oracle

@Daniel Vornicu

As @SteveF-Oracle Suggested but you can try the Horizontal 100% stacked bar chart

Daniel Vornicu

Hello @Mostafa Morsy-Oracle and @SteveF-Oracle

Can you explain me how I display the red percents(National) near the grey percents (Regional) on the same graph like in my picture using overlay chart or horizontal 100% stacked bar chart?

For my case I use mosly Pie charts et Horizonal Bar charts. Supposing that I have 2 indicators (as values not percents) and a question as dimension:

Presentation table 1 (regional agregation)

regional responses count - grey
question 1

Presentation table 2 (national agregation)

national responses count - red
question 1

Regards,

Daniel

Mostafa Morsy-Oracle

@Daniel Vornicu

you also may visit custom extension https://www.oracle.com/business-analytics/data-visualization/extensions/

But again I can not find what matches your requirements 100%

Steve F-2

@Daniel Vornicu

One idea is to create a calculated measure that filters based on your criteria (Regional and National), then use the two measure in the same horizontal bar vizualization.

In this simple example, the two measure filters are:

FILTER("PC0"."Revenue Metrics"."Revenue" Using "PC0"."Geography"."Region" = 'AMERICAS')

FILTER("PC0"."Revenue Metrics"."Revenue" Using "PC0"."Geography"."Region" = 'EMEA')

Maybe you can work something similar with your data.

You can also add notes and commentary, if you need to add contextual information.

Add Notes to a Visualization

Daniel Vornicu

Hello,

Like I said I already have the 2 mesures and I want to use mostly Horizontal Bar Graphs and Pie Graphs.

In the image bellow I want to keep only the left side graph that is filtered by region ans territory (in blue rectangle). It's the only dynamic graph (when I modify the filter)

The other graph (in red) is static so I just want just to indicate the national values: 7841, 683, 106 as as second label or something like that (as text near the others values not as distincts bars or separate graph).

Of course I can add 3 separate tiles near each regional values ( 379, 22 and 4) . The problem is that if I choose a region/territory when I have only 1 or 2 answers the 3 tiles remains in places. This case is simple but if I have a question with 10 possibles answers adding 10 tiles (so 10 sql request behind) it's not a valid solution.

In my case the quiz contains 35 questions so the ideea is that I don't want to duplicate each vizualiation. I want to keep only the dynamic graphs and find a way to indicate the national anwers as reference.

Thanks,

Daniel

Steve F-2

Thanks Daniel, note taken and your unique use-case has been presented to the appropriate PM.
Please also fee free to file an Ideas Lab request to formalized the use-case example.

I don't think a tooltip that is based based on your reference measure will work in this case. Only a static note