Oracle Analytics and AI

Kyle N

I want to apply conditional formatting for one value against another calculated value. We can use turnover as my example. Let's say the YTD annualized turnover value for the company is 15%. I've created a visualization that applies all the applicable filters and produces a value of 15% for the entire company. I want my users to be able to load the dashboard and, in a second visualization, apply a dashboard filter to a particular organization - let's say IT. I have disabled "listening" to the dashboard filters on the company visualization so it remains at 15%, and so when my user logs in and sets the organization filter to IT, I want the second visualization showing the IT rate is at 13%. How do I have the second visualization (13%) apply conditional formatting against the result of the first visualization (15%)?

I do not want to create a static value in the conditional formatting as the turnover rate will change throughout the year.

Any help is much appreciated.

JohnW-Oracle

Hello @Kyle N

You can’t directly have one visualization read the rendered value from another visualization under the circumstances you described. In OAC, conditional formatting is evaluated against the data/expression available to the target visualization or workbook rule, not against another tile’s displayed result. For what you can do with conditional formatting, please see the documentation here: https://docs.oracle.com/en/cloud/paas/analytics-cloud/acubi/what-can-i-do-conditional-formatting.html

Instead, you may want to create a Company YTD Annualized Turnover % as a reusable benchmark measure in your semantic model. Then compare the IT measure to that benchmark in the second visualization’s conditional formatting rule.

Regards,

John