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...
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.
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...
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...
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...
Hi, for a query I'm writing I need to collect information on the parent links for jira issues in my data lake. I'm not seeing these fields in the data lake when I'm trying to write my query; are ther...
Data source for the Jira Assets configuration doesn't include the name. It only references the long string value for asset id – I am needing to pull the "Name" without being forced to create u...
The data source that was added to connect to doesn't have the Assignee field there without having to do extra configurations on a separate Google Spreadsheet. What are the steps to get a colum...
I have a custom date attribute called "Last Reviewed Date" that records the last date that a particular asset object was reviewed. I would like to create a table in Analytic that list all objec...
Hi Community, I'm trying to display a list of dependencies based on a certain link type. However, issue link or link type doesn't seem to be available in Atlassian Analytics data lake. Am I ...
If I have two table charts with the same number of columns, they don't line up correctly. I see no setting for the column width.
Hi Team, I'm an Atlassian consultant and I'm eager to learn and try Atlassian Analytics. Is there a way to access to a trial version? I'm really desperate to give it a try. Thanks...
Hi all, how can I easily show the number of issues based on 2 different measures in the same column issue field value? Let me explain Custom Field Name: Site Custom Field Name: Cause I wan...
Hello everyone. I am looking to create a dashboard where I can identify any Confluence spaces where no one has viewed pages within the past 6 months. I am essentially looking to duplic...
Hi guys, Are the comments in the tickets held in any table? I would like to create a view with a backlog containing a column with the last comment on a task. I've looked at the field t...
Hi I am trying to create a dashboard that shows all our projects epic cycle time and have been pointed in the direction of Eazy Bi, but it's not that Easy for me. Then I saw the Flow metrics chart t...
What kind of SQL is expected? That's a very interesting parse of very simple SQL query.
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...
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...
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 ...
...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...
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...