- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-15-2015 04:24 AM
Hi,
I'm new to the forum, so apologies if this isn't the correct place to post this question, it seemed closest.
We've just started using the report fucntion of ServiceNow, and I've been asked to create some reports, then convert them to gauges so they can be added to the Site Leadership Teams (SLT) dashboards, so each site we're supporting.
I'd like to create a bar chart, showing incident ticket volume per month for the last 6 months, for a single site, stacked by ticket priority (example below).
However when I create the report, using the below settings, I can't get it to display the ticket volumes per month. I'm sure it's something to do with the 'Group by' field, but I'm not sure which option to set, to get the report I need.
Type - Bar chart
Table - Incident
Group by -Created
Stacked - Priority
Aggregation - Count
Filter - Location - Site
Filter - Opened, Relative, After, 6, months, ago.
Additionally, I'd like to be able to create 1 report/gauge, for all sites, and the SLT's for each site use it, but have it so it automatically detects their site, and generates the report. Is this possible, maybe to use the location as a variable? Or do I have to create 1 report/gauge per site, and hardcode the location into the report?
Any help or advice on how to get the report I need would be greatly appreciated!
Thanks
Ben
Solved! Go to Solution.
- Labels:
-
Enterprise Release Management
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-15-2015 12:21 PM
Hi Ben,
Two issues -- one, I left out an important "gs.", and the other is, remove the "location = " from the filter, so it looks like this:
javascript:gs.getUser().getLocation();
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-16-2015 02:40 AM
Works perfectly! Thank you so much. I'd been told it wasn't possible to use variables in reports by a ServiceNow admin.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-16-2015 07:05 PM
Hi Ben,
When they said that you can't report against variables, they meant a specific ServiceNow type of variable, which are questions asked on the form of the Service Catalog -- not dynamic values captured in javascript... it's misleading terminology.