Average Ticket Open Time Excluding On Hold Status

Kpennington

Hi There,

I am trying to report average ticket open time, but we do not want anything with a status of On Hold factored into the calculation.

This is my current formula. Open Time is a helper field that subtracts today from date submitted.

=ROUND(AVG(COLLECT([Open Time]:[Open Time], [Open Time]:[Open Time], @cell <> "")), 1)

How would I add the exclusion for anything with status = on hold?

Genevieve P.

Hey @Kpennington

You can add another column and criteria into your COLLECT function, like so:

=ROUND(AVG(COLLECT([Open Time]:[Open Time], [Open Time]:[Open Time], @cell <> "", Status:Status, @cell <> "On Hold")), 1)

Cheers,

Genevieve

Genevieve P.

Hey @Kpennington

You can add another column and criteria into your COLLECT function, like so:

=ROUND(AVG(COLLECT([Open Time]:[Open Time], [Open Time]:[Open Time], @cell <> "", Status:Status, @cell <> "On Hold")), 1)

Cheers,

Genevieve

Kpennington

Thank you so much! That worked perfectly.