Forum Discussion

rsimpson318's avatar
rsimpson318
Frequent Visitor
4 years ago

Calculate Duration Across Multiple Dates and Items

Hello -    Sorry if this has been asked before: I have a table that includes the date, vehicle, and time that it received a response. I've created a table that displays the vehicle, date, and start...
Need Help
rsimpson318's avatar
rsimpson318
Frequent Visitor
4 years ago

When I try to add the measure, I get the message that the column 'DURATION' cannot be found or may not be used in this expression.

 

It may be helpful to note that 'DURATION' is a measure of 'START_DATE_TIME' - 'END_DATE_TIME' and 'START_DATE_TIME' is a measure of MIN('DATE_TIME') while 'END_DATE_TIME' is a measure of MAX('DATE_TIME').

davehus's avatar
davehus
Icon for Memorable Member rankMemorable Member
4 years ago

Hi rsimpson318, replace the Sum(duration) with your Duration measure.

 

Did I help you today? Please accept my solution and hit the Kudos button.

  • rsimpson318's avatar
    rsimpson318
    Frequent Visitor
    4 years ago

    davehus 

     

    It didn't give an error this time, but it still calculated the duration as the first date for the vehicle and the last day instead of the sum for the difference of each day. So in the table above, it's calculating the duration for vehicle 11603 as the difference between 08/01/22 06:16:56 AM and 8/26/22 08:07:46 AM instead of adding up all the values.