Recent searches


No recent searches

Month-over-month



Posted Nov 26, 2024

Hello! I have a table with two columns: tickets created this month and tickets created last month. I want to calculate the percentual  Month over month difference. I did this using a result metric calculation and it worked! But when I added it to my dashboard - that has a time filter - the report crashed. My understanding is that the time filter on the dashboard does not affect the metrics on the result metric calculation and that's why it happens. Do you have any idea on how to fix the issue or another path I could take to calculate MoM?


0

1

1 comment

Heya,

 

Here's how I would create this report referencing my screenshots. 

  1. Duplicate the Tickets metric & add to the report like you can see so there's 2 under metrics.
  2. Add the attributes
    1. Created Year - Add a filter to this for “1 years in the past to Today”
    2. Created - Month 
  3. Go to Result Manipulation > Add a result path calculation & apply to report - see second screenshot 
  4. Hide the first tickets copy column - so only the second is visible with the % difference
  5. Allow an arrow to appear on the last column (in column settings)
  6. See end result in final screenshot

NOTE: This data is from my test account, but this report is reporting correctly. 

 

 

 

Final result

 

Hope this helps. :)

 

Best,

 

Amie

0


Please sign in to leave a comment.

Didn't find what you're looking for?

New post