Diagram of estimated hours for each assignee

[Michael Kaufmann]

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?

[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.

[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

[Michael Kaufmann]

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]

Hey,

sadly there is still an error below the search bar:

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

I copied your string exactly.

[Pasam Venkateshwarrao]

@Michael Kaufmann 

If you're using a ScriptRunner function like aggregateExpression(), this is correct:

issueFunction in aggregateExpression( "Remaining Estimate", "remainingEstimate.sum(filter = 'assignee = venkat AND project = ABC')" )

If you're still unsure, paste your full query 

[Michael Kaufmann]

I Just Copy and Paste the String you posted Yesterday.

[Pasam Venkateshwarrao]

@Michael Kaufmann can you try with the query which i have shared in the previous reply

[Michael Kaufmann]

Something is wrong with "filter ="

[Pasam Venkateshwarrao]

@Michael Kaufmann This is the correct syntax if you're using ScriptRunner Cloud and want to get the total remaining estimate for a user, filtered by project and fixVersion:

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

Hope this helps