Tableau Connector for Jira (Cloud)

Tables Filtering Cases Demo

Case 1: Export the Sprint Report Issues table narrowing the resulting data set

Each exported table has its filtering flow, which depends on the activity of various GLOBAL and LOCAL filters. The influence of individual filters on the table export as a whole can be described by the following logical pattern:

Filters for the main entities of the exported table mainly combine the resulting filtered data. Filters for the depended entities mainly filter our data that was collected by the main entities filters.

Consider the Sprint Report Issues table as an example.

In the Sprint Report Issues table, the main entity is the board. The sprint that is associated with this board is a dependent entity. The issue that is associated with this sprint is also a dependent entity.

P and B.jpg

Thus, when you apply filters by Projects and Boards, the resulting filtered data will be combined. You will get all boards linked via JQL to the selected project and the selected board.

Brojects and Boards 2.gif
P and B - Combined result.gif

If then, you apply filter by Sprints, the resulting filtered data will be reduced.

Remember that the filters for dependent entities filter out the data collected by the main entity filters. In this scenario, if you select sprint that do not belong to any of the boards selected in the filters by Projects or by Boards, the resulting filtered data will be empty.

Thus, each of the exported tables has its filtering flow, which can be used to achieve maximum filtering flexibility.

P, B, and S.jpg
Projects, Boards, and Sprints.gif
P, B, S - Filtered out result.gif

Case 2: Export specific sprint data from the Sprint Reports table

Sprint Report.gif
  1. Select a specific board and sprint in the Jira Software filters.

Select the corresponding board and sprint.jpg
  1. Select the required fields.

Select fields.gif
  1. Save data source, and then export it.

The Result-3.gif

Case 3. Export Board Issues with low priority on a specific board

Priority is low.gif
  1. Select a specific board in the Jira Software filters.

Select board-1.gif
  1. Enter the corresponding JQL in the local filter, and then select the required fields.

Filter by JQL.gif
  1. Save data source, and then export it.

Filter by JQL - The result.gif

Case 4. Export 2 specific sprints from the Sprint Reports table and all sprints of a specific board from the Sprints table to build a report

Board and its sprints.gif
  1. Select a specific board and sprints in the Jira Software filters.

B and Ss.jpg
  1. Deactivate the Sprints filter for the Sprints table.

Deactivate.gif
  1. Select the required fields.

imgonline-com-ua-twotoone-ieIagapf1L4xq7oY.jpg
  1. Save data source, and then export it.

Sprints - Result.gif
SprintReports - Result.gif