Average number of issues calculated from the results of two separate issue filters

[Hayden Smith]

We have two separate filters. One that will give total counts of reviews done in the last week, and the other that gives the total  number of issues found during those reviews. They look like the following:

First Filter: project = APPS37 AND issuetype = "Audit" AND text ~ PDR AND created >= -1w ORDER BY priority DESC, updated DESC

Second Filter: project = APPS37 AND issuetype = "Audit Issue" AND "Audit Type" = "Post Design Review" AND created >= -1w AND "PDR Category" not in (Note) ORDER BY priority DESC, updated DESC

desired result:
Count(second JQL)/ Count(first JQL)

We would like to find the Average Number of total issues that both of those filters produce (ex: first filter produces 5 results and second filter produces 31 results for an AVERAGE of 6.2 issues),  and if possible display them as a gadget on the dashboard. Does anyone have any suggestions or are you aware of any plugins that can help with this? Andy advice is appreciated, thanks!

[Alexey Matveev]

You could use a free add-on Power Custom Fields

https://marketplace.atlassian.com/plugins/com.keplerrominfo.jira.plugins.keplercf/server/overview

You can create a custom field, which would show you such info and put the field on the dashboard.

You can do the same with ScriptRunner, nFeed.

[Hayden Smith]

Thanks Alexey! We were able to script a field to do this via scriptrunner.