Compare to multiple date ranges: MOM and YOY


Ideally I'd like to pull data for both Last Month vs the the previous year and Last Month vs the Month prior.  For example, January 2020 vs January 2019 (YOY) and January 2020 vs December 2019 (MOM).   Is there a way to do this without archiving the monthly data and referencing that way? 


  • In order to pull last month and comparison for the same month a year ago, you'd need to do this kind of setup:

    For Last month with comparison to prior month, setup would look like this:

    Unfortunately it's not possible to be 100% sure if the comparison months are full for example in case of shorter months.

    Best regards,

    -Supermetrics Team

Login to post a comment