Solved
Month to date comparison of 2 months
I want to have a report that calculates metrics month to yesterday and compares to the previous month (same days). I can't quite figure out how to do the comparison dates. Is this possible?
I want to have a report that calculates metrics month to yesterday and compares to the previous month (same days). I can't quite figure out how to do the comparison dates. Is this possible?
Hi Ellen,
Thank you for contacting us. You can set the comparison on the query settings as shown below:
Best regards,
Nebiat Ibssa
supermetrics.com
Twitter: @Supermetrics
Support forum: support.supermetrics.com
Nebiat, the feature you highlighed would compare 11/1 - 11/4 to 10/28 to 10/31.
I want to compare
11/1 - 11/4 MTD to yesterday for example to
10/1 - 10/4 MTD Last month to match the same day.
Trying to do this with out too many formulas.
Andre'
Hi Supermetrics, I am having the same issue as Andre is this possible to do?
Hello,
I am also trying to do this.
@Supermetrics support, any help on this one?
Thanks
Hi all,
The 'Date' fields accept any value allowed by PHP's strtotime function, so for this case, you can set the query as:
Best regards,
Nebiat Ibssa
supermetrics.com