Optimisation in Charts expressions : How to refer to the current Expression value for attributes ?
Hi,
As you know in a Charts, you can add some attribute on expressions (like in any chart). in order to change dynamically the Background Color, the Text color, Text Format etc...
Now suppose I've Line Chart with a complex expression : =Sum({$<FIELD1= ..... / Sum (...) * Count (Distinct... ).
I want the change the Line Style depending on the current expression value. Is there any whay to refer to the current expression value ? Actually, I'm forced to recalculate the expression :
if (Sum({$<FIELD1= ..... / Sum (...) * Count (Distinct... )>0, Then Style1 , if (Sum({$<FIELD1= ..... / Sum (...) * Count (Distinct...)<=-3,Style2,Style3)
It works, but It isn't really efficient on big tables.
