Recent searches


No recent searches

Month to date this year vs. MTD LY

Answered


Posted May 21, 2019

In Explore can you create a Month To Date This Year (MTDTY) and Month To Date Last Year (MTDLY) time based metrics?  Trying to build a query with these two vales for solved tickets with a % difference.

Thanks in advance for the help!

James


0

2

2 comments

image avatar

Jon Daniels

Zendesk Customer Care

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


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

0


Post is closed for comments.

Didn't find what you're looking for?

New post