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?
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.
Roberts // firstname.lastname@example.org