Forum Discussion

ToddMate's avatar
ToddMate
Helper II
3 years ago
Solved

Calculate Time Difference.

Hi, I need assistance determining the time difference in the example below. Using the same tx_number, and then sorting by tx_date, i am trying to determine the response time from "Customer Emai...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi ToddMate ,

     

    It's eaiser to achieve by creating a calculated column.

     

    time =
VAR _MAX =
    MAXX (
        FILTER ( 'tx_dates', [tx_number] = EARLIER ( tx_dates[tx_number] ) ),
        [tx_date]
    )
VAR _SECOND =
    DATEDIFF ( [tx_date], _MAX, SECOND )
RETURN
    IF (
        [action] = "Customer Email",
        FORMAT ( ROUNDDOWN ( DIVIDE ( _SECOND, 3600 ), 0 ), "00" ) & ":"
            & FORMAT ( ROUNDDOWN ( DIVIDE ( MOD ( _SECOND, 3600 ), 60 ), 0 ), "00" ) & ":"
            & FORMAT ( MOD ( _SECOND, 60 ), "00" )
    )

     

     

     

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

ToddMate's avatar
ToddMate
Helper II
3 years ago

Greg_Deckler ,

I'm not sure if i have missed something in this exercise, but as i only have one date per row and i am looking up date values below if x criteria is met, the article you provided doesn't appear to provide a solution.

Can you please review and see if i have missed something.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
3 years ago

ToddMate It seemed like you were trying to take a date/time from the current and subtract it from the date/time that appears in a previous row. Is that correct?