Hi all, we need to create a new measure with a sprint substring . For example if we had 3 sprints:
Sprint 10: s p commited 10, s p completed 5,
Sprint 100: s p commited 6, s p completed 3,
Sprint 20: s p commited 5, s p completed 5
We need a new measure to group the sprint have number 1 with correspondig sp commited and sp completed and the same whith number 2.
The result we need is something like this
Sprint Key Sp commited Sp completed
Key 1 16 8
Key 2 5 5
Right now we had this measure but dosen’t work
name = “Sprint Key”
data_type = “string”
dimension = true
sprint = new String (issue.fields.customfield_10007);
issue.fields.customfield_SPRINT_KEY = "key 1";
issue.fields.customfield_SPRINT_KEY = "key 2";
Thanks for all
Sprint reports uses specific sprint scope measures that work on historical data (Sprint issues committed, Sprint issues completed, etc.).
You would like to define calculated members in Sprint dimension using some regex filter. Here is an example of Sprint calculated member ending with 1:
[Sprint].CurrentMember.Name MATCHES ".*1"
You can use any other RegEx expression to support your case.
Some measures might not work with calculated Sprint members, default committed measures, in particular. You would like to use a bit modified version of it, for example, this one:
( [Measures].[Transitions to],
[Transition Field].[Sprint status],
-- An issue was in a sprint at a sprint start time
[Issue Sprint Status Change].[Future => Active],
Here is an example report for multiple sprints in our demo account. The report example is designed for Active Sprints burndown. But the ideas used there might be applicable for other cases as well.
Daina / email@example.com
Thank you for your response Diana, we understand the solution and troubles of working with sprints and issues together. But your proposal does not fit our needs, because we need to create new columns to group using substrings of the sprint names . If we use a filter with ‘match’ clause, the result in column is the name of de sprint, not the filter applied.
We need something like this
Thank you for all
eazyBI does not support using one dimension in Rows and in Columns.
You can access issue JSON by modifying an issue URL. Please modify the URL of the issue replacing browse with rest/api/latest/issue. Check how the value for Sprint custom field (search by custom field ID) is stored.
The approach with calculated custom fields in Sprint dimension might be the closest solution you might consider. This allows you to use match by substring of sprint name. You can check more regular expression examples for machines sprints by substring.
You can use an option expand (click on plus sign in the report where calculated members are used) to expand calculated members and see sprints pulled in there. The report with expanded Sprint calculated members would look similar to yours.
Daina / firstname.lastname@example.org