Danut M _StonikByte_ Atlassian Partner

Hi @jeep_rutter, The Jira reports and gadgets count as done those issues that have their status mapped to the last column of the agile board. To fix the problem you should go to your agile board configuration (at Columns section) and map all your done statuses ("QA Verified", "UAT Verified", "Done") to the last board…

Hi @Yves Defossez, I am not familiar with the "google sheets addon" that you mentioned. Perhaps the addon is right. Please look at the History tab of the issues to confirm that they have indeed gone through that workflow status. If you don't manage to figure this out and the addon produces incorrect results, my advice is…

Hi @Bobby Moyini, I'm afraid that this cannot be done in Atlassian Analytics. You should be able to display the count by using the Two Dimensional Filter Statistics gadget of Jira configured by Project and Labels fields, but it does not display percentages. if you don't manage to get it done, an alternative would be to…

Hi @Stephanie Baron Welcome to the Atlassian Community! You could also try the Filter results gadget of Jira configured with a filter that returns the epics that are missing one of those fields. Something like: issueType = Epic AND ("Investment Category" IS EMPTY OR "Due Date" IS EMPTY) ORDER BY PROJECT You can then…

Hi @MANASA B N, This highly depends on what info do you want to display. Jira has native dashboard gadgets that you could use. Some examples are Two Dimensional Filter Statistics gadget, Issue Statistics gadget, Filter Results gadget or Pie Chart gadget. If these are not enough, you can add more gadgets by installing a…

Hi @devsebastianvz, Welcome to the Atlassian Community! Unfortunately, filtering by sprint in team-managed projects does not work. It is a known limitation of Jira Cloud, see this bug: JRACLOUD-90898. Please up-vote this ticket with the hope that Atlassian will address it soon. Danut

Hi @John Moore, This is not possible by using Jira default gadgets or reports. You could search on Atlassian Marketplace for a plugin that offers a gadget or report that is capable to do this type of calculations. If you want to try a plugin, our Great Gadgets offers a Pivot Table & Pivot Chart gadget that can easily…

Hi @Jstenger, The pink line represents the average time the issues from your filter spent in certain status. To identify the status, look at the chart legend to see which status is associated to the pink line. In your case the pink like represents the "Work in Progress" status. The numbers represent days, in your example,…

Hi @Crystal Rouse, If you plan to try an add-on, have a look over our Great Gadgets app. It offers many useful dashboard gadgets for progress tracking. In addition, if you install the app in Jira Data Center, its gadgets can be imported and used as macros in Confluence! Specifically for your use-case, I recommend these…

Hi @rajeswari saravanan, A better alternative to the manual Excel-based reports would be to create a team dashboard in Jira will all the necessary gadgets in-place for effectively tracking their epics. The dashboards have the advantage of having the data centralized in one-place, data is in real-time, and they are easily…

Hi @Fijo Francis, Welcome to the Atlassian Community! You could use the Two Dimensional Filter Statistics gadget of Jira configured with a filter that returns the issues from your projects and assigned to you. Unfortunately, when configured to show statistics by Status this gadget will display duplicated statuses if your…

Hi @Rinjini Poddar, Welcome to the Atlassian Community! As mentioned already by other people, the Jira gadgets do not support statistics based on text fields. A solution in this case would be to search on Atlassian Marketplace for a plugin that provides gadgets with support for text fields. If you are willing to try a…

Hi @Loic, Since you already mentioned our Great Gadgets app, have you had a chance to try these gadgets? * Pivot Table & Pivot Chart gadget - pivot tables, heatmaps, charts just like the Excel pivot tables * Advanced Issue Filter Formula gadget - lets you apply from simple to complex math formulas based on issues from…

Hi @Vineet Pasari, Welcome to the Atlassian Community! Could you please be more specific about what metrics/info you need to include in that report? Our Great Gadgets plugin has an Issue Filter Formula gadget that can calculate a metric (count, sum, average, etc) and can display it in form of colored number or gauge chart…

Hi @L, The plugin in question is made by Atlassian Labs and is unsupported... If you want reliable charts, you could search on Atlassian Marketplace for a plugin that offers this type of chart and is supported by its vendor. In case you want to try a plugin, our Great Gadgets app offers many useful charts, including a…

