above function if condition in expresion should not change with date

[aj0031724]

Team,

I am using the below expression as "Classification"" .However I don't want the expression to be changed with dimension ""DATE""

Can I use below expression with set analysis to avoid getting affected by DATE.

=if(Above($(vkpivalue))>4 and Above($(vkpivalue),0)>4,'Alarmed',
if(-rangesum(($(vkpivalue)>4),(Above($(vkpivalue),1)>4),(Above($(vkpivalue),2)>4),(Above($(vkpivalue),3)>4),(Above($(vkpivalue),4)>4),(Above($(vkpivalue),5)>4),(Above($(vkpivalue),6)>4))>=4,'Highly utilized',
if(-rangesum(($(vkpivalue)<3),(Above($(vkpivalue),1)<3),(Above($(vkpivalue),2)<3),(Above($(vkpivalue),3)<3),(Above($(vkpivalue),4)<3),(Above($(vkpivalue),5)<3),(Above($(vkpivalue),6)<3))>=6,'Low utilized',
'Standard')))

[aj0031724]

Team,

Can you please help me with this as I am struggling to get the classification retain.

Any other expression which can compare the last 7 dates KPI values and arrive at below logic.

=if(Above($(vkpivalue))>4 and Above($(vkpivalue),0)>4,'Alarmed',
if(-rangesum(($(vkpivalue)>4),(Above($(vkpivalue),1)>4),(Above($(vkpivalue),2)>4),(Above($(vkpivalue),3)>4),(Above($(vkpivalue),4)>4),(Above($(vkpivalue),5)>4),(Above($(vkpivalue),6)>4))>=4,'Highly utilized',
if(-rangesum(($(vkpivalue)<3),(Above($(vkpivalue),1)<3),(Above($(vkpivalue),2)<3),(Above($(vkpivalue),3)<3),(Above($(vkpivalue),4)<3),(Above($(vkpivalue),5)<3),(Above($(vkpivalue),6)<3))>=6,'Low utilized',
'Standard')))