Recherches récentes

Pas de recherche récente

Unable to perform standard calculated metric between two dates

image avatar

Ryan Knight

Publication le 15 oct. 2024

Hi Team, I have two custom date fields on my ticket forms used for Urgent priority tickets, the fields are called:

Production Down Start Date 

Production Restored Date

 

I am trying to calculate the “Downtime Duration” in days by subtracting one from the other using this formula: DATE_DIFF([Production Restored Date - Timestamp], [Production Down Start Date - Timestamp], "days")

 

I get the following error:

I've tried a number of calculations (SUM, MED, AVG, COUNT) and different date formats (Timestamp, Date, Hour, Day of Week, etc) and no luck on any of them.

 

Any tips or suggestions on how to calculate this? I need to then also calculate the median per ticket as a seperate calculation.
 

1

2

2 commentaire

Date
    image avatar

    James Peterson - Eastern Logic

    Ryan Knight - I found this Reddit post that might help.

    1

    image avatar

    Ryan Knight

    Thank you, that was helpful. For some unknown reason the issue resolved itself and 2 days later the data is appearing using the same formula with “-Date” as I tried before.

     


     

    0

    Vous devez vous connecter pour laisser un commentaire.

    Vous ne trouvez pas ce que vous cherchez ?

    Nouvelle publication