Independent Charts

[brunolelli87]

Hello!

This is Bruno again with a new doubt.

I have created the following charts and they were supposed to be independent. I mean, it doesn't matter if the user selects or not something, the chart is supposed to say there, with absolutely no changes.

The Dimension is: =Date(DACG, 'DD/MM/YY')
The Expression is: =avg({1 <STCK={'GOLL4'}, DACG={">$(=Date(Addmonths(Today(), -3)))"}>} VDAF)

And I have a color-changing expression, that is: =If(firstsortedvalue(TOTAL {<STCK={'CCRO3'}>} VDAF, -DVPG, 1) > firstsortedvalue(TOTAL{<STCK={'CCRO3'}>} VDAF, -DVPG, 2), color(3), color(2))

So, basically, if the user selects something on a Lisbox using the STCK Field, nothing happens, and it's good!

But, if the user selects something from any other field, like SUBS (Subsector) for example, than the whole charts changes.

What should I do to let it static?
With no changes at all?

Thanks
Bruno Lelli

[Lisa_P · Accepted solution]

Just insert the 1 inside the {} like your expression.

If(firstsortedvalue(TOTAL {1<STCK={'CCRO3'}>} VDAF, -DVPG, 1) > firstsortedvalue(TOTAL{1<STCK={'CCRO3'}>} VDAF, -DVPG, 2), color(3), color(2))

[brunolelli87]

Ohhh, thanks!

I really forgot about that!!!

Thank you so much!