Is there a way to display average/max/min value in one report

JanLow
Tera Contributor

I'm working on sc_req_item to get total request / average duration / max duration / min duration per item. 

Currently the aggregation can only select one at a time for a report, is there a way to display all these (total request / average duration / max duration / min duration) in one report?

1 ACCEPTED SOLUTION

Uncle Rob
Kilo Patron

From a standard list view you can modify the list calculations to add any aggregate you want to the base of the list.

RobertFedoruk_0-1677504986045.png

 

RobertFedoruk_1-1677505012434.png

 

View solution in original post

4 REPLIES 4

Uncle Rob
Kilo Patron

From a standard list view you can modify the list calculations to add any aggregate you want to the base of the list.

RobertFedoruk_0-1677504986045.png

 

RobertFedoruk_1-1677505012434.png

 

Tissa
Tera Contributor

I am in HRSD and I can't do this in my reporting. Does this depend on table?

gyedwab
Mega Guru

You can do this within charts using Explore Analytics -- I put together a quick video showing it here:

https://youtu.be/vpRDlTxc9s8

Just a quick walkthrough on adding multiple calculations to a single chart. For more information, check out or wiki: https://www.exploreanalytics.com/wiki/index.php/Explore_Analytics:_The_Wiki You can also watch this video for more on the subject: https://www.youtube.com/watch?v=LgG3EBSqlj8 Try it

Rob89
Tera Contributor

I'm a bit confused.  Is Explore Analytics part of the ServiceNow ecosystem?