Count Issues In Progress

Questions & Answers
1

I’m fairly new to eazyBI and I’d like to calculate how many Issues (combined) are in progress for each Epic.

Ideally I’d like to count all Issues that are NOT “Open” and also not “Closed” (= those would all be considered “In Progress”).

I would also consider in the future adding “Blocked” to that list of status to exclude from the Count.

Which formula can I use for that?

Thanks!

2

Hi @bvdshec,
Welcome to the eazyBI community! :slight_smile:

You can use the Status dimension where you need to create a calculated member that will aggregate all statuses except open, blocked and closed.

Aggregate( 
	Except(  
    [Status].[Status].Members,
	{ 
		[Status].[Open],
   		[Status].[Blocked],
   		[Status].[Closed]
	}) 
)

Then you need to select Issues in Rows and choose Epic hierarchy.
The end result would look like this:

Epic
Epic2568×1114 349 KB

best,
Gerda // support@eazyBI.com