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?

[Ankit Srivastava · Accepted solution]

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:

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 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

[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?

[Ankit Srivastava]

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

[Mirek · Accepted solution]

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

[Monica Collins]

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

[Ankit Srivastava]

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

[Monica Collins]

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

[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]

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.