nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Diagram of estimated hours for each assignee

Michael Kaufmann_n28jn4

Is it possible with a filter query like

project = "abc" AND (fixVersion = V1 OR fixVersion = V1.1) AND issueFunction in aggregateExpression("remainingEstimate.sum()")

to show the estimated hours for each assignee?

Accepted answers

All comments

Pasam Venkateshwarrao

Hi @Michael Kaufmann

using ScriptRunner's issueFunction in aggregateExpression(...) is the right direction, but to get estimated hours per assignee, you need a slightly different approach because aggregateExpression gives you a single value across all matching issues, not per assignee directly.

issueFunction in aggregateExpression(
"Remaining for venkat",
"assignee = venkat AND project = abc AND fixVersion in (V1, V1.1)",
"remainingEstimate.sum()"

Hope this helps

Danut M _StonikByte_

Hi @Michael Kaufmann,

I'm afraid that it is not possible to display this aggregated data with the default tools of Jira & Confluence; you will need a plugin from Atlassian Marketplace.

If you consider the idea of using a plugin, our Great Gadgets app offers a Pivot Table & Pivot Chart gadget that allows you to calculate the stats you need and to display them in form of table, heatmap table or charts of various types. Here are some examples:

The gadgets offered by Great Gadgets for Jira Data Center can be also imported and used as macros in Confluence.

To get a diagram like this, the gadget/macro must be configured with a filter/JQL that returns the issues to be counted, as in this example:

Danut.

Michael Kaufmann_n28jn4

Sadly this leads to an error:

Number of arguments should be 1 (provide the expression), or an even number with multiple expressions: (label1, expr1, label2, expr2, ...)
The LHS of an assignment should be a variable or a field accessing expression @ line 1, column 1.

Can you help here as well?

Pasam Venkateshwarrao

@Michael Kaufmann

Script Runner expects only one argument BUT — you’re giving 3 arguments, which causes this error, use the below JQL

issueFunction in aggregateExpression(
"Remaining for venkat",
"remainingEstimate.sum(filter = 'assignee = venkat AND project = abc AND fixVersion in (V1, V1.1)')"
)

Note:

the filter goes inside the remainingEstimate.sum() function now.

If it still throws an error, please share the exact error message, and I’ll help you fix it

Michael Kaufmann_n28jn4

Hey,

sadly there is still an error below the search bar:

Token ("=" at 1:30: "=" ) is not allowed

I copied your string exactly.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

jira

jira-data-center

data-center