topic Unable to get correct Average time Gauge Chart in QlikView

Unable to get correct Average time Gauge Chart

Tue, 14 May 2013 11:16:14 GMT

Hi,

I have a Gauge Chart that looks like a speedometer, which I need to represent my average fix times. I have a field called (fix_time_true), which pulls out the fix time on each incident. However in my guage chart, the speedometer shows correct, however in the Presentation Tab -> and text in chart section, I have the following code - =avg(fix_time_true). However this pulls it out as 0.0464400008 and it should show an average of 1:06:52.

The fix time is in seconds and in the load script I ran the following ,interval(time(fix_time/86400, 'hh:mm:ss')) as fix_time_true.

Regards,

Jon Ditchfield

Re: Unable to get correct Average time Gauge Chart

Tue, 14 May 2013 11:45:31 GMT

Have you already tried somthing simple like =time(avg(fix_time_true))?

Re: Unable to get correct Average time Gauge Chart

Tue, 14 May 2013 12:01:29 GMT

Thanks for the help mrdaan, I was being a bit of an idiot . I was looking at my times and then trying to work out the average so for example I was trying to work out the average of 00:00:01 and 00:00:03, which obviously would be 00:00:02. However I forgot that the list box I am using to look at the fix time only contains the distinct time. I noticed that there was probably 15 00:00:01 and only one 00:00:03.

In the end I had to run =interval(time(avg(fix_time_true))) as some of my times are over 24 hours.

Re: Unable to get correct Average time Gauge Chart

Tue, 14 May 2013 12:15:23 GMT

Jonathan,

on another note. It's advisable to keep your load script as simple and plain as possible, i.e.: in seconds or with timestamps. your fixtime will then be timestamp_end-timestamp_begin which will return an integer. All the necessary formatting can then be done in the front-end, this will save time-consuming errors and keep your scripts simple. It will also allow you to build faster apps.