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?

  • Hi Ellen,

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


    image


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


    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

Login or Signup to post a comment