Hi Paul -
Create a "Range of Dates" filter on your field. It will show up as a "slider" with two "handles" that your user can move around to act as start/end date.
i tried what you said but it doesnt seem to be working very well.
i am having trouble getting the data range to work dynamically.
i want the date range that appears on the screen to only include the date range from the results [as this is coming from a view thats updated each night so the date range is changing every night. im actually getting all results for the past three years (sysdate - 1080)]. a date range that was anything other than the dates from the results would be misleading.
this is what ive done so far:
- ive change my date field to a date
- moved the date to my filters
- selected 'range of dates'
- clicked 'load domain'
- clicked 'allvalues in database' or 'only relevant values' (neither seem to work)
- press ok
- male my new filter 'global'
- go to my dashboard
- right clcik, quick filters and add the date filter
- refresh the data
no sliders appear. just like when you dont set a date. the only way to get the sliders to appear i have found is to pput dates in. but as i have explained i wouldnt want to hard code my dates as this would lead to a misleading report that wasnt dynamic.
Are you able to post a screen shot or twbx file of what you are seeing?
I am seeing this same issue, is there a solution for this yet? Basically, the date filters would not change itself dynamically according to the relevant values.