How to creat a chart with events/hour from time hh:mm:ss

[Anonymous]

Hi

I have the following info

I would like to create a chart (easy part) ´where i can show the event/hour and then the sum of the duration for each event/hour.

Any suggestions on how to do this ?

Thanks

Des

[MK_QSL · Accepted solution]

Create a Chart

Dimension

Calculated Dimension

=Time(Class(Time,Time#('01:00','hh:mm')),'hh:mm')

Expression

Interval(SUM(Duration))

[Anonymous]

Hi

That worked great, what do i do to get only the hours between 07:00 and 18:00, and if possible can i even show the hours where no event occurs.

Right now i show events for 7,8,11,12,14,15,16,17 &18 on my chart, can i get the gaps filled in so that every hour between 07 and 18 is shown.

Thanks in advance

des

[MK_QSL]

May be go to presentation tab and untick suppress zero values..

if this would not work, share sample data in excel file to work.