Start a new topic

Monthly Reporting - Excluding Current Month

Hi I'd like to be able to pull a report for "this year, so far, not including this current month".

I am constantly having to adjust the query to stop at the last month, rather than just being able to schedule automatic refreshes. 

Any solution?

1 Comment

Hi Thomas,

Thanks for reaching out.

You can achieve this with relative date formats in the start and end date fields.

For example, 

set start date: first day of January this year

and end date: last day of last month


Best regards,

Heidi Virta

Twitter: @Supermetrics 

Support forum:

Login or Signup to post a comment