Select dates "This year to yesterday


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


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!

  • 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

    2 people like this
Login to post a comment