Attlasian Analytics August Office Hours Recap

[#1]

Hi everyone,

In case you missed it, we held another round of office hour sessions last week. Thanks to everyone who came and asked questions . We hope that you learn new tips and knowledge on Atlassian Analytics and Atlassian Data Lake through these sessions, enabling your organizations to get more value and insights.

👉  Remember to join our chapter on ace.atlassian.com to be notified of new Analytics office hour events!

----------------------------------------------------------------------------------------

Here are some of the questions and answers that came up during this round of office hours:

Q: In a Google Sheets connection, should charts update automatically when data changes? Can we set the frequency of how often this refreshes?

A: Charts querying Google Sheets data sources in Atlassian Analytics will pull the latest Google Sheet data when new queries are run. A dashboard may be showing cached data according to your dashboard’s cache settings, but when the chart refreshes next it will return updated data. You can also manually override the cache by refreshing an individual chart or dashboard.

Q: Can you provide documentation related to the SQLite functions that can be used in Atlassian Analytics?

A: The SQLite documentation is a great resource to use when you’re first learning SQLite functions, or if you’re having trouble with a specific function. Our documentation also has a few examples of SQLite date and time functions and string functions that can be used within a custom formula in your Visual SQL step.

Also, a new feature to write your SQLite expressions using Atlassian Intelligence is now available in beta in your “Apply formula” and “Formula column” steps.

Q: Can we email dashboards to external users?

A: Atlassian Analytics dashboards can't be emailed to external users via dashboard subscriptions. To be able to receive a dashboard subscription a user will need to have been granted product access to Atlassian Analytics and also have access to the dashboard.

Q: Are you able to cross join datasets between Atlassian Data Lake and Enterprise Insights?

A: Yes, if you have both Atlassian Data Lake and Jira Align Enterprise Insights as data sources in Atlassian Analytics, you can merge data from both sources to create a chart using a Visual SQL “Join” step. By adding a new query and changing the data source, you can query the second data source and combine the data results from both queries.

Q: Can you give us an example use case on "Zero Fill" option?

A: The "Zero Fill" step can be used to fill in any missing data with a zero. For example, in the screenshot below only two of the issue types have Story Points associated with them.

We can use a “Zero Fill” step to have the other issue types display a 0 instead of null.

“Zero Fill” will also fill in missing dates in a date range if you are working with time series data, as shown in this example.

Q: Are there any tips and tricks for creating drilldowns? Could you show an example of drilling down to another dashboard and passing through the variables?

A: This documentation page has the steps you can follow to set up a drilldown. Once you have a basic understanding of how to create a drilldown, you can use the following steps to drill down into a different dashboard.

1. Create the chart (chart 1) that will be used to filter the second chart. Save the chart to Dashboard 1.

2. On Dashboard 1, create the control(s) that will be used to filter the second chart.

3. Open chart 1’s settings and switch to the Drilldown tab. Select Dashboard 2 as the Linked dashboard, then configure the drilldown variables.

4. On Dashboard 2, create the second chart that the drilldown will filter.

5. On Dashboard 2, create the same control(s) you configured in step 2. Then connect those controls to your chart.

6. Select a value in chart 1 to drilldown into chart 2.

If you are using drilldown to link to another dashboard, you can also check the “Pass all variables” checkbox to pass all current values of any existing controls from the first dashboard to the second dashboard if the controls on both dashboard are identical.
----------------------------------------------------------------------------------------

Thanks again to everyone who joined us! As always, don’t hesitate to contact support for any assistance outside of office hours.