0 Replies Latest reply: Apr 10, 2016 11:16 AM by Isaac Paz RSS

    Delimit a timeline between two dates.

    Isaac Paz

      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