2 Replies Latest reply on Aug 31, 2016 2:38 PM by csoto

    Can I get sum of grouped items in report?

    csoto Specialist

      I 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