Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

after save as filter, aggregateExpression can't display calculation result

CHEN How July 30, 2021

I can use below JQL to calculate and display the result:

project = [project_key] AND issueFunction in aggregateExpression("Total Estimate for all Issues", "originalEstimate.sum()", "Total Time Spend", "timespent.sum()", "Total SP", "storypoints.sum()")

calculation.png

However, after I save below code as common filter, eg, calculator_aggregated_effort 

issueFunction in aggregateExpression("Total Estimate for all Issues", "originalEstimate.sum()", "Total Time Spend", "timespent.sum()", "Total SP", "storypoints.sum()")

Then I call:

project = [project_key] AND filter = "calculator_aggregated_effort", above calculation can't display, does anyone know this issue?

1 answer

1 accepted

0 votes
Answer accepted
Gaurav
Community Champion
August 1, 2021

Hello @CHEN How 

Welcome to the community!!

This is a really interesting question and something which I can replicate.

The challenge is as soon as we try to use the saved filter as 'filter = "calculator_aggregated_effort" '.

In the documentation from Adaptavist, it is mentioned that the calculation is not saved anywhere. In case, the calculations are required then scripting would be required.

The documentation can be referenced here.

Please accept the answer if this helps solve your query else respond and allow others to share input.

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events