Linking Issues with Sprints

[felix_schoch]

Hello, I extracted the tables form jira and added it to our DWH. I want to create a detailed sprint report in tableau. This is the ERD I found:

https://docs.google.com/presentation/d/1UPq2CWnqQpbjLxkTrcWvAekaZ0o0OdzXODTVmUXeGvs/edit#slide=id.g1379aea0489_0_591

My question now is how can I link the issues and the sprints?

If I link the issue to the board and the board to the sprint, it doesnt give the results that I am looking for, which makes sense if the board is always the same, but what other way could work?

Thanks a lot!

[Fabio Racobaldo _Catworkx_]

Hi @felix_schoch and welcome,

you should drag and drop an existing issue to an active sprint within your board.

https://support.atlassian.com/jira-software-cloud/docs/add-issues-to-an-active-sprint/

A board has one or more sprints and issues are in the backlog.

Hope this clarifies,

Fabio