How to get a report from a group of issues?

[Hildon Gomes]

Hello, first of all, I have to say that I'm just using Jira for about 3 months, so I'm really newbie here.

I have 9 projects, 27 squads and I want to extract some information weekly, like "how many story points we have with done status for Issues 1234, 5678 and 3423?"

The Issue that I want the information is called Goal. That is our arrangement:

• Goal (Issue type)
  •  Feature
    • Story

So, let's draw a scenario:

• Goal 1
  • Feature 1
    • Story 1: 13 Story Points/Status Done
    • Story 2: 8 Story Points/Status Canceled
    • Story 3: 5 Story Points/Status In Progress
  • Feature 2
    • Story 1: 13 Story Points/Status Done
    • Story 2: 8 Story Points/Status Canceled
    • Story 3: 5 Story Points/Status In Progress

My question 1 is: how many story points Done, Canceled and In Progress the Goal 1 have?

My question 2 is: how to extent this to another's Goals from other squads (from the same and different projects too)?

In addition, I just want data from issue Goal, so, if the answer pass through excel export, I don't need to view stories.

[Rebekka Heilmann (viadee)]

Hi @Hildon Gomes and welcome to the Community!

What kind of Report are you expecting? On Sprint Boards you have Epic Reports that gives you something like that - however, your "Goal" Issue Type would need to be an Epic. View and understand the epic report | Jira Software Cloud | Atlassian Support

Depending on whether you want the report real time or archived as seperate files there are several options.

Have a look at this thread: Solved: How to sum Custom fields using Automation in Jira (atlassian.com). You can iterate through Child issues or linked issues (depending on how your hierarchy is set up) with Automation. For the sum to be saved in the "Goal" Issue Type, you would either need a new Custom field or use the Story Point estimate field for that purpose.