How do I compute the time that went into a customer relationship in a month?

Question

- in the field time spent we report the time that went into a ticket

- in the field organization we note the client we worked for

now I would like to find out how much time was invested in each organization through working on the respective tickets. The time spent in a given month would be the ideal figure. But I could also live with a number for the amount of time that was invested in the tickets that were created in a given month - which can differ as the tickets sometimes get opened in one month and then get close the month later.

Hannes Obweger - JXL for Jira · Answer

Hi @Björn Goerke

if you're open to solutions from the Atlassian Marketplace, you may want to have a look at 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 - including all JSM 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) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting.

With these, you can build a report like e.g. this in just a couple of clicks:

This is just one of a virtually endless number of possible reports; you can also group by any other field, configure different sum-up styles, etc. etc. As every JXL sheet is powered by either a saved filter or a JQL statement, you can also easily create cross-project views.

Any questions just let me know,

Best,

Hannes

Björn Goerke · Answer

thank you, Marc! I will look into the automation functions.

Björn Goerke · Answer

thank you, Dwight! Sounds very good. I will look into this.