I have this table:
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.