Variable Input - Default Value?

[SparkyMarky]

Hi,

A request came from a client who wants to know if I can set default values for two Dashboard Bundle Variable Input objects. The dynamic values displayed are a range of months. For one variable input, I want to default it to the prior month, and for the other variable input, I want to default it to the current month. 

Thank you

[Lisa_P]

This should be possible by defining your Variable from the window in the Asset panel using an expression beginning with = to ensure that this is defined to store this result.

[balabhaskarqlik]

In the variables, try like this:

For current month : Max(Month) or Maxstring(Month).

Previous month: Addmonths(Max(Month),-1) or Max(Month,2).

[SparkyMarky · Accepted solution]

Hi again,

Thank you for your quick responses. I just got back to this project so sorry for a delayed response.

I ended up setting the variables in the load script. I found the max and 2nd max dates in the data and then did a LET = peek() of each and assigned these to the variables.

After the load, the variable objects were set correctly.

Regards,

Mark