Atlassian Analytics

Once you’ve connected the Jira Align Enterprise Insights data source in Atlassian Analytics, the data source is set up with a default schema configuration. You can customize the schema configuration ...

• Article
• analytics
• enterprise-insights
• jira-align

We’re excited to announce you can now connect your Jira Align Enterprise Insights database to Atlassian Analytics! Enterprise Insights is a data mart that’s available to Jira Align Cloud customers, p...

• Article
• analytics
• enterprise-insights
• jira-align

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 dash...

• Article
• analytics
• data-lake

Today we're excited to announce a new feature to visual mode queries—the ability to edit the JOIN clause without needing to switch to SQL mode! JOIN clauses bring together two tables using foreign ...

• Article
• analytics

Hi Community,   I'm trying to display a list of dependencies based on a certain link type. However, issue link or link type doesn't seem to be available in Atlassian Analytics data lake. Am I ...

• Question
• analytics

The Atlassian Analytics support team will be available for live technical working sessions on October 18/19! If you are looking for time with our team to walk through how to get started or tips and b...

• Article
• analytics

For Atlassian Analytics customers using Opsgenie data from Atlassian Data Lake, we want to let you know that we'll implement a change that will affect your queries and dashboards. What's changing ...

• Article
• analytics

If I have two table charts with the same number of columns, they don't line up correctly. I see no setting for the column width.

• Question
• analytics

...uggest following the public feature suggestion ticket for updates. Q: What language do we use to write Custom Formulas in Visual SQL? A: Custom formulas in the “Formula column” and “Apply f...

• Article
• analytics

Hi Team,  I'm an Atlassian consultant and I'm eager to learn and try Atlassian Analytics. Is there a way to access to a trial version?  I'm really desperate to give it a try. Thanks...

• Question
• analytics

Hi all,  how can I easily show the number of issues based on 2 different measures in the same column issue field value? Let me explain Custom Field Name: Site Custom Field Name: Cause I wan...

• Question
• analytics

Hello everyone, Several weeks ago, we announced that we'd make efficiency changes to four major Jira tables in the Atlassian Data Lake schema: jira_issue jira_issue_cycle_time ...

• Article
• analytics
• data-lake

Hello everyone.  I am looking to create a dashboard where I can identify any Confluence spaces where no one has viewed pages within the past 6 months.  I am essentially looking to duplic...

• Question
• analytics

Hi guys,   Are the comments in the tickets held in any table? I would like to create a view with a  backlog containing a column with the last comment on a task. I've looked at the field t...

• Question
• analytics

In one week, we’ll begin to automatically migrate any remaining old table charts to new ones. Our new changes will make table charts easier to use and customize. Due to technical limitations and...

• Article
• analytics

Hi I am trying to create a dashboard that shows all our projects epic cycle time and have been pointed in the direction of Eazy Bi, but it's not that Easy for me. Then I saw the Flow metrics chart t...

• Question
• analytics

What kind of SQL is expected? That's a very interesting parse of very simple SQL query.    

• Question
• analytics

Hi - I have a simple table, counting the occurrences of Tickets by Issuetype across my projects - I noticed that it is counting tickets that are in Projects that have been deleted but still reside in...

• Question
• analytics

Hello,   I have two columns generated in the dataset via SQL query that are aggregated and are of datatype integer. I want to create a another two column in the dataset that is a summation an...

• Question
• analytics

You can now connect a Google Sheets spreadsheet to Atlassian Analytics! This new integration makes it easier to pull in supplemental data that you might need for your dashboards. Any row-level change...

• Article
• analytics

I have been really loving the new Google Sheets data connection, it makes accessing third parties so much easier, faster and in most cases free. I was thinking about ways to automate the syncing of ...

• Question
• analytics

Hi everyone, we’re back with a new set of product updates to share! Read on to see what’s new and coming soon with Atlassian Analytics and Atlassian Data Lake. ✨ Recently shipped New table charts...

• Article
• analytics

What’s happening Our team is in the process of adding data from the “Parent link” custom field used in Advanced Roadmaps for Jira into the “Parent” field that you can access in the Atlassian Data L...

• Article
• analytics

Hello Community, First, we want to acknowledge that your data in the Atlassian Data Lake is of utmost importance and that data integrity is crucial in driving your business needs using Atlassian An...

• Article
• analytics

...s needed   The data doesnt match and i am not seeing the correct sprint names like 'WebExt - Sprint 45 ' is missing since the story points are Null which is not true as per the o...

• Question
• analytics