Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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
ashraf817
ashraf817 Rank 3 - Community Apprentice
in Oracle Analytics Cloud and Server

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

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