Count issues based on 4 different queries, multiply by number and divide by sum of "all" issues

[Maik Pomp]

Hi there,

currently i'm using some basic JQL queries:

• A: statusCategory = Done AND resolved >= -12w
• B: "TI-CVSS nachbewertet" > "0" AND "TI-CVSS nachbewertet" < "6" AND statusCategory = "In Progress"
• C: "TI-CVSS nachbewertet" >= "8" AND statusCategory = "In Progress"
• D: "TI-CVSS nachbewertet" >= "8" AND statusCategory = "In Progress"

Also i'll get the sum of all issues found this way. Using excel A is multiplied by 3, B by 2, C by 1 and D by 0. The sum of (A',B',C' and D')/(A+B+C+D) gives me a score between 3 and 0 (mostly floating around 1,5).

I'm would like to do this all within Scriptrunner (not having to use excel to do the calculations). Is this possible?

Greetings

Maik