Jessie Turpin Atlassian Team

@kevin_lacinski Statuspage's feature requests aren't publicly available, which means we're unable to share a link to STATUS-96. If you'd like to check on the status of the ticket, please don't hesitate to create a support ticket with the Statuspage team.

Thanks for clarifying, @Lauren Marshall! In that case, I'd recommend using the {CURRENT_MONTH.START} and {CURRENT_MONTH.END} variables paired with the .SUB() function to grab the start and end date of the month that was 7 months ago.

Hi @Lauren Marshall ScriptRunner doesn't work within Atlassian Analytics. You'd likely want to use a relative date variable {TODAY} paired with the .SUB() function to subtract 7 months from today's date. 

hi @1234John4321! In the Multiple sprints overview and Single sprint overview dashboard templates, selecting a project from the Projects control will allow only the sprints available in that project to appear. Also, Jira Board data isn't currently available in the Atlassian Data Lake, but has been requested in this feature…

Hi @Michael Holian! If you're still stuck with creating the 'ideal line' I'd recommend creating a support ticket with our team, as we'd be able to access your Analytics instance and could provide more specific recommendations based on your data.

Hi @Jareth Rossking The feature request is still under consideration by the engineering team. 

Thank you for your feedback @Broussard, Anna! You're correct that we unfortunately don't have any chart templates specifically focused on story points that isn't a sprint metric. I'll pass this feedback along to our team though :) 

Hi @Broussard, Anna you'd probably want to use the Issue history table to capture when the story points were added to an issue. The screenshot below is an example of which columns you could include from the Issue history table to gather the day when the story points were added to an issue. Then, you'd only need to adjust…

Hey @Stephen_Wingert it's not currently possible to conditionally hide a column based on a different column's value. However, I've just created a new feature request for this functionality. Please feel free to watch, vote for, and add extra context on the ticket through comments. 

Hi @mudavid! If you can import the customer feedback data into one of our supported third-party data sources, you'll be able to connect that data source in Atlassian Analytics and begin creating charts with the feedback data. Additionally, within Atlassian Analytics you can create an Atlassian Data Lake connection, which…

Hey @nclx, thanks for the question! In the past when I tinkered with creating a chart calculating the number of open issues each month, here is a high-level overview of how I approached it: * Query 1 - I used a SQL query (below) to display all of the months in the time range I was interested in. I used a Calendar control,…

Hi Narsha! Based on the screenshot, it looks like your "Lessons Learnt" and "Notes" custom fields may be rich text fields that store their data in the ADF format. You would need to extract the "text" from the JSON data of each custom field, which you can do by modifying the SQL code example shared here. Just make sure to…

Of course! Here is the feature request that I created: https://jira.atlassian.com/browse/ANALYTICS-415. Please make sure to vote for, watch, and leave a comment about how helpful this chart type would be for your organization.

Hey @Stephen_Wingert it's not currently possible to adjust the PDF download within Atlassian Analytics to be in the landscape format. But I've just created a feature request for this ability. Feel free to vote for and watch the ticket, and add any additional comments about why this would be useful. Thanks! Jessie

Thank you! We'll be in touch on the ticket soon 

Hi @Broussard, Anna! Atlassian Analytics doesn't currently have the capability to create a combined area and line chart. Let me know if you're interested in using this chart type within Analytics and I can create a feature request on your behalf. 

Hi Travis! Thanks for reaching out with your question. Would you mind creating a support ticket to allow our support team to access your instance and take a look at the dashboard subscription? Thanks, Jessie

Hi William! We don't yet have an API available for Atlassian Analytics, but you can watch this feature request to stay informed of any future progress on the feature's development. 

Hi Mikel! Any chart or dashboard templates that reference displaying 'Operations' data can be used to query your standalone Opsgenie or JSM Ops data. Here is a link to learn more about the dashboard templates available for Operations data. The screenshot below also has some of the chart templates that are available for…

Hi Pamela! The Atlassian Data Lake stores dates using the UTC time zone, while dates within Jira can be set to use a specific time zone. It sounds like you might have a time zone set in Jira, so you would need to set the appropriate time zone within your dashboard's settings. This should help the date within your chart to…

Hey Bobby! You could apply a custom formula to the "Status" column to use the following Case statement to change the label of 'Reopened' to be 'Open': CASE WHEN "Status" = 'Reopened' THEN 'Open' ELSE "Status" END Once the 'Reopened' status is changed to 'Open' then you can Group & aggregate the data to sum the "No of…

You're welcome! If the assignee hasn't changed from when the user was first assigned, then the initial assignee would be the only assignee value in the Issue history table for that specific ticket. 

Hi Marie, thanks for the question! The Atlassian Data Lake currently doesn't have Jira Service Management Portal data available. We have a few feature requests below for various JSM Portal related data to be added to the Data Lake that may be of interest for you. * https://jira.atlassian.com/browse/ANALYTICS-113 *…

If you're looking to query the issues a user was previously assigned to during your timeframe, you can use the Issue history table instead of the Issue table. The Issue history table holds the history of the issues and will have data on whether the assignee of a ticket changes. You can also change the date filtering in the…

Hello! You could use a SQL query like the below code to achieve similar results as your JQL filter. You'd just need to replace the 'Account_ID' with the account ID of your desired assignee and change the dates to your desired date range. SELECT `Issue`.`assignee_account_id` AS `Assignee account ID` FROM `jira_issue` AS…

Hi Brant! Thanks for your question and sharing your SQL code. You could certainly use a CASE statement to modify your subtask issue's status, however I'd recommend adding the CASE statement into the SELECT statement instead of having it in the WHERE clause. Also, you'll need to follow the Spark SQL syntax formatting for…

Hi @Mohammad F Hameed! If your QA Assignee field is a custom field, you can follow the instructions in this article to query the field's data. Try it out and let me know if that helps you find your QA Assignee data! 

In addition to Inder's solution, we have a feature request open for the ability to have the values displayed in the tooltip be formatted as a percentage as well. I'd highly recommend that you watch and vote for the feature request! 

Hey @Penny H-D ! You might want to check that the initial value you set is spelled and capitalized exactly as the value actually appears in your chart. If that doesn't work, could you create a support ticket with our team and share more details about your chart? That would help us be able to investigate this further for…

Hey Heather! You would need to set a default value in any control on your dashboard. You can do this by editing the control and entering the desired values in the 'Default values' box. Note that if you have created a control with the control editor, you'll need to first check the 'Initial value(s)' box in the control's…