Announcing a new experience for the Oracle Analytics community coming April 4th!
This category will be read-only as we migrate this space from 3/30-4/4, after which you’ll be able to post as usual. See you there!
Support for Treemap charts in OAC with being able to configure colors with custom calculations
SummarySupport for Treemap charts in OAC with being able to configure colors
I have a requirement to use Treemap charts to show categorial data. I show in Y-axis "Record Count" and in X-axis a category called "Month". Also, I have "Record Count" added to "Color". This shows me the chart as in the screenshot.
In the screenshot, I have chosen, Green to Red diverging colors between months. When "Record Count" is added to "Color", OAC calculates Record Count for each month and shows the percentage difference as Green to Red diverging colors. Here, the colobr calculation is done by OAC. It takes Record Count for Nov moth as 2288249 (94.3%) and Record Count for Oct month as 138197 (5.7%) and shows the divergence in color.