How is the "Average Days to Remediate By Severity" dashboard card calculated?

I am trying to recreate the “Average Days to Remediate By Severity” dashboard card in an external analytics tool and need to know exactly how this is calculated, i.e. which fields from the data model are used and how.

The reason I’m doing this is that we have multiple subsidiary companies using the same console and I need to break down this metric by site or tag. Using the manual dashboard filters won’t work at this scale and I need to show all of them together.

Thank you.

Average Days to Remediate By Severity

1 Like

I would like to learn what that magic query is as well :wink: And does anyone know how this query is done?
image

I am wanting to use it in metrics to our board. But I am not sure what it is making this work.