If today is June 18th, I need a start date of Dec 1 of the prior year and an end date of May 31st of the current year. 

• analytics
• atlassian-analytics%2ccloud
• date
• relative

I'm using this iif("Days Since Now"< 28, 1, 2) , to bucket data into column 1 or 2. Column 1 represent the last 28 days. The indicator works great, but only if there are records returned for ...

• analytics

Our team uses the flagged field to call out points of problems.  I would like to track that information in an analytics dashboard.  1. list of work items that are flagged 2. how long the...

• analytics

I am building a board for an Atlassian "Team" which would provide information for their standups.  I would like to display the work items by their rank, but cannot seem to find that in the sche...

• analytics

We have a situation were we have a lot of projects and many boards for the projects.  When I have the Sprint dropdown, it is loaded with options not relevant to the Project / Team involved.&nbs...

• analytics

Hi  Can I query "Team Capacity" in Atlassian Analytics? Only seeing these fields: Trying to build aggregated quarterly (not sprint) capacity planning view, i.e. Epic Original Esti...

• analytics

I've used the Atlassian out of the box 'issues created vs resolved' template to develop a burn-up chart, but I've like to add an 'ideal line', the line you see on the charts that show that if, for ex...

• analytics

I have a dateset that I've query in weeks: and I'm trying to add an x-axis target line for this week but it's not recognizing the iso weeks relative date (today is 6/5/2025) From the docume...

• analytics

I am trying to create Sprint Velocity details using  "Atlassian Analytics Chart " . Am giving Team name and a date range as filter on dashboard . I have used Atlassian Analytics OOB Chart named...

• analytics

I have a query where I perform multiple transformations to. One of the columns in my results table is a date format 'yyyy-Www', i.e. '2025-W09'. As the last step in my chart building, I want to filte...

• analytics

I need to display the text from a multi-line text custom field.  I can run a typical 'list' table report in analytics to get this field to display based on the control field choice.  But as...

• analytics

Hi there, Rather new to Analytics so wondering if the community can give me a helping hand. I've created a pure SQL chart in Analytics and was wondering if it would be possible to create filters on ...

• analytics
• filters

I have an Analytics report which shows Major Production bugs by Quarter. Chart looked nice, but we got the number of bugs down to 0 the last couple of quarters and so those come back as empty rows fo...

• analytics
• atlassian-analytics%2ccloud
• cloud
• confluence
• confluence-cloud

I have a dashboard with multiple pie charts. I would like to have a single drilldown table that can be populated by clicking on one of the pie slices in any of the charts to see a list of issues. is ...

• analytics

How do I get a count of issues that are in a specific state at the end of each week? I can easily create a chart showing issues created and issues resolved per week.  If I want to show the numb...

• analytics

I have a query that returns count of issues by created week. I'd like to 0 fill to current week. The 0 fill as it exists only fills to the last week of the returned table. Is there a way to continue ...

• analytics

I can get a chart to calculate open issues by week, using created and resolved totals by week. But I would like to get a similar chart but instead of a count of open issues by week, I also want that ...

• analytics

I'm setting up a query in Analytics to measure Jira releases (project fix versions marked as 'Released') per team. In our organisation, multiple teams use the same project, so their releases are dis...

• analytics
• regex

Hello, similar to Dashboards Exports or creating Dashboards from own created Templates, is there an option to do this only for Custom Charts? E.g. I have created a Custom Chart in a Dashboard and w...

• analytics

I am able to create a story burnup with 2 series, total created and total resolved by week. I don't really care about sprints, but rather I want to see total for my project over a time range. My char...

• analytics

We have some dashboards but the loading speed when we make selections is terribly slow. Will take any recommendations on how to speed these up.

• analytics

Is there a field that stores this?

• analytics

I have a list of issue attributes displayed in a table based on user selected issue type (drop down filter). If the user selects issue type "story", I would like to hide the last three columns in the...

• analytics
• columns

    Red Robin is a popular restaurant chain known for its gourmet burgers, family-friendly atmosphere, and customizable menu options. As a business analyst working with customer experienc...

• analytics
• menu

I am building a table that  I am filtering off Project id = {PROJECT_ID} and when i do it adds the project table, and a Join for Account ID to go to Lead Account ID. But I want only the join whe...

• analytics