Hi @julia, I'm afraid that this is not possible with the Jira report. A solution would be to search on Atlassian Marketplace for a plugin that is capable to display such report. If you decide to try a plugin, our Great Gadgets app can be a good solution. It offers a Team Velocity gadget that can calculate by Time Remaining…

Hi @有馬 聖貴, Welcome to the Atlassian Community! If you need burndown charts by sub-tasks, you will need a plugin from Atlassian Marketplace because Jira's native reports and gadgets does not support sub-tasks. If you want to use a plugin, have a look over our Great Gadgets app - it is also free with the Jira Free plan and…

Hi @Maciel Hogenn, That report seems limited to a certain length of the time interval. A possible alternative would be to use a plugin from Atlassian Marketplace, able to do stats/reports based on Satisfaction field. In case you want to try a plugin, then take a look over this article that shows some examples of stats that…

Hi @Anupriya Jaiswal, Welcome to the Atlassian Community! Take a look at this article from the product documentation on how to create a custom chart in Atlassian Analytics: https://support.atlassian.com/analytics/docs/create-a-chart/ I did not try the steps, but at chart type you should be able to choose "stacked area…

Hi @Yury Belezyak, Unfortunately it is not possible to make the difference between two date fields by using the gadgets. But you could have this calculated on a per issue basis and stored in a separated issue custom field via Jira Automation. Then, use this field in the gadgets for stats. I don't have too much experience…

Hi @Bar Azgad, Would it work to create a Jira dashboard or a Confluence page that lists those issues, and then share it on Slack? You could use the native Filter Results gadget / macro to list the issues from your filters in the desired format. Danut.

Hi @Vasu Dev, Welcome to the Atlassian Community! I'm afraid that Confluence cannot display the data in that format. Most likely, you will need a plugin. If you are willing to install a plugin, our Great Gadgets app (for Confluence) offers some macros that can display this info with just a few clicks. By using the Pivot…

Hi @Ender P., You could also use the Filter Counts gadget of Jira Service Management configured with the "Build custom count" option to display all the counts in a single gadget. The result will be like this: In case this gadget is not available, a similar view can be achieved by using the Advanced Issues Filter Formula…

Hi @Russell Haynes, This might be due to the fact that the Control Chart report does some extra filtering. For example, it might also look at the Resolution field. So if some of the issues from your filter are in Resolved status but they don't have a Resolution set, they might not be displayed in the report. So please…

Hi @Tim Fetner, Welcome to the Atlassian Community! In general the Jira's native gadgets work with a save filter as data input; so they do not support JQL directly. You will have to create and save a filter in Jira with your JQL, and then configure the gadget to use that saved filter, as mentioned by @Atlass Monster, But,…

Hi @Heidi Vanderholm, I assume that you don't drag in sprints the epics themselves; you just put the stories and tasks belonging to those epics. In this case, you could use the solution offered by @Bill Sheboy, which is based on the Two Dimensional Filter Statistics gadget of Jira. It will not display the number of epics,…

Hi @Yury Belezyak, I don't see a way to do this with Jira native reports or gadgets. But you will be able to generate such report and charts by using the gadgets offered our Great Gadgets app. For example, to see the number of issues in DEV test column at the end of each sprint, based on historical data, you could use the…

Hi @Jessica Pertiwi, Welcome to the Atlassian Community! Indeed, Jira's Team Velocity report only provides data for completed sprints, the ongoing one(s) not being included. For a velocity report that includes also the ongoing sprints you will need a plugin from Atlassian Marketplace. If you consider the idea of using a…

Hi @Michael Holian, You are right, the releases can only be added for individual projects, not cross-projects. But, nothing prevents you to create the same release in multiple projects. For example, add "Version 1" release in Project A and Project B. Once you do this, when filtering by FixVersion = "Version 1" in JQL…

Hi @임동규, Welcome to the community. I did not try this recently, but it should work, as per that article. Perhaps you are missing a setting or something. Make sure you don't have the FREE plan, because this is only possible with the non-FREE plans. Eventually you could open a ticket with Atlassian Support for assistance.…