Atlassian Analytics

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

• analytics

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

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

• 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"...

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

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

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

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

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

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

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

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

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

• analytics

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

• analytics

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

• analytics
• atlassian-analytics
• schema

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

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

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

• analytics
• reporter
• reporter-name

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

• 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&...

• analytics

Can I create 2 sets of controls for 2 sets of charts in the same Dashboard (same Data Source).  For Example: Dashboard A using DataSource A    > Control 1a,  Control 1b , Con...

• analytics
• atlassian-analytics
• cloud

  I have one control (dropdown) called "PROJECT" where I choose jira project and then one chart where I list all issues of selected project. Fore some reasons, in custom column of the chart ta...

• analytics

I'm trying to create a widget that will provide me with one of the DORA measures: Time to Restore. The way I'm thinking to approach it is: - Find all the sev1 in my JSM project - Make sure it's ...

• analytics

I have one control (dropdown) called "PROJECT" where I choose jira project and then one chart where I list all issues of selected project. Fore some reasons, in custom column I want to insert 0s if ...

• analytics
• cloud

When connecting to databricks lakehouse to access datasets, seems to be only allowed to select hive catalogues - does Atlassian analytics support unity catalogues.. If not, is there any work sched...

• analytics