Month to date this year vs. MTD LY

Answered

2 Comments

  • Jon Daniels
    Comment actions Permalink

    Hi James!

    Your question was answered in a ticket, but I'm sharing that answer in a comment here for any future visitors:

     

    In order to achieve what you'd like, you'll need to create different Date Range Calculated Metric for each part:

    • From this Year to date: (based on Ticket Solved date in my example):

     

    • From Last Year to same date last Year:


    ​​


    And then another Standard Calculated Metric for: % Difference This Year vs Last Year:


    ​​
    Make sure to change the display format to percentage for this metric.

    Then you'll be able to create the same for your Quarter and Month to date metric creating 3 metrics for each as well.

    For more information on this, you can consult these help articles:

    0
  • James Molina
    Comment actions Permalink

    Jon Daniels- Thank you... I neglected to thank you originally but I just referenced this again and wanted to be sure I did this time.

    2

Please sign in to leave a comment.

Powered by Zendesk