Filter and aggregate

Questions & Answers
1

I have a user-defined field to count of issues which are in status ready for development in Jira as below

([Measures].[Transitions to status issues count],
[Transition].[To Do => Ready for Development]
)
Say the result of above gives me 10issues
Among these 10 issues which are Ready for Development, I want to filter the items which are completed using aggregate function which has issue status as done,delivered,wont do

Aggregate({
[Status].[Done],
[Status].[Delivered],
[Status].[Won’t do]
})

How to ensure only the items from Ready for Development get aggregated

2

Hi @Prakriti_Pant

Welcome to the eazyBI Community and thanks for posting your question!
I suggest the following:

  1. If you haven’t already done so, define a new calculated member in the Status dimension (Calculated members in other dimensions) with the Aggregate function you have already pasted. For example purposes, the name of the calculated member is “Done Statuses”

  2. Then you can proceed with adding an additional line in your Tuple function as follows:

(
[Measures].[Transitions to status issues count],
[Transition].[To Do => Ready for Development ],
[Status].[Done Statuses]
)

Best wishes,
Elita from support@eazybi.com