persistent color pie chart

[adiarnon]

hi,

i have a pie chart with

expression:

count({<Rate_MonthYear={"$(v_early)"}>}DISTINCT Central_BP)

dimention:

=if(aggr((sum({<Rate_MonthYear={"$(v_early)"}>}MONTHLY_ON_TIME_UNITS_QTY)/sum({<Rate_MonthYear={"$(v_early)"}>}MONTHLY_RCVD_UNITS_QTY)),Central_BP)>=0.95,'Preferred',
if(aggr((sum({<Rate_MonthYear={"$(v_early)"}>}MONTHLY_ON_TIME_UNITS_QTY)/sum({<Rate_MonthYear={"$(v_early)"}>}MONTHLY_RCVD_UNITS_QTY)),Central_BP)>=0.85,'Satisfactory','Unsatisfactory'))

i checked th "persistent color"

i have 3 colors and if when im chossing 2 of them its behaiving good (keep the color)

but the third color if im chossing it it changing!

what am i doing wrong?

adi

[lironbaram]

does v_early variable is changed according to selections ?

i tried a similar approach in a simple model and it works well

i used this formula in the dimension

=aggr(if(sum(Sales)<40000,'Low',if(sum(Sales)>70000,'High','Medium')),ID),

this expression

count(ID)

and this in the background of the expression

=aggr(if(sum(Sales)<40000,Green(),if(sum(Sales)>70000,Red(),Yellow())),ID)

so it's either something change the dimension values or the coloring values