Consolidated, sorted Report Builder column
v6.0.6.1
Is it possible to use Report Builder to move from the following:
Planned For, Summary
1.0.0, Summary example
1.0.0 Sprint 1, Summary example
1.0.0 Sprint 2, Summary example
1.0.1, Summary example
2.0.0, Summary example
2.0.0 Sprint 1, Summary example
to
Planned For, Summary
1.0.0, Summary example
1.0.0, Summary example
1.0.0, Summary example
1.0.1, Summary example
2.0.0, Summary example
2.0.0, Summary example
2 answers
A custom expression should do the trick. I'm using DB2 so my calculation is based on the DB2 substr option which you may or may not have based on your DB type, but I was able to use this calculation to get the first part of the value before a space, which seems to be what you're looking for
SUBSTR($Work Item:Planned For$, 1,LOCATE_IN_STRING($Work Item:Planned For$,' '))