Tracking the age of bugs

Is it possible to track the average age of open bugs?

Is it possible to track the average as of closed bugs (i.e. duration from created to closed)?

I would like to calculate all of this in Azure DevOps to create a dashboard. I know how to do this in Excel, but I would like to keep it all in Azure to achieve real-time updates.