Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

How to conditional format with an attribute as a target?

Accepted answer
31
Views
1
Comments

Hello,

I have a columns called "target" with fixed data that i don't want to aggregate, i want to use it in conditional formatting to highlight if the total have reached the needed target but i can't use attribute there.
how can i do it?

i did a manual conditional formatting and it worked great but the targets are changing per month and it's not efficient to change the conditional formatting every month.

i use Oracle Analytics Desktop.

appreciate your insights.

Screenshot 2024-08-22 123154.png




Screenshot 2024-08-22 123506.png

Best Answer

  • Hi @ashraf817

    Currently, we do not support Conditional formatting on attribute; however, this is an enhancement on the roadmap.

    There is a workaround trick to make the attribute appear as a measure, you may need a new calculation

     SUM(0) + MONTHLY_INCOME

    That probably should be converted to measure anyway in your data import phase

    I hope that helps, other comments welcomed.