Hi team,
I was wondering if there was a way to modify the query dates to compare the same dates a month ago. There is only an option for same dates a year ago. ie Compare 1-14th Aug 2024 to 1-14 Jul 2024.
Thank you!
Solved
Query to pull month to date compared to same dates a month ago
Best answer by Kathy
Hi,
Great question. You need to use advanced date selection in order to achieve this. Right where you are under “compared to”, select custom date range and type the following:
Start date:
last day of -2 monthsEnd date:
yesterday last month
Advanced date selection can be done by typing anything accepted by PHP's strtotime, which is what we are using in the example above.
Have a great day!
+2Hi,
Great question. You need to use advanced date selection in order to achieve this. Right where you are under “compared to”, select custom date range and type the following:
Start date:
last day of -2 monthsEnd date:
yesterday last month
Advanced date selection can be done by typing anything accepted by PHP's strtotime, which is what we are using in the example above.
Have a great day!
Awesome thanks so much Kathy. Much appreciated.
Sign up
Already have an account? Login
Ask questions from other Community members, comment on other people's posts and get access to exclusive Community content by logging in.
Log in with Facebook Login with LinkedInor
Login to
Supermetrics Community
Don't have an account? Sign Up
Ask questions from other Community members, comment on other people's posts and get access to exclusive Community content by logging in.
Log in with Facebook Login with LinkedInor
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.