Can I get sum of grouped items in report?
csoto Aug 9, 2016 3:31 PMI want to send a few simple reports showing, for example, all tickets completed in the last 7 days. I created the query and get a report emailed, but the output in the email is not quite the same as the query output. Here's an example of what it sends:
IT Request | |||||||||
5759 | Update RTF EC Online Test for Fall 2016 | Castro, Lauren H | 8/4/2016 12:55:30 PM | Castro, Lauren H | Moody Technology Services | Closed | 8/8/2016 8:30:43 PM | Castro, Lauren H | |
5783 | wayfinding layout woes | Cox, David C | 8/8/2016 3:17:04 PM | Harrison, Annelle | Moody Technology Projects | Closed | 8/8/2016 4:22:02 PM | Harrison, Annelle | |
5744 | Ethernet patching at teacher's rack BMC 3.208 & 5.208 | Cox, David C | 8/3/2016 3:16:48 PM | Marsolan, Andre P | Moody Technology Systems | Closed | 8/4/2016 5:57:54 PM | Marsolan, Andre P |
You'll see that I'm grouping the results by Lifecycle (in the above example it's the "IT Request" lifecycle shown). In the query results, it shows the number of rows returned within that group in parentheses (e.g. "IT Request (42)"). Is there any way to get the report that is emailed to do the same? I just need the number of rows per group, no actual calculations. This is so group managers can have a quick and easy way to include these numbers in their reports (without having to count the rows or analyze the exported file).
Thanks,
Charles