Ricerche recenti

Nessuna ricerca recente

Month-over-month

image avatar

Betina Juliano

Data ultimo post: 26 nov 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 commento

Data
    image avatar

    Amie Brennan

    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

    Accedi per aggiungere un commento.

    Non hai trovato quello che cerchi?

    Nuovo post