Hi everyone, First, thanks to everyone who attended our most recent office hours session. It’s always great to hear your feedback, and we try to answer as many questions as we can. In case you miss...
Hello all, I am not a BI developer so I am looking to understand why I would use Analytics for Jira Work Management instead of a traditional Jira dashboard. Also, I am looking to know what you typi...
Thanks to everyone who attended our office hours sessions last week! We appreciate being able to engage with you all directly and hope you walked away with helpful takeaways on how to use Atlassian A...
Is there a way to translate the jira_issue.reporter_account_id to the object key of the reporter in asset_object table? I am trying to create a list of tickets reported by location and I need ...
We’ve got two exciting updates to share about Atlassian account data in the Atlassian Data Lake: Rolling out data for unmanaged accounts We're happy to share that we’ve started rolling o...
Hi, Hoping someone can help me figure this out please, I'm trying to do a report that I can use to give me a graph representation of how many times a user may have been assigned to different ticket...
Atlassian Analytics office hours are back! Our technical support team will be available for live technical working sessions on January 31/February 1. If you haven't attended one of our office hour ...
Trying to count issue resolved and created for a particular component but unable to build filter for component, any suggestion?
Using the Issue Details template, I need to add a column displaying some custom incident fields. (field id's known) TBH I'm in the middle to 2 go lives and up against it, I bet this way is fast...
Hi everyone, As the year comes to a close, we wanted to share our last set of updates for the year. Keep on reading to see our latest releases and what’s to come in 2024! Apply to join our data s...
Hello Atlassian Analytics Community! We're excited to announce the new set of DevOps effectiveness scorecards, which provide deeper insights from the recently launched DevOps data tables. These s...
Hello everyone, A couple of weeks ago, we announced that we'd make efficiency changes to the "Issue field" table in the Atlassian Data Lake schema. These changes are now live, so you should se...
Hi, We are using many custom field as per our client need in Jira software project. However we are not able to use that in Atlassian analytics in chart column. For example we are using Request Type,...
Hi Team, We have an ask to fulfill using Analytics that pertains to creating charts that displays trends. The end user would like to see how the TTR(time to resolution) metric is trending month over...
Hello Atlassian Analytics Community! 👋 We're thrilled to announce the launch of our latest suite of Opsgenie dashboard templates and tables, designed to empower your teams with more insights and a...
I have gone through every setting for the chart and can not get it to give me the legend in non percentage numbers. Even though I'm handing it number of tickets per user.
DevOps data from your developer tools connected to Jira Software is now available in the Atlassian Data Lake! If you’ve connected your source code management, deployment, and release management too...
What’s coming A couple of months ago, we made efficiency changes to four Jira tables. Since then, we’ve observed significant improvement in query performance on Atlassian Analytics. To have a...
I have a Contact asset type that has an inbound reference (Member) to a Team asset type. Are references between asset types accessible in Analytics?
Hi, The JQL below allows searching for incidents toggled to be an MI - issuetype = "[System] Incident" and "Major incident" = MAJOR_INCIDENT I'm trying to re-create this in Analytics to buil...
Hello Team, I build a report based out of Assets metadata in the schema. Since the columns are pivoted meaning they are attribute values for a column "Name" i am unable to develop an aggregate formu...
Hello Analytics friends! 👋 I am Allanah, a Product Manager at Atlassian. I'm interested in talking to Atlassian Analytics customers about the “natural language to SQL” feature (currently in beta) ...
Hi community, I'm currently trying to build a table that would mimic "issue in portfolioChildIssuesOf()" inside Atlassian Analytics. While there is a way to query parent and child i...
Hi everyone, Thanks for joining the product roadmap session last week! We hope you gathered new insights and use cases for Atlassian Analytics as our product management team demoed recently release...
Not sure if this would be considered a bug, thought I'd post it as a question first. I noticed the below when trying to count the number of issues created after a set date, and am wondering if I'm mi...