Hello,
I would like to create a report with Resolution days, Resolution workdays and Median resolution days as follows
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
Jaromir
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 -https://docs.eazybi.com/eazybijira/analyze-and-visualize/calculated-measures-and-members.
Best,
Roberts // support@eazybi.com