Issue Statistics gadget to be filtered by Release and Sprint Name

[Helen Pippard]

Hello

I am very new to JIRA software (Server version) and have started our first ever sprint (That new)   Within confluence and the JIRA dashboards I want to display a report which shows the issue statistics by the fields available I.e. Assignee but with the ability to filter the overall gadget by the name of the release and the sprint but I cannot find a way to use JQL within the already existing gadget

I have read quite a few threads about writing this in SQL.....but I was wondering if there was an easier way to achieve this?

Best wishes

Helen

List of what I have seen so far:

https://community.atlassian.com/t5/Jira-questions/Issue-statistics-per-Sprint/qaq-p/887539

https://community.atlassian.com/t5/Jira-Software-questions/How-to-get-Sprint-issue-list-by-SQL/qaq-p/320487

[Kat Warner]

Sprint in openSprints()

is the JQL that will give results that dynamically update as sprints are opened and closed over time. 

I find the Two Dimensional Filter Statistics gadget to be helpful in early dashboards to see project and filter results by fields like assignee, status, priority, etc.

[Helen Pippard]

Thank you for your help...Your response is useful and have already applied it

Thanks

Helen