Aggregate Sprint Names

Questions & Answers
#1

Hi,

I have several Sprint on different projects and I want to show them together on my report.
Example:
Project1 has ‘Sprint 1 P1’, Project2 has ‘Sprint 1 P2’ and so on… I want to show all the issues on Sprint 1 no matter what project it is.
I was thinking on some like:
Aggregate({
CASE WHEN [Measures].[Issue Sprint] MATCHES ‘Sprint 1*’
THEN
‘Sprint One’
END
})
But I have the error 'No Function matches signature ‘{}’

Any clue?

#2

Hi @Daniel_Luevano,

You can create a calculated member in the Sprint dimension using aggregate function and regular expression.
Formula to use would be this:

Aggregate(
  Filter(
    [Sprint].[Sprint].Members,
    [Sprint].CurrentMember.Name MATCHES ".*Sprint 1.*"
  )
)

You can also check our documentation for examples of other regular expressions if you need to make a regular expression that checks if this word is only at the beginning of the Sprint.

1 Like