How to find Max value of a field

Ed Shooshanian
Tera Expert

I have a variable on the Incident table which calculates all the time an incident spent "On-Hold".  If I just pull the average time on hold data data looks good as many simple incidents are never put on hold or only for a short time.  So I wanted to get the Monthly Max value to show there there are some real outliers.  I don't know how to create an indicator to return the Max of all entries for the month.  I prefer PA as I can break down by team. 

1 ACCEPTED SOLUTION

Ed Shooshanian
Tera Expert

I went with this option, not perfect as it's tricky for the untrained to know where to hover

EdShooshanian_0-1748894063222.png

But it does give what I was looking for...sort of

View solution in original post

4 REPLIES 4

VikMach
Mega Sage

Hi @ed, you can do this in Platform Analytics Workspace. Pull the source table and select the Visualization type as "Pivot Table", add the relevant fields to analyze data on.
Here is the direct URL for PA Workspace - https://YOURINSTANCENAME.service-now.com/now/platform-analytics-workspace/visualization-designer/new

Additionally you can also create a Pivot like report (see example below). Select type as "Multidimensional reports". This is just an example. I selected random fields available OOB to illustrate. (Don't judge me on that ;-p)

VikMach_0-1748535412600.png



Let me know if it helped.

Regards,
Vikas K



Thanks Vikas, but that's not exactly what I need, I'm looking for something like this:

EdShooshanian_0-1748540078604.png

 

Since Month is not a field on Incident table report doesn't allow or have such option to select as column label. The report type that allows this format of report is called "Spline".
I used that and could achieve this. Additionally you can explore this in reports itself. May be there are some hidden features and functions that can be used but this is what I could achieve.
Let me know if it works.

VikMach_0-1748587778789.png

 

Ed Shooshanian
Tera Expert

I went with this option, not perfect as it's tricky for the untrained to know where to hover

EdShooshanian_0-1748894063222.png

But it does give what I was looking for...sort of