Start a new topic
Solved

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


image



Best regards,

Heidi Virta

supermetrics.com


Twitter: @Supermetrics 

Support forum: support.supermetrics.com

Login or Signup to post a comment