We have 10+ groups and basically as many forms. Each of those teams and forms has some kind of basically unique task category field. Although we have all that category data, in multi-team reporting, we generally can only report at the form level.
It would be useful to be able to see the respective task category on the same report. Something like this:
| Group | Form | Task Category | # Tix |
| A | 1 | A:F | 81 |
| B | 2 | B:D | 62 |
| C | 3 | C:B | 43 |
| A | 1 | A:E | 12 |
How can this be accomplished?
I think I may have understated what I meant by each team has a unique task category field. Based on your suggestion, the report would look more like this:
Metric:
Rows:
For illustration, if we have an admin tasks, sales tasks, orders tasks, and vendor tasks for the admin, sales, orders, and vendors groups,
Right now we pull separate reports for each team, their form, and break out on the task ID; then join the different reports.
Is there a way of using explosions to accomplish this? When I try it keeps cancelling the operation when I add more than one task category.
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Ahmed's right, you can add the attributes that you need as slicers under Rows with the visualization type for the report set to Table. By default, the report will display the metric values at the rightmost column; if you need the report to only show the ticket information similar to your sample table, you may hide this column via Chart Configuration → Column as shown here.