Atlassian Analytics

Exciting news! We’ve released Jira sprint data and Jira Service Management request type data in data shares. Sprint data is available in the table jira_sprint . Read more about the “Jira sprin...

• Article
• analytics

  I have created a Jira analytics dashboard, but the URL of the dashboard has my name in it like below  https://xxxxxxxxx.atlassian.net/analytics/sandbox-firstname-lastname-untitled-1/ &...

• Question
• analytics

Hi, I'm wondering if it's possible in AA to create a SQL query that achieves the same thing for the JQL statement of Assignee WAS X DURING (Date1, Date2)

• Question
• analytics

Hi all. I'm creating a pretty basic table in Atlassian Analytics. The query is picking up the issue type with the key ID of CSDETECT-100. I've selected which columns I would like on the table - Issu...

• Question
• analytics
• labels
• supported

How do get a list of issues that make up a data point? i.e., in an Issues Created vs. Resolved chart, I want to be able to see exactly which issues make up one of the data points. Is there a way to...

• Question
• analytics

I want to set the filter for the date and for the Jira Projects to work correctly to 3 charts. Now it's working only for two of them, ins spite of that, I set the highlight connection between them an...

• Question
• analytics

Hi there, Is it possible to create a forward-looking report in Analytics that is similar to the Version report that is built into JIRA?  I'm coming from eazyBI where we could create forward loo...

• Question
• analytics

  Hi community 👋 We’ve added a new Issue custom fields table that will simplify how you query your Jira custom fields in Atlassian Analytics. With this new table, all of your custom field...

• Article
• analytics

Looking for help or suggestions on how to get story points Sumed up by status within a two week time box.

• Question
• analytics

Is there a way to query the link type (e.g., "causes") of linked issues? I am able to return linked issues using the method in this post: https://confluence.atlassian.com/analyticskb/query-...

• Question
• analytics

I have a control which contains one of the following 3 values: 1. Q Research 2. T Research 3. B Research I have a 2nd query which will use a value based on the above to search the Status from t...

• Question
• analytics

Hi all, Thank you to everyone who had time to join our office hour session last week. In case you missed it, here is a quick summary of a few questions asked during the session. We love getting to ...

• Article
• analytics

I want my Atlassian Analytics charts to filter by PI. Example: if there are 6 sprints in the 2024 PI #1, I would like to see my data grouped by that PI. I'm thinking I need to somehow add a new table...

• Question
• analytics

Hi Atlassian Community, We've added a way to export and import dashboards to enhance your dashboard management experience. With this new capability, you'll be able to easily transfer dashboards acr...

• Article
• analytics

1) Is it possible to pull charts from Atlassian Analytics into a Confluence page without having to do a cut and paste each time?  Similar to how you can have Dashboards in Confluence that are au...

• Question
• analytics

We're thrilled to announce a new feature now available in Atlassian Administration - IP allowlisting for Atlassian Analytics. This feature empowers admins to enhance the security of their Analytics d...

• Article
• analytics

  Provide an overview of the different types of datasets used in data analysis (structured, unstructur

• Question
• analytics

Hey everyone! We’re introducing a new Atlassian Intelligence (AI) feature that generates custom formulas based on your prompt. Custom formulas use SQLite syntax and allow you to perform basic calcu...

• Article
• analytics
• artificial-intelligence
• atlassian-intelligence
• custom-formula
• new-feature

We are hoping we can get a report of who has successfully completed the training as we are making it required. We just need a list of IDs that have completed each course, and we can use @Ford.c...

• Question
• analytics

Hi Everyone, I am new to Atlassian Analytics.  Trying to start with small reports but having issue right off the bat.  I am trying to extract the following for a given project/team: Issue ...

• Question
• analytics

I'm trying to run the following query and getting an error. I'm new to Analytics but experienced in SQL   SELECT TOP 1000 [Risk].[Date Created], DATEDIFF([Risk].[Date Created], {TODAY}, "Day"...

• Question
• analytics

Hi everyone, We are holding another round of Atlassian Analytics office hour sessions on September 24 (AMER/EMEA) / September 25 (APAC)! These are open-ended sessions that anyone can join to ask ...

• Article
• analytics

  Hi, community! Several weeks ago, we shared that we were working on two new tables. We’re happy to announce that they're now available! Issue group mapping is now available in Atlass...

• Article
• analytics

In Atlassian Analytics I'm trying to create a stacked bar graph which shows a set of values as a proportion of the total for the bar. I've actually managed to create this view by adjusting some of t...

• Question
• analytics

Background: We sync our Jira Cloud instance with Jira Align.  Sprint sync is the bane of my existence! Scenario: Multiple Jira Sprints are Mapped to single Jira Align Team Sprint. I am trying ...

• Question
• analytics
• connector
• database
• jira-align
• join
• +1 more tag...