Supermetrics Support Forum

Back to website Post to forum Submit a ticket Feature requests My Tickets
Welcome
Login
  1. Discussions
  2. Supermetrics for Google Sheets
  3. Problems & Solutions
Solved

Month to date comparison of 2 months

E
Ellen Caywood
started a topic over 2 years ago

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?

  • N
    Nebiat Ibssa
    said over 2 years ago

    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

  • A
    Andre Leach
    said 9 months ago

    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'

  • A
    Abdullah Fakier
    said 8 months ago

    Hi Supermetrics, I am having the same issue as Andre is this possible to do?

  • S
    Spica Reports
    said 6 months ago

    Hello, 


    I am also trying to do this.


    @Supermetrics support, any help on this one?


    Thanks

  • N
    Nebiat Ibssa
    said 6 months ago

    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 to post a comment
Topics in this forum
View all (1271)

Didn't find what you were looking for?

Start a new topic