List Report - Average the data

toneyvecchio1 · ‎12-03-2014

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?

Brad Tilton · ‎12-03-2014

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

View solution in original post

tlgriffin447 · ‎03-10-2015

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

Brad Tilton · ‎03-10-2015

Hi Tyler,

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

tlgriffin447 · ‎03-11-2015

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!