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
32
Views
1
Comments
ashraf817
ashraf817 Rank 3 - Community Apprentice

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.




Best Answer

  • SteveF-Oracle
    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.