Atlassian 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

Hi guys,I wanna know the meaningful of these options,and what is the diffence between workspace cache duration and check cache every?And I wanna know that when we change data what is the time for the...

• analytics

    Hi   How to open a Drilldown chart in a new tab /window instead of redirecting in the same tab, we are losing the original chart and it is time consuming to reload / go back to...

• analytics

Hello, I started to use Jira Analytics and configuring my dashboard with different types of charts. The values of the charts are taking too much to show up. Those appear after 10 minutes when i acc...

• analytics

Im making a line and bar chart, but i am seeing that bar chart uses the scale on the left and the line has its own scale on the right, which is confusing. Id like to have them both use the same scale...

• analytics

Hi    we have same fix version in multiple projects, how to get a burn down chart of the progress using Atlassian analytics, there is a custom chart for sprint burndown but nothing for Re...

• analytics

In a chart, I want to use conditional formatting to color the background if the date is before e.g. today's date. I that possible? I've tried different versions of {TODAY}, but it doesn't work. Ha...

• analytics

I'm looking to do a dashboard to show certain data based on a date field that is older than one month from today. Is there a formula that can calculate if a date is older than one month from today? ...

• analytics

Hi, I recently saw the post about data shares being available. I checked and do not see the option to share for our data lake. Is there something we need to do to make it appear as a choice?

• analytics

Can the Atlassian Data Lake support data from third party add ons (e.g. Structure, UpRaise, QMetry, etc.) for both JIRA and Confluence? If so, is there a listing anywhere of supported 3rd party appl...

• analytics

Currently Atlassian Atlas doesn't have public API available. Is Atlas data available via Data Lake/Atlassian Analytics?

• analytics
• atlas
• data-lake
• metadata

As I understood from Confluence Beta API, the data in databases are not accessible via API.   Is this data accessible via Data Lake?

• analytics
• data-lake
• database

I added a new custom column in one of our data source's schema to capture 'Start Date' from the Issue Field table. For some reason the new custom column is returning  duplicate Issue ID rows wit...

• analytics
• custom-column
• schema

I'm looking through the schema and in the jsw-sprint table I am seeing complete_at but am not seeing the corresponding start_at.  Where do we find the actual sprint start date?

• analytics

Hi Community, I know that we can set up a fixed value as the default value for a dropdown box. I am wondering if there is a way to set up the first value from the table as the default value. To pro...

• analytics

I would like to concatenate a string from a dashboard text controller (RM_ID in my example) and search for that string in the labels field. I do not know how to use the CONCAT operation within labels...

• analytics

I have created a dropdown control based off a custom field. This custom field can have multiple values when being set on our jira issues. This is causing the dropdown options to be every combination ...

• analytics