How to display GlideAggregate or group reports to users so that they can be exported?

[bobswisshelm]

I want to be able to generate group totals and display them to users so that they can extract the aggregates as values.  

Example:

Group CMDB_CI by Class, reporting the COUNT of rows in each class.

If I do this with a Line report, SN displays the Group/Count before each set of rows for each class, but those totals cannot be exported.  

If I use a Bar Chart, the information generates quickly, but can only be exported as a picture, so the user can't extract the data.

I can create a custom table and use GlideAggregate to populate rows in that table, then display the custom table to the user.  That seems like a lot of work, will generally require a separate custom table for each type of report that I want to generate.

Is there an easier way to do this?

Thanks in advance!

[Anurag Tripathi]

Hi Robert,

I think you can achieve this by using List Calculations on the lists report.

[Anurag Tripathi]

Configure list calculations in List v3

[Shiva Thomas]

Hi Robert,

You can have the best of both world by creating a Bar chart (or pie chart) and with the "Display Data Table" option checked.

Under the image, you'll have a table with the aggregates numbers ready to by cut and paste.

Here is the result of a simple cut and paste from my demo instance. The layout is kept sweet and nice.

Class	Base Configuration Item Count	Percentage of Count
Software	1,767	63.58%
Computer	811	29.18%
Business Service	40	1.44%
Printer	28	1.01%
Server	19	0.68%
Windows Cluster Node	14	0.5%
Database	13	0.47%
Web Server	9	0.32%
Windows Server	8	0.29%
UNIX Server	7	0.25%
UPS	6	0.22%
Email Server	5	0.18%
Other	52	1.87%
Total	2,779	100%

[shivanipatel]

Robert,

We are glad you took advantage of the ServiceNow Community to learn more and to get your questions answered. The Customer Experience Team is working hard to ensure that the Community experience is most optimal for our customers.

If you feel that your question was answered, we would greatly appreciate if you could mark the appropriate thread as "Correct Answer". This allows other customers to learn from your thread and improves the ServiceNow Community experience.

If you are viewing this from the Community inbox you will not see the correct answer button.   If so, please review How to Mark Answers Correct From Inbox View.

Thanks,

Shivani Patel