CREATING A GAUGE CHART WITH TIMES

[#1]

Hy, i need your help.

I´m trying to make a gauge chart with AVG times.

See the image.

The time have to do this.

00:00 to 01:00 GREEN

01:00 to 02:00 YELLOW

> 02:00 RED

Here is my informations (data)

I´m using a AVG function in qlikview to generate de AVERAGE of times like this

=avg(distinct(time))

My load contain

TEMPO_VERDE:
LOAD

TIME
FROM

D:\HGP_BI\QVDS\tempo_cadastro_atend_verde.qvd (qvd);

How can I do this?

[#2]

This is a very simple example but something that you can work with

[#3]

Hi

Try the following code

avg(hour(Time) + minute(Time)/60 + second(Time)/3600)

[#4]

Hy, thanks.

The average is work. Just avg(time).

My problem is how to make a gauge chart with diferents points like

SEGMENT1 00:00 TO 01:00

SEGMENT2 01:00 TO 02:00

SEGMENT3 02:00 TO 03:00

Would you help me?

[#5]

Did you try opening the attached demo in the previous post? If this can not help you will you attach your file / chart

[#6]

Hi,

here is an example to your question.
You can set the segments with a formula like 'time#('01:00','hh:mm')'.
Hope, that helps.

Stefan

[#7]

in the presentation tab.

untick autowidth segments and relative segment bounds and then select the segements and enter your segment boundries as e.g.

='01:00:00'

with the apostrophes.