Adding on to the other suggestions that this feature is not available with out-of-the-box Jira...
How often do you need to perform this check? If you need it just once, consider exporting the information to a spreadsheet and perform the check there. If you instead need it often, consider getting a marketplace addon (e.g. ScriptRunner) or building this query dynamically using an automation for Jira (A4J) rule.
You can try out our add-on to visualize the progress and status of your complete hierarchy of linked issues, cross project as well, on a single page.
Below are the key features:
The app provides more than 7 types of time in status reports
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events