New "Story points" and "Priority" columns in related issue tables

[#1]

Hi community,

We have two updates to share about querying issue Story point estimate and Priority in Atlassian Analytics.

Story points can now be queried directly from the Jira family of products “Issue” table

We're happy to share that a new “Story points” column is now added to the “Issue” table under Jira family of products.

This new column is in numeric format, which means you can perform aggregation functions directly on the values, without converting the format.

Existing dashboards won’t be affected by this change because you can still query the “Story point estimate” field from the “Issue field” table too. However, this new column will make it easier to query and use the values in your charts.

Note: This new column only holds data for issues in team-managed projects. To get story points for issues in company-managed projects, you’ll need to use the “Issue field” table.

Priority can now be queried directly from the Jira Service Management “Issue” table

We’ve also added a new “Priority” column to the “Issue” table under Jira Service Management. This means you can query “priority” for all Jira Service Management issues directly, as opposed to having to join on the Jira “Issue” table.

Unlike the “Priority” column in the Jira “issue” table, this new column refreshes every 30 minutes or so.

How to get the new columns

For new Data Lake connections, the new columns will automatically be available.

For existing Data Lake connections, an organization admin needs to edit the connections to get the new columns. They can edit the connection and save it without making any changes. Read more about editing Data Lake connections.

Comment below or contact support if you have any questions or concerns. Thanks!