Fractile in distribution plot color expression

graziellas82 — Sat, 16 Nov 2024 05:29:26 GMT

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

topic Fractile in distribution plot color expression in App Development

Fractile in distribution plot color expression