Start a new topic
Solved

Select dates "This year to yesterday

Hi, 

is it possible to Select dates "This year to yesterday"? 


I need to make dashboard

  • for the whole year, segmented by months
  • data until yesterday (in current month)
  • only one query

image


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?

Thank you!



1 Comment

Hi,


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.



Best regards,

-Supermetrics Team


1 person likes this
Login or Signup to post a comment