nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Need to create a report with all projects.

Monica Collins

A previous admin created a graph that had all projects: their count by year, with the total number of issues and total projects created. I've been tasked with updating last year's chart and I'm trying to figure out how it was done. Does anyone have any ideas?

Capture of total projects.PNG

Accepted answers

Mirek

This looks like a simple Created vs. Resolved gadget, just not sure if this was embedded in a Confluence page where those numbers are written manually or automatically, but the chart is definitively it.

https://confluence.atlassian.com/jira064/adding-the-created-vs-resolved-gadget-720416880.html

You can create a dashboard and add this gadget. Before doing that would be nice to make a search that would give you all the issues that you would count. Saving it as a filter would be required

https://confluence.atlassian.com/jiracoreserver/saving-your-search-as-a-filter-939937724.html

Ankit Srivastava_3e9eks

Hi @Monica Collins

You may use the below JQL and save as filter:

createdDate >= startOfYear()

Then use this filter in Heat Map gadget and select Statistic Type: Project, please refer the below screenshot:

Heat Map Gadget.JPG

It will also reflect the total number of issues created in the current year and also the total number of projects under which these issues are created, but it never brings up the project count which has no issues.

For total number of project you may use Project Gadget on your dashboard.
Project Gadget.JPG
Project created in current year = (Total project as per this project gadget) - (Total old project as per you data)

It's easy to find, if your organization track the project creation via Jira ticket. You may check within your organization, might be they use any specific label or component for new Jira project creation. Then you can fetch the annual Project creation count via JQL.

label = xyz and createdDate >= startOfYear()
or
Component = xyz and createdDate >= startOfYear()

Hope this will help.

Regards,
Ankit Srivastava

All comments

Mirek

https://confluence.atlassian.com/jira064/adding-the-created-vs-resolved-gadget-720416880.html

You can create a dashboard and add this gadget. Before doing that would be nice to make a search that would give you all the issues that you would count. Saving it as a filter would be required

https://confluence.atlassian.com/jiracoreserver/saving-your-search-as-a-filter-939937724.html

Ankit Srivastava_3e9eks

Hope this will help.

Regards,
Ankit Srivastava

Monica Collins

My boss gave me the dashboard that the previous admin set up. It has Recently Created charts gadget on it. I was able to get the number of issues for a given year. What I need now is the total projects for a given year. She had Heat Map gadget on the dashboard. The filter she used, 'All Jira Issues' is as follows: project not in (DP1, ZZTU, ZEP, ZBSWD, ZPM, ZSTP, ZMT, ZWTRFLL). It has a Statistic Type of Project. It displays the following: There are 192 distinct 'Project' values in 277703 Issues. How do I get the gadget to show the number of projects for a given year?

Monica Collins

Please see the reply I put for Ankit Srivastava, it won't let me post it in both boxes. Thanks.

Ankit Srivastava_3e9eks

Hi @Monica Collins ,

If you are the Jira Admin then you may try to fetch total projects created in a year from the Audit log, You need to go for the Project created Event

https://support.atlassian.com/jira-cloud-administration/docs/audit-activities-in-jira-applications/#AuditinginJiraapplications-Viewtheauditlog

As far as I know, there is no such gadget that shows the number of projects for a given year.

Hope this will work

Regards,
Ankit Srivastava

Ankit Srivastava_3e9eks

Hi @Monica Collins ,

If you are the Jira Admin then you may try to fetch total projects created in a year from the Audit log, You need to go for the Project created Event

https://support.atlassian.com/jira-cloud-administration/docs/audit-activities-in-jira-applications/#AuditinginJiraapplications-Viewtheauditlog

Hope this will work

Regards,
Ankit Srivastava

Mirek

Hi @Monica Collins

Let me answer here your last questions based on what you wrote in reply ..

How do I get the gadget to show the number of projects for a given year?

I guess that Heat Map gadget was actually used to check how many projects where used (active) in specific year.. It gives you total number of project in all of issues that belongs to a filter..

So in order to know how many of them are for specific year you have to manipulate with dates in the filter. I suggest to create a filter that would check start/end of the year dates (e.g. created > startOfYear() and created < endOfYear() ) and it would count how many issues there are in how many projects.. but you need to know that this would not be precise - it would not give you exact number since there might be projects that do not contain issues.

At the end I think that screenshot that you gave is not quite from Jira right? Is it from Confluence where the values could be simply manually added to a table after research?

Monica Collins

I exported the audit log. It gave me the information that I needed. Thanks.

Monica Collins

The screenshot is from a Confluence page. It has a screenshot of a Jira dashboard gadget.

I exported the audit log and found the number of projects for a given year that way. Thanks.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira

jira-software

jira-software-server