I have a database like this: Machine / BeginDate / EndDate, Where ( EndDate - BeginDate ) is the activity time of a machine in a order
What I want is to show in a timeline the total activity between two dates.
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.