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

In Atlassian Analytics, I would like to be able to change the colour of the background of the headings of a table. I know you can go into Formatting and performing a conditional format of the d...

• Question
• analytics
• table

I manage most of the data in our business's main service desk. Due to the nature of our business, energy, there are a lot of different bits of information required to ascertain whether an issue is te...

• Question
• analytics

Hello, I have a board with the following collumns  TO DO | IN PROGRESS | TO TEST | IN TEST | COMPLETED Over this process, a worker gets assigned to the issue when it goes in progress, however ...

• Question
• analytics

Hello, I was calculating a trhoughput ratio, that basically i want to calculate on a weekly basis the total of tickets delivered by the number of developers of a squad. So if the number of tickets de...

• Question
• analytics
• atlassian-analytics
• cloud

Hi, My scenario is -  I've got a custom field, Change Strategy, I have another multi-select custom field for Business Area. I have a chart in Analytics at the moment which gives me a bar char...

• Question
• analytics

Hi Team   Please advise whether we can create a temporary or staging table to avoid parallel execution on same set of tables for multiple charts. Problem Statement: In my dashboard i have ...

• Question
• analytics

I have created a chart to show a count of specific components for all teams (that have  those components) in a specific date range by month.  It seems my query is giving all the issues for...

• Question
• analytics

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

• Article
• analytics

  I use the filter to take created issue using date range including project and  component. but isn't working.

• Question
• analytics

Hello, where can I get the Schemas for Atlassian Analytics so that I can write some reports?

• Question
• analytics
• atlassian-analytics
• schema

  Hi community, The “Group picker (single group)” and “Group picker (multiple groups)” fields from the Jira “Issue field” table now stores group IDs, instead of names. This change applies to...

• Article
• analytics

Hi,  I've recently been using AA linked with a google sheet as well as Jira Software. It's been working fine until this morning when I synced it. It's started telling me my columns no longer ex...

• Question
• analytics

  Hi, community! A new set of Confluence dashboard and chart templates are now available! These templates use data from our recently launched Confluence tables to help reveal information abo...

• Article
• analytics

I used the Atlassian AI to write a query, then copied that query code into a new chart. Then I tried to add a control but it won't connect to the chart and I don't know enough SQL to add a control in...

• Question
• analytics

I have an Analytics Dashboard, and I'm having trouble adding and working with the Jira [Reporter] field. I need to include [Reporter] Name in all my listings of Jira tickets and graphs and also use i...

• Question
• analytics
• reporter
• reporter-name

  Hi everyone, We're happy to announce that you can now find data on Jira issues associated with a team! This was a highly requested data point and will enable you to better report on your J...

• Article
• analytics

I am trying to create dashboards with saved filters in Atlassian Analytics. Currently every time I navigate out of the dashboard and back in, my filters reset.  I would like dashboards with sta...

• Question
• analytics
• atlassian-analytics
• cloud

Hello, I want to collect data from a specific period , which is the Q4 from last year and compare it with the data from this year. I will do this using status history but cannot find a way of doing&...

• Question
• analytics

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

• Article
• analytics