Running Reports - Grouping by Month & Using Variables

benb1
Kilo Contributor

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).

Example-Chart1.jpg

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.

SNOW-Report1.jpg

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

1 ACCEPTED SOLUTION

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();


Screen Shot 2015-05-15 at 3.20.51 PM.png


View solution in original post

6 REPLIES 6

benb1
Kilo Contributor

Works perfectly! Thank you so much. I'd been told it wasn't possible to use variables in reports by a ServiceNow admin.


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.