Average Ticket Open Time Excluding On Hold Status

Question

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. · Accepted Answer

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