Handling time applications in diffrent departments

[#1]

Hi

Really new to QV so hope someone can help me. I have diffrent departments, startdate, and stopdate and individually applications id. I would like to show the average handlingtime in each department in a chart. Whats the steps to take?

All form of help are appreciated!

[#2 · Accepted solution]

Department as Dimension

Avg(Stopdate-Startdate) as expression?

[#3]

+ Off course! thanks.

One more question, how do I exclude the posts that have stopdate = 9999999? (these are post that havent been handled yet)

[#4]

Change the expression to:

Avg({<stopdate-={'9999999'}>}Stopdate-Startdate)