Calculate sum of values

[Krishtee]

Hello,

Is it possible to get the total sum of all values  in Jira Dashboard?

Refer to picture below (column Lead Time).

Thanks.

[Jack Brickey]

Hi @Krishtee , it is difficult to understand what that image came from. Are you illustrating three different issues here? Assuming so my question would be where would you put the summation assuming you could calculate this? For example, let's say that you want to some up the estimation of all the stories under an epic and place that value in your epic. That would be something that could be done using automation.

[Krishtee]

Hi @Jack Brickey

I have a field "Lead Time" which is calculating the time difference between the created and updated time for a ticket.

I am working with issue type "Epic".

Each time a ticket is created and modified, the time difference is displayed in the dashboard under column Lead Time.

I have created another field "Total Lead Time".

When the calculation to get the total values  from Lead Time will be done, then the value obtained should be listed under column "Total Lead Time".

For example: if my column Lead Time has the following values: 20 mins, 30 mins, 5 mins, then Total Lead Time = 55 mins (20 mins + 30 mins + 5 mins).

Is this achieveable using automation?

Thanks.

[Jack Brickey]

So you already have a rule to calculate Lead Time, correct? If so here is what I am thinking.

update your current rule such that the first time in you copy Lead Time and on any update triggers you will add the current Lead Time to Total Lead Time before you update Lead Time. I may not have this precisely correct. But hopefully this is making sense?

[Krishtee]

My automation looks as follows:

But when the rule is executed, it is not returning any value in the column Total Lead Time.

Can you please advise?

[Jack Brickey]

Hi @Krishtee , I remain a bit confused. Pushing the Total Lead time aside for the moment. Can you confirm if Lead Time is a custom field? Can you show me how Lead Time is calculated? From what you have told me previously it appears that you have some automation that is calculating this value. Is that correct? Finally can you share a full image of your dashboard where lead time is illustrated?

[Krishtee]

Hello @Jack Brickey

Yes Lead Time is a custom field.

Sharing with you the automation that I have created to calculate the Lead Time.

This rule works well.

When this rule is executed the value obtained is displayed on the dashboard as follows:

The second part of my working is to calculate the sum of all the values obtained in column Lead Time.

To achieve this, I have created another custom field "Total Lead Time" and I have created another automation as follows:

However, when this rule is run, I'm not getting any result in the dashboard.

Let me know if anything is unclear to you.

[Jack Brickey]

Thanks that clarifies things a bit. The one thing I am still unclear on, or rather confused by is that in your first rule for leadtime, you seem to be focusing on epic issue type. Is lead time associated with the epic, or rather the stories under the epic? Assuming that your goal is to sum up the lead time of each story and place that value into the epic (parent) for those stories, then the following may be more of what you're looking for in your second rule.

• trigger - field value changes for Lead Time
• condition - issue type = story (or whatever type contains Lead Time)
• action - use JQL to lookup issues to find all related issues
  • project = xxx AND "epic link = {{triggerIssue.epic link.key}}
• branch - on Epic
  • action - edit issue, and using More options, try the following  JSON...

{
  "fields": {
   "Total Lead Time": {{lookupIssues.Lead Time.sum|0}}
  }
}

 
please note that I am doing this a bit from memory and have not been able to verify syntax, etc. hopefully it is close enough to get you there. 😉

[Krishtee]

Hello @Jack Brickey ,

Yes I am using only issue type Epic.

I tried to adapt my automation as per the rule you had suggested but, it's still not working.

[Jack Brickey]

Hi @Krishtee , if you were only using a single issue type, epic, then I don't understand where the summation would be stored. Let's say you have 10 Epics, which epic would have the total lead time summation for the other nine Epics? It looks like you are looking for a table column summation feature. This does not exist natively and if it is something you need there are a few options.

• leverage excel and export your data as needed
• use the APIs
• A marketplace addon as others have mentioned here

[Hannes Obweger - JXL for Jira]

Hi @Krishtee

I understand you are looking for a solution in plain Jira, but just for future reference if a Marketplace should become an option for you: This should be easy to do using the app that my team and I are working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a number of advanced features, including support for configurable sum-ups, either across all issues of your sheet, or across groups of issues if you use JXL's issue hierarchy or issue grouping capabilities.

This is how it looks in action:

As you can see, this view is fully interactive, meaning that you can work on your issues directly in JXL (but also trigger various operations in Jira, or export your data to CSV or Excel in just a click).

Any questions just let me know,

Best,

Hannes

[abhishek_sharma03]

Hi @Krishtee _ You may try https://marketplace.atlassian.com/apps/1211625/sumup-for-jira?tab=overview&hosting=cloud

BR

Abhishek

[Krishtee]

Hello @abhishek_sharma03

Thanks for your help but I want to accomplish it without using apps/plugins.

[Serosoft Jira Administrator]

Hi @Krishtee I'm using an app called "sumUp for Jira Cloud". See if it is useful to you. 

[Krishtee]

Hello @Serosoft Jira Administrator

Thanks for helping.

I want to get the calculation without using apps/plugins.