Report Builder 602/604 consolidating pick list choices into a summary.
Hello all,
If I have a field called Part, and the choices are:
Car - door (5 Work Items)
Car - seat (5 WIs)
Car - tire (5 WIs)
Truck - door (5 WIs)
Truck - tire (5 WIs)
Truck - seat (5 WIs)
and I want to create a report that shows:
High Medium Low Total
Car 3 4 8 15
Truck 2 8 5 15
Total 5 12 13 30
Can I do this in 602 (I'll settle for 604 as we may soon upgrade). I can do a dashboard widget with each, but combining and separating the values seems to take it to Report Builder.
thanks for any assistance
2 answers
Does this post give you an idea?
https://jazz.net/forum/questions/250584/how-to-change-the-output-value-in-a-select-statement-based-on-certain-criteria
Basically you map an existing value to a different one. For example, all values starting with "Car" will be mapped to "Car".
It looks like you're trying to build a crosstab, which isn't supported in Report Builder. Add your vote here: https://jazz.net/jazz/web/projects/Jazz%20Reporting%20Service#action=com.ibm.team.workitem.viewWorkItem&id=370803