question List Report - Average the data in ITOM forum

List Report - Average the data

toneyvecchio1 — Wed, 03 Dec 2014 16:10:58 GMT

My manager was attempting to create a list report and when he was using it, the list had a bottom piece where it averaged out the values. However we have not been able to reproduce this ever since. I having included a screenshot and have attempted to recreate but have been unsuccessful. Does anyone know how to add this "footer" or average piece?

Re: List Report - Average the data

Brad Tilton — Wed, 03 Dec 2014 16:26:48 GMT

You can actually set this in the list view (not specific to a report) of a table. Go to the list header, right click and choose Personalize > List Calculations and you'll have the option to do averaging, totaling, etc.

Totaling in Lists - ServiceNow Wiki

Re: List Report - Average the data

peterwestergaar — Wed, 03 Dec 2014 16:29:40 GMT

I think you mean that when you were designing the report, you can right-click on a column header of interest in the list result, and choose: "Personalize: List Calculations" and choose to display an Average for that column.

Is that what you were looking for?

Re: List Report - Average the data

peterwestergaar — Wed, 03 Dec 2014 16:30:29 GMT

Brad totally got it first.

Re: List Report - Average the data

toneyvecchio1 — Wed, 03 Dec 2014 16:38:46 GMT

Thank you so much!

Re: List Report - Average the data

tlgriffin447 — Tue, 10 Mar 2015 19:55:12 GMT

Hi Brad, I'm trying to do the same thing as Toney. But, I'm only presented with the options of Min/Max values. There are no options to select Total and Average, which I need to have. The wiki, for configuring list calculations, says that Total and Average aren't available for date, string, date/time. That's fine because I'm using a choice type with values of 1 - 5. Any ideas why I don't have the option for Average and Total? Thanks!

Tyler

Re: List Report - Average the data

Brad Tilton — Tue, 10 Mar 2015 22:01:04 GMT

Hi Tyler,

Is you choice field an integer field with choices like the state field or just a choice field?

Re: List Report - Average the data

tlgriffin447 — Wed, 11 Mar 2015 17:47:03 GMT

It was just a choice field. I switched to Integer, and it works now! I'm curious why it would matter though? The choice field still had a numerical value associated with it. Thanks again though!