JQL is not SQL, it is for finding issues, not telling something what to display.
You should be able to construct JQL to find the issues you want to report on, but the real challenge is going to be finding something to show you the data you want from the issues. There is a "time in status" report, which I think will try to tell you something, but I have not found it to be that useful myself.
Hi everyone! My name’s Matt and I’m a product manager at Atlassian. I work in the navigation & findability space for all our Jira Cloud products. We’ve been working on trying to improve the exp...
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