Jira EazyBI: Find data based on Sprint name

[keith kennedy]

Hey,

I'm just tinkering with a trial version of EazyBI. I'm trying to get the cycle time for a sprint team. I have two teams that are on the same Jira project so their data is imported together. Let's call them teamA & teamB. They also have simultaneous sprints on the same board. I 'think' the only way to tell them apart is by using the sprint name as every sprint contains the name of the team. I have done a bit of searching and tried to create a new "calculated member" on Rows with the following script:

Aggregate(
  Filter(
    [Sprint].[Sprint].Members,
    [Sprint].Name MATCHES '^teamA.*'
  )
)

But that doesn't work, can anyone help me to create this? Any advice is much appreciated.

Thanks.

[Roberts Čāčus]

Hi @keith kennedy ,

You are almost there, please try to use the Sprint current member in the filter. The formula could look like this:

Aggregate(
  Filter(
    [Sprint].[Sprint].Members,
    [Sprint].CurrentMember.Name MATCHES '^teamA.*'
  )
)

In the Filter() functions first step you defined a set of members - Sprint dimension, Sprint level members. In the second step, you defined the condition, to look for specific members whose names match the criteria. You have to use the currentMember.Name to look into the names of each Sprint from the set. [Sprint].Name will return the name of the dimension = "Sprint".

Kind regards,

Roberts // eazyBI support

[keith kennedy]

Hi Robert,

Thanks for your help.

I tried added a new calculated member to the "Sprint" dimension. I am working with EazyBI's sample sprint velocity chart.

Unfortunately it had no affect. I do only get 1 sprint per time period, even though there were always two sprints in each time period, 1 for each team, so the row data is currently returned as follows:

TeamA Sprint 1

TeamA Sprint 2

TeamB sprint 3

TeamA sprint 4

TeamB Sprint 5

But adding the filter you described above has no affect on this list at all.  So I guess I'm branching into two problems now:

1. Half the sprints are missing

2. I cannot filter out the sprints I want based on name

Thanks again,

Keith

[Roberts Čāčus]

Hi @keith kennedy,

From your initial question I had the impression, you wanted to filter all the Sprints to display only the ones with "TeamA" in the name. That what the code should do. 

Regarding the "Sample sprint velocity chart" report - it is filtered by the measure "Sprint Story Points committed". This measure is only visible in the Sprint dimension "Sprint" level. The calculated member for the TeamA has an empty value for this measure, so it doesn't show up in this report.

To solve this, please switch the report to the "Table" view and remove the filter on the measure "Sprint Story Points committed". After that, expand the Sprint dimension into the "All hierarchy level members" and select the "Sprint" level - this is necessary for clearing the currently selected members. Finally, try to choose the calculated member for "TeamA" and expand it. You can add back the filter for the measure "Sprint Story Points committed" and switch back to the "Bar" chart view.

Kind regards,

Roberts // eazyBI support

[Nathalie Joyce Anne Asuncion]

Hello, I just have some questions, we have tried to filter by sprint within 6 months, but the first 3 months' data are not reflecting on the report. Can you please help us what might cause the issue.

[Roberts Čāčus]

Hi @Nathalie Joyce Anne Asuncion

How do you try achieve that - filter by sprint within 6 months? I would try to define a new calculated member in the Sprint dimension and use the DateBetween() function to filter Sprint start dates within 6 months ago and today. The formula of the Sprint dimension calculated member could look similar to the one below:

Aggregate(
  Order(
    Filter(
      [Sprint].[Sprint].Members,
      DateBetween(
        [Sprint].CurrentMember.Get('Start date'),
        '6 months ago',
        'today'
      )
    ),
    [Sprint].CurrentMember.Get('Start date'),
    BASC
  )
)

 See more details about defining calculated members in other dimensions here - https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-measures-and-members/calculated-members-in-other-dimensions.

Best,

Roberts // support@eazybi.com