Atlassian Analytics

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

• analytics
• jira-work-management

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

• analytics

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

• analytics

Trying to count issue resolved and created for a particular component but unable to build filter for component, any suggestion?

• analytics

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

• analytics

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

• analytics

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

• analytics

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. 

• analytics

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?

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

• analytics

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

• analytics

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

• analytics

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

• analytics

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

• analytics

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

• analytics

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

• analytics

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

• analytics

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

• analytics

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.

• analytics

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

• analytics

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

• analytics

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

• analytics

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

• analytics

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

• analytics

What kind of SQL is expected? That's a very interesting parse of very simple SQL query.    

• analytics