Create a monthly report region wise for total incidences

[Mukesh Kumar4]

Hi,

I have ITIL access to service now and my job is to create reports for all customers, vendors, or partners across the globe or world. I have been combatting with SNOW to create monthly reports to locate total incidences resolved or closed region wise.However my efforts have gone awry.

Would request you to please help me with this sort of report. I am very new to SNOW. Undoubtedly, SNOW is a great platform to experience this competitive world.

Thanking You.

Regards,

Mukesh Kumar

[Slawek_Radziewi]

You should start with adding gps data to all locations. 

Check below link last entry where you should see step by step how to set it.

https://community.servicenow.com/community?id=community_question&sys_id=f54d26eddbda3b40e0e80b55ca96...

[Thomas_Davis]

Do you have Region data built into your Location table? If you do, you should just be able to dot walk to the location table from the incident table in the report.  You could easily build a Resolved Monthly report that is Grouped by Region and Trend by Resolved/Closed (whichever you need).

Take a look at this screenshot that shows you what it could look like. This is based off the Caller, but you could do the same thing based off of Assigned To:

That would be your Group By and then your Trend By would be Resolved or Closed, whichever you choose:

Set per to Month

Then you will want to Filter your report to Resolved on Last Year (or whatever year or amount of years you want and run the report.  It should look similar to below:

Again, this will be determined if you have a Region in the Location Table.

I hope this helps,

Thomas