Hi guys,
would just like to ask the best way to get the age of a ticket already excluding the time when a ticket is on hold?

For example a ticket filed on Jan 29, 2024 and it was closed on Feb 2, 2024 but it was put on hold from Jan 31-Feb 1, 2024 so ticket age should just be 2 days.

I tried using analytics on zoho desk however, im getting a very large discrepancy please see screenshot below

ticket was created on Feb 2023 and closed on July 2023 (5 months apart) however, i tried adding ticket age on column and it outputted 12 months