is it possible to Select dates "This year to yesterday"?
I need to make dashboard
I can schedule the refreshing just after the midnight, but because of the delay in ad systems could be the data from previous day incomplete.
Any other idea?
you can make such a date range by selecting 1.1.2018 as your start date, and then by writing "yesterday" in to the end date field. This way it will update automatically.
If you refresh just after midnight, in most cases the data sources haven't updated yesterdays figures completely so I suggest using for example 3-6 hours after midnight as your refresh time.