How to conditional format with an attribute as a target?

Question

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.

Steve F-2 · Accepted 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.