I am looking for a solution where certain status should be excluded while selecting the current week. Please take a look at the attached screenshot.
On selecting the current week from the week filter, the “Done” status should be excluded from the status filter. How do I approach the solution?
Hi @guru ,
Welcome to the eazyBI community!
Do you intend to keep the Status dimension in the pages and filter the report by it? If so, eazyBI can’t automatically adjust the filter in the pages. The best option is to define the set of statuses you want to display at any time. And then, define a new calculated measure where you subtract the number of Hours spent in issues currently “Done” when the current week is selected in the Time dimension page filter. See the suggested formula for the calculated measure below:
CASE WHEN [Time].CurrentHierarchyMember = [Time.Weekly].[Week].CurrentDateMember
THEN
([Measures].[Hours spent],[Status].CurrentHierarchy.DefaultMember)
-
([Measures].[Hours spent],[Status].[Done])
ELSE
[Measures].[Hours spent]
END
Instead of the Status dimension Default member, you can use the desired set of statuses, including “Done”. To define such a set, create a new calculated member in the Status dimension. The formula for it could look similar to the one below:
Aggregate({
[Status].[status1],
[Status].[status2],
[Status].[status3]
})
See more details on defining calculated measures and members on the eazyBI documentation page - Calculated measures and members - eazyBI for Jira.
Best,
Roberts // support@eazybi.com