Forum Discussion

admi's avatar
admi
Frequent Visitor
6 years ago

Time between date

Hi,   I need to get the time in minutes between two dates like this : 13/02/2020 17:04.00. The first and the last of my table. I also need to calculate the time when a parameters is null. I have a...
admi's avatar
admi
Frequent Visitor
6 years ago
Document.Date Speed
17/02/2020 10:24 127
17/02/2020 10:24 130
17/02/2020 10:24 130
17/02/2020 10:24 130
17/02/2020 10:24 130
17/02/2020 10:24 130
17/02/2020 10:24 130
17/02/2020 10:24 90
17/02/2020 10:24 40
17/02/2020 10:24 0
17/02/2020 10:24 0
17/02/2020 10:25 0
17/02/2020 10:26 0
17/02/2020 10:27 0
17/02/2020 10:28 0
17/02/2020 10:29 0
17/02/2020 10:31 0
17/02/2020 10:32 20
17/02/2020 10:33 50
17/02/2020 10:34 100
17/02/2020 10:35 130
17/02/2020 10:36 0
17/02/2020 10:37 0
17/02/2020 10:38 0
17/02/2020 10:39 0
17/02/2020 10:40 0
17/02/2020 10:41 22
17/02/2020 10:42 45

 Sorry, I'm in internship, so i was in school. My problem is not completely resolved. I need to calculate the time when my speed is 0. So here in this case, I need the time from 10:24 to 10:31= 7 min plus the time from 10:36 to 10:40 = 4 min. So a result of 11 min.

 

Thanks for helping me.

 

AlexAlberga727's avatar
AlexAlberga727
Resolver II
6 years ago

I'm thinking of a simple way of handling this... so you're able to also filter by date. I think utilizing a calculated column to ask IF 0 then 1. Then you can create a measure to sum all of this column.

 

So try this - 

 

Create a calculated column within your data table :

Time is Zero = If ( [Speed] = 0, 1 , 0 )

 

Then create a Measure : 
Total time Zero = SUM ( Time is Zero )

 

This should create a counter for every instance time = 0. Then you're totaling the counts of 0.

 

Looks like you have a time stamp for every minute so that should work.