Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have created a calender in the dashboard for a date dimension which works fine, however it would be useful if I had a next day & Previous day action button so users can click forward or back based on the date shown in the calender.
Any thoughts?
Phil
Hi
PFA
write like this
take a variable and when click assign a value like 1
=if(variable='1',Date-1,Date)
Just to be a bit clear, I am wanting to change the selection based on the next / previous day button.
Thanks
Phil
Hi
PFA
Find attachment hope this will help you.
in action there is always by default having action forward or previous
you just call it to make a button add action
selection-->forward
and other for back
I also use fast selection button for previous month or week. What I would do for previous day > button > action > select in field > field: date field > value: =Today()-1 (of course, if this doesn't work, check the date format and adjust the function accordingly)
In the caption tab I would put some help text, like "previous day". In the button I would only put "<" (or ">" for next day).
Hi
It took a little bit of fidling with in my own dashboard but I got it working eventually. The issue I found was that my date field had date & time, so it didn't like the format, but since I created a Date(Date) expression in the script it works great.
Thankyou for your help it was extremely useful
Phil