Atlassian Analytics Updates - October 2023

[#1]

Hi everyone,

It’s been another month of exciting releases! Read on to see what’s new and what’s coming.

November roadmap presentation and Q&A

The Atlassian Analytics product team will host office hours tomorrow, November 8 at 4 p.m. EST / November 9, 8 a.m. AEST. For this session, our Product Managers will walk through some of our latest releases and give a preview of what’s to come in the next few months. If you’d like to join, register now to save your spot!

Atlassian Intelligence beta - Natural language to SQL

Last week, we moved our Atlassian Intelligence feature into open beta. 🎉 This feature lets you use natural language to generate SQL queries for Atlassian Data Lake connections. Read how your organization can enable the feature to get started.

🎥 More video demos on YouTube

We've added 7 new videos to our YouTube playlist that cover topics such as:

• the value stream management dashboard templates

• chart templates

• querying sprint data

• querying custom fields

• creating "Dropdown" controls using the control editor
  
  

Recently shipped

Content editor

Last week, we introduced the Content editor. This editor contains all the content elements you know, along with advanced styling options that make customizing your dashboard easier. As a result of this release, the old functionality for creating individual content elements will no longer be available. Any existing text, line, and link content elements on your dashboard, will require a migration. We highly recommend that you migrate your content on your own to ensure it matches your preferred formatting and styling. Read how to migrate your existing line, link, and text content elements using our migration guide

Sparklines in table charts

Sparklines are the latest addition to our table chart visualization options. You can use them to track data trends over time. When you add a sparkline to your table, it will appear as a simplified mini chart that gives a clear overview of data trends, without all of the details that are in full-sized charts.

You can add the following mini charts to your table:

• Bar chart

• Area chart

• Line chart

Jira Align Enterprise Insights connector and dashboard templates

If your organization has Jira Align Enterprise Insights, one of your organization admins can now connect it to Atlassian Analytics. Once connected, you’ll be able to create your own custom charts or dashboards to analyze your Jira Align data, or use one of the five new dashboard templates that are available. Read more in our Enterprise Insights announcement.

Updated Assets dashboard template

We’ve replaced the “Assets overview” dashboard template with a revamped version titled Reports for assets. This new template has lots of new charts to give you even more insight into your asset and configuration management data within Jira Service Management.

Product filter for browsing dashboard templates

To help you browse through our growing list of dashboard templates, we’ve added a product filter to make it easier to find dashboards that are specific to particular products.

Data Lake updates

“Parent issue ID” column

Now that more issue hierarchy data is available in the Data Lake, we’ve added a new “Parent issue ID” column to make it easier to query parent-child relationships. The new column is in the “Issue” table under “Jira family of products”. Read more about the new column and check out the video example in our announcement.

Coming soon

DevOps data and dashboard templates

We’re almost ready to release a new set of tables that will enable you and your teams to query the data from the DevOps tools you’ve connected to Jira Software. New dashboard templates will follow shortly!

More Opsgenie data and dashboard templates

Stay tuned for 9 new Opsgenie tables and a handful of new dashboard templates to accompany them!

“Issue affected version mapping” table

We’re introducing a new Jira table to query issues and the project versions where the bug/problem was found.

[Matt Lane]

Hi team,

We followed the "Querying custom fields" video tutorial and were able to setup some charts that query some basic custom fields (dropdowns) and were able to add controls to allow for filtering of the field's values in the charts.

The next step for us that we are curious to learn, is how to do the same with the following advanced custom field types, as we have specific data in our service projects we would love to report on that use these:

• Cascading fields       (and ideally having control/s for setting Parent and Child combinations)
• Asset object fields    (so we can report on Jira issues where particular asset/s were linked)

Thank you!

[Tracy Chow]

Hi @Matt Lane ,

Glad you were able to utilize the available video tutorials.

We just published a new knowledge article that walks through how to setup parent and child dropdowns based on a cascading field.

For querying asset objects linked to Jira issues, you can reference the examples in the Assets data query examples article.

Hope you find these helpful. Let us know if you have further questions.

[Matt Lane]

Thank you @Tracy Chow !