How to set current year in drop down list when the report is opened

[Areerat Mukdakan]

Hi, I created a dropdown list in the text area with a columnfor filtering year (2015-2021) and I would like to set it for 2021 when the report is opened. how can I do it

I used Data Function for writing script:output

[Raghav Rajaram]

Hi Chloe,

 

You don't need to use CurrentDateTimeProperty. I was able to acheive it with a different script (script uses lubridate package)

script:

output = as.integer(year(now()))

----------------------------------------------

I set the output parameter to theproperty (integer type) used in the dropdown. The dropdown containsunique values in Year column (has to be an integer column for this example but you can make it work with other types as well). Attaching the dxp in this reply for your reference. Hope this helps.

 

Best,

Raghav

[Areerat Mukdakan]

Hi, Raghav

 

Thank you for your kindness, but I got an error because I don't have lubridate package (Spotfire desktop) where can I install it 

 

Best,

 

Chloe

[Gaia Paolini]

In Spotfire, go to Tools > TERR Tools > Package Management.

 

Load CRAN package repository and put lubridate in Available Packages input field.

 

Then once selected click install.