Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Delimit a timeline between two dates.

Hello,

I have a database like this: Machine / BeginDate / EndDate, Where  ( EndDate - BeginDate ) is the activity time of a machine in a order

production.

What I want is to show in a timeline the total activity between two dates.

For example:

machine1 | 10/10/2015 23:00:00 | 14/10/2015 21:00:00

machine2 | 13/10/2015 9:00:00 | 18/10/2015 17:30:00

I want to see the occupation between day " 13/10/2015 12:00:00 " and " 16/10/2015 23:00:00 "

In the timeline should be the time of occupation of the two machines in that time zone , and this would be:

Machine1 : 13/10/2015 12:00:00 to 14/10/2015 21:00:00

Machine2 : 13/10/2015 12:00:00 to 16/10/2015 23:00:00

To do this I 'm using google timeline as shown in the image, but this only allows me to filter by dimension .

How can i fix the problem ?

There is some extension for that purpose ?

Greetings and thank you.

TimeLine.JPG

0 Replies