Hi to everyone
I have created a calculated measure that includes all the sprints of a year, but I need to get all the number of sprints under this calculated member, when I try to get this number I get the issues created under the sprints, here is my formula:
Could you please help me with this?
Welcome to the community!
Yes, you may create a calculations where you filter sprints by their start date, and then sum up (or calculated the average or another value) different metrics over those sprints. As an example, the following calculations retrieves all completed Story points:
([Measures].[Sprint Story Points completed],
Those metrics should be created in Measures!
When you select TIme dimension Year level members in Rows or in Pages, sprint from the selected year would be retrieved.
You may want to check out a report from Demo account where values ar calculated based on sprints started in selected month: https://eazybi.com/accounts/1000/cubes/Issues/reports/185871-sprint-cycles-by-time
Ilze / firstname.lastname@example.org