- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-29-2025 06:10 AM
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.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-02-2025 12:54 PM
I went with this option, not perfect as it's tricky for the untrained to know where to hover
But it does give what I was looking for...sort of
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-29-2025 09:19 AM
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)
Let me know if it helped.
Regards,
Vikas K
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-29-2025 10:35 AM
Thanks Vikas, but that's not exactly what I need, I'm looking for something like this:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-29-2025 11:50 PM - edited ‎05-29-2025 11:54 PM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-02-2025 12:54 PM
I went with this option, not perfect as it's tricky for the untrained to know where to hover
But it does give what I was looking for...sort of