Pre-define selection in Tab but allow changes

[#1]

Hi,

I have a certain Tab that shows graphs regarding a certain ID (Max ID).

This condition is made in Set analysis.

Sum({$<RUN_ID={$(vMax_Run)}} OPCODE_COUNT*SUBSCRIBER_COUNT)

I want the user to be able to choose other Run ID to be reflected on the graphs, but by default to show the Max run ID.

How can I do it?

Thanks,

Boris

[lironbaram]

hi you can use a button that selects the max id , but the the user can change the id

oryou could define a trigger for the tab that selects the maxid  every time the user activate s the tab

[#3]

How is it done exactly?

I defined a trigger on activateSheet -> Select in field action -> Field RUN_ID and variable vMAX_Run:

its still doesnt work, because I removed the condition from the set analysis and the numbers jumped.

I also try to go between Tabs to trigger it but it still didnt work.

did I do something wrong with the syntax?

[lironbaram · Accepted solution]

you in the field box write RUN_ID

in the search string box write =vMax_Run