Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Sam Wong (SamW0799)
Cathay Pacific Airways Ltd
Sam Wong
Cathay Pacific Airways Ltd
HK
SamW0799 Member since 2020 6 posts
Cathay Pacific Airways Ltd
Posted: Nov 10, 2021
Last activity: Nov 12, 2021
Posted: 10 Nov 2021 3:30 EST
Last activity: 12 Nov 2021 9:25 EST
Closed
Solved

How to group by multiple columns in a report definition

We are using 8.6.1. In report definition, we can only drop one aggregate column and one group by column in chart. Could we group by multiple columns? Thank you.

To see attachments, please log in.
Pega Platform 8.6.1
Reporting
Senior System Architect

Accepted Solution

Posted: 3 years ago
Updated: 3 years ago
Posted: 10 Nov 2021 12:38 EST
Updated: 12 Nov 2021 9:25 EST
Wolfgang Radl (mrwolf2)
Erste Digital
Wolfgang Radl
Erste Digital
AT

@SamW0799 - you can use stacked charts to visualize more than one dimension. Here is an example. My report groups displays cases per facility (bars) and status (stacks). There is one aggregate column in the report definition (a count of pyID) and the two columns Facility and pyStatusWork.

If you need more dimensions, I suggest using drilldowns (on the report viewer tab of your Report Definition).

 

Stacked bar chart

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice