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
Jon Daniels
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:
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
@...- Thank you... I neglected to thank you originally but I just referenced this again and wanted to be sure I did this time.
0