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

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

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

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

• analytics

I'm trying to build some fairly simple charts in Analytics, but I am really struggling to understand the correct way to get the data I want. I've limited our data source in Analytics to a particular...

• analytics

What we are looking to do is pull the worklog table out of a ticket and then list out total time spent = 1 hour worklog author a spent 10 min worklog author b spent 30 min worklog author c s...

• analytics

I'm getting a list of JIRA issues within a specific fix version using Atlassian Analytics, however it is also showing me an issue that was in that fix version 3 days ago. It no longer has any fix ver...

• analytics

Hi All! I'm new to the Atlassian Analytics. I created Dashboard using "Jira Software - Organization overview". I have 2 sites. How do I add a filter by site?

• analytics

Hi, I am trying to get a matrix table with all sprints in a given project that displays sprint name as the primary dimension and Story points added, removed, completed and not completed each as a me...

• analytics
• report
• sprint

Hello, I am trying to generate a report/chart of Story Points by Issue ID and Sprint Name. How to go about that. I referred this post but it doesn't plot by Issue Key and Sprint - https://community...

• analytics

I have a checkbox custom field -Intake Type that exists across 25 projects.  (Technically it is -Intake type [lower case] in some projects even though I've changed it in the Issue Type settings,...

• analytics

Hi Team... does anyone know if activating this product will increase our billing cost now or in the near future?

• analytics

Forge allows developers to add custom fields that result in simple values but Forge-based fields are not available within Atlassian Analytics. I'd like to see at least simple Forge-based fields becom...

• analytics

Hi team, I have a custom field that is not always populated on an issue. I would like to report on cases where the field does not exist for an issue. I have a query that works out and displays the ...

• analytics

Hi Team, I'm looking for away to make a Chart that represents time in hours for SLA - Time to first response. I can see the default templates has for Time for Resolution, but can you give some hint...

• analytics

Hello - brand new to Atlassian Analytics. I'm sure this has been asked before but I'm probably not searching for the right terms. I have a custom field ("-Escalation", I did not come up with that) t...

• analytics
• cloud
• jira-software
• jira-software-cloud

We are looking to move to Atlassian Analytics, and we want data from Jenkins and Octopus to be included for builds and commits. Our goal is an overarching view of the SDLC life cycle. Has anyone else...

• analytics

Hi guys, I was able to connect a third-party data source (azure sql db) to improve our analyses. However, I came across an obstacle. When I want to join data from the data lake with data from the th...

• analytics

Hi all, I feel like a newbie all over again trying to figure out Analytics, which is good since I am learning something new.  I am creating a issue detail chart with issues that are using a ...

• analytics

Hi and happy Friday! Is there a way to filter start date based on a calendar control and if so, how do you do that?

• analytics

Hi guys,   I want to connect a third party data source - MSSQL db - to Atlassian Analytics. However, when adding a new data source, I get an error message (screenshot below) about invalid log...

• analytics

Hi. I want to produce a report with custom dates in Atlassian Analytics. The default dates will be 10/1 of last year (e.g. 10/1/2022) and 9/30 of this year (e.g. 9/30/2023) since this is a compliance...

• analytics

Hi guys,   Can you advise on where to find a mapping of issue fields values?   I'm querying the jira issue field table to get a name of the sprint (a sprint is a custom field) however w...

• analytics

Can anyone help me with extracting a report with all the sub-tasks under a project, along with their corresponding Tasks numbers and group them by Task numbers?  I'm okay with JQL as well. 

• analytics
• jql

Hi,   I am new to Atlassian Analytics and hoping someone can help me with this query.   I want to be able to get a breakdown of how many users have been onboarded to Jira each month ove...

• analytics