How to create Overlay chart with using Aggregation By which is missing in Overlay chart.

Rajakumar Burra

I have two different charts. Two charts are created using Aggregation By in Values properties.

I want to merge it and create Overlay chart. Unfortunately, option Aggregation By in Values properties is not available. Is there any way to create overlay chart to get same result.

I have tried using option AGGREATIATE by in Calculation. But it doesn't work.

Any help appreciated.

Below are the two charts images.

Federico Venturin

Hi @Rajakumar Burra ,

As a workaround, you could set the canvas layout to Freeform, and manually overlap the Line Chart to the Stacked Bar Chart. You also need to format the vertical axis to have exactly the same Start and End value for both visualizations, and eventually hide titles/labels as required.

A proper solution requires the By property to be included in the Overlay visualization as well. Did you already create an Idea about it?

Rajakumar Burra

Thanks @Federico Venturin . Exact meaning of Overlay. 😀

For now, live with two separate charts. Waiting for Oracle to identify the value and implement it.

Created an Idea, You can vote for it.

https://community.oracle.com/products/oracleanalytics/discussion/21372/overlay-and-combo-charts-should-have-aggregation-method-and-aggregation-by-option-in-values