Gauge with time measures

[#1]

Dear QV Community,

I am trying to create a gauge measuring time frames of jobs (I'd like to take the average of numerous jobs, and enter points in the gauge as per my attached image).

I have included an excel sample of the data that I am pulling from our SQL database.

What we have is Event Descriptions, and times that the events took place.

I may be trying to use the wrong object.

Please could you perhaps assist?

Thank you.

Kind regards,

Shona

[jpenuliar]

The object in your pptx is a linear gauge equivalent in qlikview, you can use the qliview sample file "Data Visualization" to seeit in action.

[jpenuliar]

you can also have a look at Qlikviwe sample file "My Life in Data", Running Tab, at the bottom there is a visual  with caption "How Far is That?" it shows a linear gauge using Stacked Bar Chart object.