Report that shows a list of all Affected Services and the Amount of Issues this week

[Constantin Lotz]

Hi there,

I would like to have a report to see which "Affected Services" are most relevant and show me the amount of issues for each services.

That is not possible with the default reports right? I could just create a series (by hand) for each service to filter with.

Kind regards,
Constantin

[John Funk]

Hi Constantin,

If the Affected Services field is a pick list, you should be able to add an Issue Statistics gadget to a dashboard and use that field as the issue statistic. That will give you a count per service.

[Hannes Obweger - JXL for Jira]

Hi @Constantin Lotz

if you're open to solutions from the Atlassian Marketplace, I think you might like the app that my team and I 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 issue grouping by any issue field(s), and sum-ups. All these work with Affected services, too:

As you can see above, the view remains fully interactive - meaning that you can work on your issues straight away (but also trigger various operations in Jira, or export your data with just one click).

Any questions just let me know,

Best,

Hannes

[Anna Kondrateva]

I gave it a try, and it looks like the grouping works only if I query against the JSM project. I also have Affected Services used in the Software project, but they are not available for grouping there for some reason