[Music] i'm laurence tyndall here at glidefast consulting and in today's tutorial i'm going to show you how to create a map report in servicenow map reports are excellent to use on dashboards as they allow you to easily visualize and pin records geographically on a map view map reports are commonly used for displaying data such as incident by country assets by country security breaches by country and new employees by city and state the possibilities are truly endless with this type of reporting whatever your use case is there's most likely a way to visualize your data on a map report map reports also allow you to drill into the map visualization when you're wanting to go deeper into a locations hierarchy for example you may be looking at the united states and you see a large amount of incidents being created in the state of california with the drill down functionality you can drill into the state of california and see which cities the incidents are being created from this type of functionality is great as it allows you to go from a 10 000 foot view and then write into a detailed view now that we've covered what map reports are let's go into service now and create one in today's tutorial we're going to create a map report for purchase orders by location this will allow our procurement manager to see all purchase orders across the globe and display which countries they're being placed from the first thing you'll want to do is open up service now and in the application navigator type in map sources under the administration application click on the map sources module you'll now see a list of map source records map sources are basically records that are used when generating a map report which tell the map what record should be loaded and displayed to create a new map source click on the new button a blank map source form will now load in the first field name this is the name which describes this map source in this field i'm going to enter purchase orders by location in the next field table this is the table in which we'll be building our map source data from in this example i'm going to select the proc underscore po table for purchase order records now that we've selected the purchase order table we have to select a field in which its values will be used to display on the map report in this example i'm going to select the ship to location field because this is where the purchase order location records are referenced now click on the save button to save this map source now that the map source record has been saved you'll notice we have a related list on the form for map sources this related list displays all of the child locations that are contained in the map source level hierarchy instead of creating the map source levels manually i'm going to do this automatically by clicking on the generate map source levels link that's located underneath the related links header click on the ok button in the browser pop-up you'll now see this following information message this message confirms that the map source levels were automatically created for the data source we have three levels of location data available to use if we go back into the map source record and go down into each level that was created you can see that we have a three level hierarchy that goes from country to state and then to city this hierarchy is perfect for the report we're going to build now that we've set up the map source and generated the hierarchy let's go and build the report in the application navigator type in reports and click on the create new module located in the reports application in the first field report name we're going to enter purchase orders by location and in the source type field we're going to leave this as table since the records we're looking to report on are stored in a table and in the final field table i'm going to select the proc underscore po table as this is the table with our purchase order records in it now in this part of the report builder we want to scroll down and select the map chart type now on the configure screen we need to configure the map report in the first field aggregation we want to select the aggregation of the data for this report we would like a count of purchase orders by location so i'm going to keep the count option from the map this data field click on the drop down menu and you should see the purchase orders by location map source that we previously created in this tutorial and for the set map field i'm going to leave it as world but if you wanted to focus the map on a specific country or state you could do so by selecting that country or state now click on the next button on this screen you can see that the map report has now been generated and you can see all of the purchase orders around the globe you'll notice that you can drill into the map to look at purchase orders in their respective country state and city from here you can save the report share it with others and even add it to a new or existing dashboard and that is all for this tutorial on creating a map report in service now good luck and thanks for watching you