Get number of projects from project category

Questions & Answers
1

Hi,

Is there any way to count all projects from Project Category?
Using this one, doesn’t help since gives not the full info:

NonZero(Count(
Filter(
Descendants([Project.Category].CurrentMember,[Project.Category].[Project]),
[Measures].[Issues created] >0
)
))

Thanks for all tips in advance!

2

Hi,

Welcome to the eazyBI community!

eazyBI can count only imported projects within the category; information about the total number of Jira projects is not imported.

Your calculation is correct, as it counts all projects that have at least one issue imported. This calculation can show fewer projects than imported if there are Page filters selected in the report (then only projects having at least one issue meeting the filter conditions would be counted).

If you need the count of imported projects regardless of the report context, remove the filter:

NonZero(Count(
 Descendants(
  [Project.Category].CurrentMember,[Project.Category].[Project])
 )
))

Best,
Ilze / support@eazybi.com