1 Reply Latest reply: May 7, 2013 4:41 AM by Johannes Sunden RSS

    Time chart with Sum

      Hello,

       

      I have this table:

       

      SOURCETABLE:

      LOAD * INLINE [

              ItemName, MinutePrice, StartDateTime, StopDateTime

              'Item1', 5, '10/18/2013 12:00', '10/18/2013 18:00'

              'Item2', 2, '10/18/2013 05:25', '10/18/2013 14:30',

              'Item3', 13, '10/18/2013 17:15', '10/18/2013 22:00',

              'Item4', 1, '10/17/2013 12:00', '10/19/2013 12:00',

              'Item5', 22, '10/18/2013 10:00', '10/18/2013 16:45',

          ];

       

      And I would like to create a graph which will have Time on X axis and Price on Y axis. The Time period on X should be selectable. It should show the summarize of the prices of all items which are done on each minute.

       

      Lets take time 10/18/2013 17:00. We can see that in this minute there are Item1, Item3 and Item4. So the graph should show numer 19.

       

      Can anybody help me create the logic for such a graph? Is it even posible? I was thinking about some VB script or something like this but can't figure it out right now.

       

       

      Thanks,

      Jindra