Status Reporting in Jira

Question

Hi there, I want to create a Status Report in Jira and pull this data into Tableau. What would be the best way to go about this so we can pull together an overview of Status reports within a Portfolio?

Would include large text boxes highlighting priorities for the week and then your typical RAGs etc.

Mehmet A _Bloompeak_ · Answer

Hi @Sean ,

As an alternative, you can try Status Time app developed by our team. It provides reports on how much time passed in each status as well as status entry dates and status transition count.

Once you enter your working calendar into the app, it takes your working schedule into account too. That is, "In Progress" time of an issue opened on Friday at 5 PM and closed on Monday at 9 AM, will be a few hours rather than 3 days. It has various other reports like assignee time, status entry dates, average/sum reports by any field(eg. average in progress time by project, average cycle time by issue creation month). And all these are available as gadgets on the dashboard too.

Here is the online demo link, you can see it in action and try.

If you are looking for a free solution, you can try the limited version Status Time Free. Hope it helps.

Yuliia Maidanova -Alpha Serve- · Answer

Hi @Sean

You can try our Tableau Connector for Jira https://marketplace.atlassian.com/apps/1221376/tableau-connector-for-jira?hosting=server&tab=overview

It will help you to pull all your data from Jira to Tableau in a minute. The app has many features such as:

* Various Filtering Options, including Basic filters or JQL
* Jira Core & Jira Software fields including Custom fields, History, Agile
* Calculated fields such as Time at Current Assignee, Time at Assignee, Time in Status
* Permission and Sharing settings for multi-user and groups environment for secured Jira data sharing

Feel free to contact our support team if you need any kind of assistance
Email us at: support@alpha-serve.com

Julia Turchenko,

Marketing Manager at Alpha Serve