Atlassian Analytics January Office Hours Recap

[#1]

Thanks to everyone who attended our office hours sessions last week! We appreciate being able to engage with you all directly and hope you walked away with helpful takeaways on how to use Atlassian Analytics and Atlassian Data Lake further through our demos and Q&A.

To recap the topics discussed in both sessions, here are some of the top questions and answers that came up during this round of office hours:

Q: Do archived issues appear in the Atlassian Data Lake, or are they removed?

A: Archived Jira issues are returned from Atlassian Data Lake when queried in Atlassian Analytics. We’ve created a feature request ticket for archived issues to be more easily identifiable from the Atlassian Data Lake so they can be filtered out if desired.

Q: How do you view the SQL used in a chart?

A: There are a few different ways you can view the SQL used to create your queries in an Atlassian Analytics chart:

1. When you’re in the chart editor you can select Xs elapsed to the right of the “Run query” button to see the SQL query executed by the chart. If you have any dashboard controls connected in the query, the Executed query shows the actual value(s) selected in the dashboard controls, while the Generated query shows the SQL syntax used to connect the control in the SQL query.

   

2. Toggle the query into SQL mode to see the full SQL. This SQL will be similar to the SQL found in the “Generated query”.

   

3. Select Review performance option from the chart’s More actions menu and view the SQL used for all the chart’s queries. Using this view will also let you see the date and time the query executed, how long the query took to run, and what action triggered the query.

   

Q: How do I connect a dashboard control to the charts on my dashboard?

A: If you created a dashboard control using the pop-up, you can select the Connect this control to new and existing charts setting, which will automatically connect your control to all queries in your charts. Note that this setting isn’t available for “Calendar”, “Date bucket”, and “Hidden variable” controls.

If you create a control using the control editor, or would prefer to manually connect the control yourself, you can refer to the documentation of the specific control type for detailed instructions on how to manually connect the control. Additionally, you can watch this video to learn how to create a “Dropdown” control in the control editor and connect that control to a chart.

Controls automatically connected will be highlighted in purple in the “Filters” section of your query, while manually connected controls will be highlighted in green.

Q: I am interested in looking at flow metrics. How can I find that in Atlassian Analytics?

A: We have dashboard templates with charts you can use out-of-the-box to track the flow metrics of your Jira Software value streams looking at metrics such as throughput, lead time, and cycle time. Once you create a dashboard with these templates, you can choose to customize it to fit your organization.

• Flow metrics (Jira issue types view) dashboard template

• Flow metrics (work items view) dashboard template

If you have Jira Align Enterprise Insights, you can also connect Enterprise Insights as a data source in Atlassian Analytics so you can access the dashboard templates for Jira Align Enterprise Insights.

Q: How would I filter by the Story Points custom field if the Story Points value is stored as text?

A: If you have a column that is currently being stored as a string, but you wish it to be numeric; You may add a custom formula Visual SQL step which multiplies the column by 1.0. This will effectively cast the column as a numeric and it can be then used in filtering with numeric comparators (=,<,>)

Additionally, if you are using a Custom Table to pull in story points, you may simply add a CAST statement to your underlying query:

Q: How do I query issues with issue hierarchy in Atlassian Analytics?

A: Our knowledge base article on how to query parent and child issues from Jira has detailed instructions on how to use the “Parent issue ID” column from the Jira “Issue” table to query your issue hierarchy data. The article has an example of how to query issues with two and three levels of hierarchy, but you can use the same steps to query 3+ hierarchy levels.

Q: What resources are available to learn how to use Atlassian Analytics?

A: We have a variety of resources available to help you learn how to use Atlassian Analytics. We have our documentation which can help you learn the technical features of Atlassian Analytics while the knowledge base articles build upon the docs by giving step-by-step instructions on how to query certain data, transform the data, customize a chart setting, etc. Additionally, we have a set of YouTube videos that can help you learn how to use Atlassian Analytics further. There are also chart and dashboard templates which can serve as a starting point to help you find value using Atlassian Analytics until you’re comfortable building your own charts. Finally, we have the product community (you’re here now!) where you can see what questions other users have already asked, keep informed of product updates like newly released features, or ask your own questions.

We hope to see you at our next session on March 6 AMER / March 7 APAC! As always, don’t hesitate to contact support for any assistance outside of office hours.