How do i get Total SUM of custom field after adding JQL?

[Pratik Fulkar]

hello,

So in my automation rule Im using lookupissues for get all issues in last 1 week and 1 month for reports to send via mail.

So i want the total sum of custom field (type number) from last 1 week.

[Pramodh M · Accepted solution]

Hi @Pratik Fulkar

Welcome to the Community!!

Here is the example 

{{lookupIssues.Panel ID.sum}}

Thanks,
Pramodh

[Pratik Fulkar]

@Pramodh M Thank you for the response,

can i know ,where will get that Panel ID for custom field.

[Pramodh M]

@Pratik Fulkar 

Panel ID is the Number type Custom field, we have to create that Jira Administration UI and then add it to the respective project.

The automation will calculate the panel ID value of issues returned from JQL and creates a new issue to store the calculated sum value

[Pratik Fulkar]

its worked

[Pratik Fulkar]

Thank You @Pramodh M 

its work for me....