Report Builder 602/604 consolidating pick list choices into a summary.

Mahari Hill (486●1●122●223) | asked Mar 14 '18, 8:17 a.m.
edited Mar 14 '18, 9:04 a.m.

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

Most liked answers ↑|Newest answers|Oldest answers

permanent link

Donald Nong (14.5k●3●14) | answered Mar 15 '18, 3:40 a.m.

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".

permanent link

Jackie Albert (1.6k●1●48●46) | answered Mar 15 '18, 10:20 a.m.

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

It's all about the answers!

Related questions

Report Builder 602/604 consolidating pick list choices into a summary.

2 answers

Your answer