Atlassian Analytics Updates - September 2023

[#1]

Hi everyone,

September was full of exciting product updates! Keep reading to see what's new and what's coming.

✨ Recently shipped

Six new dashboard templates

We’ve released more dashboard templates that you can use for Atlassian Data Lake connections that include Jira Software data or Jira Service Management data.

• Jira Software

  • Sprint overview

  • Time in current status

  • Time in status history

• Jira Service Management

  • Service desk scorecard - Customer experience

  • Service desk scorecard - Service desk operations

  • Service desk scorecard - Requests needing attention

Ability to connect to Google Sheets

Connect Google Sheets spreadsheets that you own to bring in supplemental data to use in your charts and dashboards. Get started by selecting Data from the global navigation > Add data source > Google Sheets. Read more in our Google Sheets announcement.

Edit join path in visual mode queries

View and interact with a visual representation of your visual mode query’s JOIN clause in the new Join path panel. Read more in our join path panel announcement.

Chart borders

You now have the option to add chart borders to your charts. Every new chart you create will include this option. To add it to existing charts, select Show border in the "General" tab of your chart settings.

Data Lake updates

Faster query performance for 4 Jira tables

To address performance concerns, we will be introducing efficiency changes to four commonly queried Jira tables: jira_issue, jira_issue_cycle_time, jira_issue_status_history, and jira_project. With this change, it will now take 3-6 hours for data to refresh in these tables. Read more in the announcement.

Issue hierarchy data

We’ve finished the rollout to include more parent data in the “Parent” field of the Data Lake! You’ll now be able to see hierarchies higher than epics when you query data for this field. Read our post for more details about the issue hierarchy improvements.

Date format update in Assets column

The format for date values in the “Assets object attribute” table’s “Attribute value string” column was previously not in the standard date format. We’ve changed the format of these dates to ISO date so you can now easily parse the data using SQLite.

Breaking change to Opsgenie team ID

The format for values in the “Team ID” column in several Opsgenie tables was recently changed. If you have any charts or dashboards that refer to specific values from this column, you’ll need to edit them to use the updated values. Read our post for more details about this change.

New columns

• Jira Service Management “Service” table - “Opsgenie owner team” column

• Opsgenie “Account settings” table - “Time zone” and “Is blocked” columns

• Opsgenie “Alert” table - “Source” column

• Opsgenie “Notification” table - “Destination” column

👀 Coming soon

“Parent issue ID” column

We’re almost ready to release the new “Parent issue ID” column in the “Issue” table under “Jira family of products”. Stay tuned for our announcement within the next couple of weeks!

📝 October office hours

The Atlassian Analytics product and support teams will host office hours on October 18th at 10 a.m. ET and 4 p.m. PT. If you're stuck on a chart you’re building or have questions about using the product, we’d love to hear from you! Register now to save your spot.