Hi all,
I have a problem with a fractile expression used as color expression. I create a distribution Plot as follow
- 'cliente' as point
- 'rete' as y-axis
- 'SUM($(vMisuraAnalisi))/SUM({<RETE>} TOTAL<CLIENTECOMM> $(vMisuraAnalisi))' as measure
I would color each point based on the fractile and to do this I create the following color expression:
if(sum($(vMisuraAnalisi))/sum({<RETE>} Total <CLIENTECOMM> $(vMisuraAnalisi))
<= Fractile(total <[RETE]> Aggr(sum($(vMisuraAnalisi))/sum({<RETE>} Total <CLIENTECOMM> $(vMisuraAnalisi)), [RETE], [CLIENTECOMM] ) ,0.05 )
or
sum( $(vMisuraAnalisi))/sum({<RETE>} Total <CLIENTECOMM> $(vMisuraAnalisi))
>= Fractile(total <[RETE]> Aggr(sum($(vMisuraAnalisi))/sum({<RETE>} Total <CLIENTECOMM> $(vMisuraAnalisi)), [RETE], [CLIENTECOMM] ) ,0.95 )
,'#E41B17',
if((sum($(vMisuraAnalisi))/sum({<RETE>} Total <CLIENTECOMM> $(vMisuraAnalisi))
> Fractile(total <[RETE]> Aggr(sum($(vMisuraAnalisi))/sum({<RETE>} Total <CLIENTECOMM> $(vMisuraAnalisi)), [RETE], [CLIENTECOMM] ) ,0.05 )
and
sum($(vMisuraAnalisi))/sum({<RET,CLIENTECOMME>} Total <CLIENTECOMM> $(vMisuraAnalisi))
<= Fractile(total <[RETE]> Aggr(sum($(vMisuraAnalisi))/sum({<RETE>} Total <CLIENTECOMM> $(vMisuraAnalisi)), [RETE], [CLIENTECOMM] ),0.25 )
) or
(sum($(vMisuraAnalisi))/sum({<RETE>} Total <CLIENTECOMM> $(vMisuraAnalisi))
< Fractile(total <[RETE]> Aggr(sum($(vMisuraAnalisi))/sum({<RETE>} Total <CLIENTECOMM> $(vMisuraAnalisi)), [RETE], [CLIENTECOMM] ) ,0.95 )
and
sum($(vMisuraAnalisi))/sum({<RETE>} Total <CLIENTECOMM> $(vMisuraAnalisi))
>= Fractile(total <[RETE]> Aggr(sum($(vMisuraAnalisi))/sum({<RETE>} Total <CLIENTECOMM> $(vMisuraAnalisi)), [RETE], [CLIENTECOMM] ) ,0.75 )
),'#4477aa'
,'#94C7FA'
))
It works fine until I select a 'cliente'. I would like that 'cliente' selection doesn't effects on color. I tried different option but not the correct one.
Please give me a help please, I'm coming crazy with this!
Thanks
