Subset for Average resolution days


I would like to create a report with Resolution days, Resolution workdays and Median resolution days as follows
Screenshot 2021-05-13 at 17.44.31
however, these created issues also issues with a specific label as Legacy.

I would like to exclude these issues with the calculation of the days. This means if I will list these as clicking on +
There will not be calculated data

I am using all predefined formulas, but I believe I need to do a user-defined one.

Can you please help me?

Kind Regards

Hi @Jaromir_Mindl ,

To get the number of days, it took to resolve issues without the label “Legacy”, defining a new calculated measure is the best option. See the suggested formula below:

([Measures].[Average resolution days],[Label].DefaultMember)
([Measures].[Average resolution days],[Label].[Legacy])

Please see the eazyBI documentation page for more information on defining calculated measures -​

Roberts //