Lock KPI chart that displays a formula

[JohnSamuel123]

hi,

i can see a number of posts showing how to lock a visulsaition using {1} .

however im having trouble getting this to work on my formula:

='$(vMaxID) / $(vTotal)'

is it possible to lock the above formula so selections dont impact my vMaxID value?

thanks 

[Lakshminarayanan_J]

@JohnSamuel123 

Can you post the variable expression ?

[JohnSamuel123]

hi @Lakshminarayanan_J  vMaxID =max(ID)

vTotal is just a static number

[Lakshminarayanan_J]

@JohnSamuel123 .

Try using Alternate State for that KPI,

Go to Master Item -> Click on Alternatestate 

and create new alternate state like "test " .

Drag it to KPI which you need to Lock and click on Apply State

Once it applied , check on Alternate State ribbon on the KPI whether it is applied 

after that if any selection done it wont applied to that KPI

[JohnSamuel123]

hi @Lakshminarayanan_J  i tried the above but the KPI is still changing when i do a selection:

my KPI:

my assigned state master item:

notice KPI change  once selection is made:

[Lakshminarayanan_J]

@JohnSamuel123 

Kindly upload  sample app with limited data  in private  message .will work on it and share it back 

[JohnSamuel123]

here is attached file with 2 lines of sample data

[JohnSamuel123]

hi @Lakshminarayanan_J . did you have any luck with this? thanks

[Lakshminarayanan_J · Accepted solution]

@JohnSamuel123 ,

Apologies for delay response , I missed you ping.

Please find the upload app with the expected result , for total you have used static value , let me know how it is getting calculated so that i will check and update on it as well

Thank You 

Lakshminarayanan J

[JohnSamuel123]

thats perfect thanks a million Lakshminarayanan working great. the static value is currently updated manually monthly so i will just monitor that myself.

thanks for your help appreciate it