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!
