Monthly Reporting - Excluding Current Month

Nowspeed

started a topic about 3 years ago

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?

Heidi Virta
said about 3 years ago

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

supermetrics.com

Twitter: @Supermetrics

Support forum: support.supermetrics.com