I am posting a wrap-up of the suggestions from the conversation on our support channel:
To get the Deployment frequency first, try to calculate the number of unique releases each year. To do that, put the Time dimension on rows and select the “Year” level. After that, you can try to create a new calculated member in the Measures dimension with the formula below:
Descendants([Fix Version.By name].CurrentHierarchyMember,[Fix Version.By name].[Name]),
[Fix Version.By name].CurrentHierarchyMember.FirstChild.get('Release date'),
This will give you the number of unique releases each year, based on the Fix Version release dates. With the FirstChild method you, eliminate the duplicates by fetching the release date of the Version from the first project in the “Fix Version.By name” hierarchy.
I have to note that this will work as expected only when all the involved projects have the same version naming scheme and the same release dates.
To get the number of days each year, please create another calculated member in the Measures dimension:
--Days in Year
This formula checks if the date for the current day is within the current Time dimension period. If it is not, the number of days in that year are returned. If it is, the number of days passed in the current year is returned.
Finally, you can create a calculated member in the Measures dimension that gets the deployment rate:
[Measures].[Release count] > 0
[Measures].[Days in Year]
Please have a look at a picture of a sample report below:
Please have a look at our documentation page for more information on calculated members in the Measures dimension - https://docs.eazybi.com/eazybijira/analyze-and-visualize/calculated-measures-and-members/calculated-measures.
Roberts // eazyBI support