6 Replies Latest reply on Jun 28, 2018 2:35 AM by sada.ambati

how to update current date as automatically in server

sada.ambati Jun 21, 2018 10:31 PM

Hi All,

Is any way to update the date as automatically,

like i am taking date filed in filters shelf and putting as range of dates like

Start date = 1-12017 to End date= 22-6-2018

now i published report in tableau server on 22-6-2018,after that i logged in server for checking the report it was good for me, and issue is

next day(23-6-2018) again i logged in server for checking report at this the range of date was showing as like this Start date = 1-12017 to End date= 22-6-2018 but i want like this Start date = 1-12017 to End date= 23-6-2018

means at any day in future i logged in server at the time the end date will be that system date

Please suggest for any solutions

Thanks

1. Re: how to update current date as automatically in server

Sankarmagesh Rajan Jun 21, 2018 11:07 PM (in response to sada.ambati)

Hi Sada,

Use the end date as relative date as today.

Thanks
sankar
Like Show 0 Likes(0)

Actions
2. Re: how to update current date as automatically in server

Mavis Liu Jun 22, 2018 1:26 AM (in response to sada.ambati)
Hi Sada,

Does your data have future dates in it? e.g. do you have any august 2018 data etc?

If it does, first create a calculation such that the max date will always be today:

Then bring this to filters and set it to true.

Next drag your date field into filters and set it a range of dates:

Then show the filter and set it to relevant values:

Finally reset your filter:

Now that your filter is reset, it will always go to the maximum date (today's date) whenever the workbook is opened.

Thanks and please see attached.

Mavis

Datesv10.2.twbx 7.4 MB
Like Show 0 Likes(0)

Actions
3. Re: how to update current date as automatically in server

sada.ambati Jun 24, 2018 10:32 PM (in response to Mavis Liu)

Hi Liu,

Thanks for response in your solution if we are reset the filter at that time the start dates goes to the original start date means i have date filed started from 1-1-2016 to current date
but i am giving the start date in filter is 1-1-2017 to current date.

i don't want to reset the filter with out resetting is any way to update the end date automatically.

Please suggest for that.

Thanks
Like Show 0 Likes(0)

Actions
4. Re: how to update current date as automatically in server

Mavis Liu Jun 25, 2018 1:14 AM (in response to sada.ambati)

Hi Sada,

You should add in a data source filter so that your date filter starts at 0101/2017 then still continue to use the reset filter option in your quick filter.

Thanks,

Mavis
Like Show 0 Likes(0)

Actions
5. Re: how to update current date as automatically in server

sada.ambati Jun 26, 2018 1:34 AM (in response to Mavis Liu)

no i want before 2017 data also but in dashboards i want show the ranges that it if user want to see the data of 2016 at that he will check using ranges of dates
is any another way to update the end as system date
Like Show 0 Likes(0)

Actions
6. Re: how to update current date as automatically in server

sada.ambati Jun 28, 2018 2:35 AM (in response to Mavis Liu)

No solution for that issue
Like Show 0 Likes(0)

Actions