3 Replies Latest reply on Dec 6, 2012 12:51 PM by Andy Piper

Start Date and End Date Date Filter on Refresh

dora dora Dec 4, 2012 10:24 AM

I want the Start Date to default to Current date -30 and End Date to current date -1 always when the user first views the dashboard.

also the User can change the Start Date and End Date to whatever he wants (any old dates).

Right now, the problem is both the Start Date and End Date are defaulted to the dates with which I publish to the Server.

But I want the Date Filters to Default to the above requirement each time when the user first loads the page.

1. Re: Start Date and End Date Date Filter on Refresh

Andy Piper Dec 4, 2012 11:44 AM (in response to dora dora)

Have you looked at using a relative date filter option? You could specify the last 30 or 31 days on your Start Date. You could create a second filter for your End Date that looks at yesterday.
Like Show 0 Likes(0)

Actions
2. Re: Start Date and End Date Date Filter on Refresh

dora dora Dec 4, 2012 3:32 PM (in response to Andy Piper)

Other than Relative Date Filter, is there any other Options right now.
Like Show 0 Likes(0)

Actions
3. Re: Start Date and End Date Date Filter on Refresh

Andy Piper Dec 6, 2012 12:51 PM (in response to dora dora)

I suppose you could use one or two parameters (either start and end values within same parameter or in separate ones) that have values that you define. The calculated fields (you will need at least two -- one to control the start date and one the end date) would need to be configured and added to the filters shelf.

To compare to today's date (whatever today's date is), your calculated fields would need to use the TODAY() function.
1 of 1 people found this helpful
Like Show 0 Likes(0)

Actions

Tableau Community Forums