-
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
-
2. Re: how to update current date as automatically in server
Mavis LiuJun 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
-
-
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
-
4. Re: how to update current date as automatically in server
Mavis LiuJun 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
-
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
-
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