Report with multiple 'group-by' categories

[mikemargolin]

Hello!

I need to create a report that will show us the number of requests processed by "assigned to" AND by request "type" (normal, emergency, etc) per week.   I need this report to display several weeks at once (rather than a single week).  

As far as I see, I can only group by a single category at one time, and can either see an aggregate count of requests processed by person by type for one week (stacked bar chart) OR I can see the total number of requests processed by person by week (trend chart trending by planned start date).   I haven't figured out a way to combine these into a single chart / report.

To summarize: is there a way I can display in a single chart or list that will capture several weeks' of data: how many and what kinds of requests each person processed?

We're currently on Helsinki.

Thanks!

[Ivano B]

Hi Mike

I would suggest to have a look to PA capabilities.

Unfortunately - from your description i think you already discovered it - this is not possible using simple reporting capabilities.

Cheers

R0b0

[mikemargolin]

Thanks for the quick response, R0b0!   Bummer:(

[pieter_goris]

Hi Mike,

maybe using a multilevel pivot table (Multilevel pivot tables ) gives you what you need.

Cheers, Pieter

[sowmya123]

May be try creating a PA breakdown dashboard by assigned to and a breakdown stacked column chart widget