How to get 'Average Time in Status' using SQL

[Valeriia Iuzhakova]

Hi,

Because of the issue, I am trying to build a query in Redash that will return the average time spent in status at given period (the same as 'Average Time in Status' gadget do).

Has anyone tried this?

Thanks in advance.

[Nic Brough -Adaptavist-]

Yes, and I ran away screaming because it's a horrible thing to do.

I wrote a couple of scripts to expose it instead, it's far safer and easier.

[Valeriia Iuzhakova]

I see. So could you share some examples, for better clarity?