I have a requirement that when the user logs in, the dashboards display results for the current month. I have a calendar field 'Month' and I have a variable 'vCurrentMonth'.
My thought is to create a default bookmark for current month, however if I try and make a selection within a calendar, it returns the actual dates for that month.
I also thought of using the Action on the sheet (although it is not ideal as this would only be applicable to one sheet), but am unsure of how to go about that.
I would appreciate any assistance that you can provide. Have a lovely weekend.
you can try the following. Create a variable vCurrentMonth and type DateField=Month(Today())
Go to your Filterpane and type =$(vCurrentMonth)
Save the selection as a Bookmark - CurrentMonth and set to Standard.
This should always select the current month when you open the app.