Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all,
for button use i created the variable vDate which is just my [date] field.
I passed it to the KPI i want to use with these buttons.
I created one for today like : date(floor(max([date])), 'DD/MM/YYYY')
and for yesterday like: date(floor(max([date]-1)), 'DD/MM/YYYY')
BUT i'm having trouble with last week and last year.
For last week i though >=(date(floor(max([date])), 'DD/MM/YYYY')-7)<=date(floor(max([date])), 'DD/MM/YYYY')
but doesn't work ... Help me please!
Hi, I am not sure what you mean by the date field in your variable - a field contains multiple values and a variable only contains a single value. Do you want the date range to be selected when a user clicks the button? If so, then add an action that selects a range of values in a field, select your date field and write an expression like ='>$(=date(today()-7))<=$(=date(today()))'
The default date format must be the same as in the Date field for it to work.
Morgan Kejerhag
Senior Business Intelligence Consultant
Drake Analytics
http://www.drakeanalytics.se