Tracy Chow_f2gtzj Atlassian Team

Hi Guy, The "Visible" checkbox on the data source Schema tab determines whether the table is listed in the full schema view. If a table has the checkbox unchecked, the table will only appear when "Show full schema" is toggled on in the visual mode schema browser. The toggle on the bottom is what I was referring to: If you…

Hi Giga, Can you try this instead? case when {PROJECT} = '' then 0 else 1 end This worked for me with a single select dropdown.

Thanks for the reply. I've opened the feature request ticket: https://jira.atlassian.com/browse/ANALYTICS-284. I don't have an estimated timeline for when this will be worked on, so I recommend keeping an eye on the ticket for updates.

Hi Andrew, To make sure I understand correctly, is this regarding connecting Databricks to Atlassian Analytics as a third-party data source? https://support.atlassian.com/analytics/docs/connect-to-databricks/ If that's right, I can submit a feature request on your behalf to have this added. Best, Tracy

Hi Guy, There's a table in the Atlassian Data Lake schema called `asset_object_issue_mapping` which contains data that maps an Asset object to a Jira issue. https://support.atlassian.com/analytics/docs/schema-for-asset-and-configuration-management/#Assets-object-issue-mapping If you don't see it in your schema browser, you…

Hi Cristina, Can you share more about what you mean by the charts disappearing after some time? Generally speaking, there are things you can do to ensure the charts are performant (such as minimizing the number of joins, adding a query limit, not adding too many charts/queries on a dashboard), and also settings in…

@Kevin Paugam The "labels" column is not currently available in the `jira_issue_enhanced_table` table, but you can query the data from the `jira_issue_field` table. More details can be found on this suggestion ticket: https://jira.atlassian.com/browse/ANALYTICS-254. 

Hello, Yes, you can use the Atlassian Analytics relative date variables to generate a dynamic date filter. For example, "Created at" < {TODAY.SUB.(1,'month')} will return all dates older than May 12th. Let me know if you have further questions on this or how to use relative date variables.

Hi @CESAR DALDOSSO, can you open a support ticket and select Atlassian Analytics? We may be better able to help you with a ticket where we can request access to your instance and get more details on your query and chart configuration.

Hello, Data shares are already enabled for all Atlassian Analytics customers, but only organization admins have the ability to see and create data shares from Atlassian Analytics. Do you know if you are an organization admin? If you are still unable to see the feature, can you open a support ticket with us? We can…

Hi Scott, Atlassian Data Lake doesn't currently contain data from 3rd party add-ons or Marketplace Apps, but if you have data from those add-ons in a 3rd party database like Snowflake or Redshift, you can connect the database to Atlassian Analytics to build charts with the data. The list of supported 3rd party data sources…

Hi Grigory, Confluence database data is not in Atlassian Data Lake yet, but the work to make this available is in progress. You can follow this ticket for updates: https://jira.atlassian.com/browse/ANALYTICS-137. Thanks, Tracy 

Hi Angelica, Due to how the model generates chart insights, we cannot provide the exact standards referenced. You can follow this ticket for updates on when this change is rolled out: https://jira.atlassian.com/browse/ANALYTICS-229. I don't have an estimated date right now, but I will ask the engineering team to update the…

Hi Angelica, Thanks for calling this out. Our model uses a variety of information to generate chart insights, so unfortunately we can't pinpoint the exact standard being referenced here. We'll be making adjustments to avoid ambiguous language like this in the future. Regards, Tracy

Hi @Mathew Lederman, due to the level of investment and cost involved in data modeling and infrastructure, Atlassian Analytics and Atlassian Data Lake will only be available for Cloud Enterprise customers. Thank you for your interest.

Hi Bruno, The new Tableau Delta Sharing connector was just released last week: https://www.tableau.com/blog/tableau-databricks-delta-sharing-connector. Their documentation has instructions on how to get started with it. You'll be using the endpoint URL and bearer token from the credential file provided by data shares. Can…

Hi Tess, The fields you listed will show up under the "Epic Benefits Field Name" column in the "Epic Benefits" table of the Jira Align Enterprise Insights database. Their values are stored in the "Epic Benefits Field Value" column. Sam's comment in https://jira.atlassian.com/browse/JIRAALIGN-5141 contains more detail on…

Hi @John Schram, adding the Team field data to the Jira Issue table is in the works. You can follow this ticket to get progress updates: https://jira.atlassian.com/browse/ANALYTICS-205

@Jack Ukleja The recording isn't being shared publicly, but you can take a look at the office hour recap post at https://community.atlassian.com/t5/Atlassian-Analytics-articles/Atlassian-Analytics-March-Office-Hours-Recap/ba-p/2639416 

Hi Andrew, You can check out the workaround described in this ticket https://jira.atlassian.com/browse/ANALYTICS-22, which entails querying the Jira Issue History table. Worklog data is also in the process of being added to the Atlassian Data Lake.

Hi Chrystal, You can change the way your queries are doing the date filters. It sounds like the query is currently filtering on "last 2 years" which is a rolling 2 years based on the current timestamp. This produces the following SQL: WHERE `Issue`.`created_at` BETWEEN (CURRENT_TIMESTAMP - INTERVAL 2 YEAR) AND…

Hi Cesar, Team data is expected to be added to the Atlassian Data Lake very soon in March! You can follow this ticket for updates: https://jira.atlassian.com/browse/ANALYTICS-27, and we'll also announce it here in Community when it's released to everyone. 

Hi Mikael, This article walks through an example of setting up drilldown between two charts: https://support.atlassian.com/analytics/docs/use-charts-as-variable-controls/ Additionally, if you use the "Jira Software - Overview" dashboard template, there is drilldown set up between the "Top 5 projects by issue count" and the…

Hi Björn, This video could be a good starting point on how to create a basic chart in Atlassian Analytics: https://www.youtube.com/watch?v=sWdmrUfqoQw&list=PLaD4FvsFdarRVuaVKCAg2hZqCe-rtxMe2&index=7&pp=iAQB Feel free to browse the other videos in the playlist, as well as our documentation on heat map charts.

Hi @Batrak Daria, there are a few dashboard templates in Atlassian Analytics that are geared towards support agents: * Service Desk scorecard - Service Desk Operations * Service Desk scorecard - Requests needing attention * Service Desk scorecard - Customer Experience Details on these may be found in our documentation.…

If you have a specific asset type set up for your user objects, you can add a query filter to filter for the desired object type, such as "Assets Type"."Name" = 'User'. Does this approach work for your current setup? 

Hi Jeff, Is your Jira issue linked to the reporter's object in Assets through a Jira custom field? If so, you can use the "Assets object issue mapping" table. Let me know if that works for you or if you have further questions. Cheers, Tracy

Hi Wong, To add a filter for a component associated with your Jira issues, you can select the Name column from the Jira "Project component" table and then set it to equal the name of the component. You'll also want to make sure the join path is going through the "Issue component mapping" table. Let me know if this works…

Hi Frank, Jira custom fields will be in the Jira "Issue field" table. You can follow the steps here on how to query Jira custom fields. Only one custom field can be added per query, given how the Jira "Issue field" table is structured, so creating a custom column for your custom field in your Data Lake schema may be a more…

Hi Jake, Thanks for the clarification. Yes, if you're querying multiple custom fields for a Jira issue, or multiple attribute values for an asset object, you will need to query them as separate queries with left joins in order to get the custom fields or attributes to be displayed in the table as unique columns. As to why…