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?

  • Hi Ellen,

    Thank you for contacting us. You can set the comparison on the query settings as shown below:


    If there's anything else we can help you with, please let us know.

    Best regards,

    Nebiat Ibssa

    Twitter: @Supermetrics 

    Support forum:

  • 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.


  • 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?


  • 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

Login to post a comment