Summarize values of specific issues

[Leonard Winck]

Hey there,

I'd like to calculate how much time has been spent on which customer in the last month.

All our issues have two custom fields which are required when closing an issue: Incident source and customer.

If the incident source is internal, it should summarize the time of all those.

If the source is selected as external, the sums should be sorted by the specified customer.

What's the best way to do this? Is there even a way to do this inside of Jira, or would I have to rely on an external application, such as Tableau?

[Mohamed Benziane]

Hello @Leonard Winck 

Welcome to the community.

You can't do this out of the box. You can use the API and create some script or look for an addon on the marketplace. Third solution as you are on server, retrieve the data from your database (create a backup and play with it)

Hope this helps.