This article may quote data or refer to features or workflows no longer applicable to the current version of eSpatial, which is updated every 6-8 weeks. Please refer to our help section for more up to date information
Make the most of eSpatial reporting features
What is an eSpatial report?
An interactive map that produces charts and graphs and has filtering capabilities – you can manipulate your uploaded data to find new insights. Here’s what a simple eSpatial report looks like, with the key areas labelled:
When you sign up for eSpatial you get Pro functionality that allows you to create four types of report:
- Heat Map
- Within Distance
- Nearest Neigbor
Whenever you upload data to eSpatial, creating a map is just a matter of clicking the button “Map My Data”. Making an eSpatial report is only slightly more complicated, in that you have more options to customize your data.
Creating a simple eSpatial report
Assuming you have uploaded your data, from the eSpatial homepage click the relevant button:
Now, you choose the type of report you want to create. In this case, we’ll choose Simple Report:
The next page allows you to Select the Report Dataset:
The Report Dataset you choose is the data that will be plotted in the map area of your report. In this case, I will choose “Data for my sample report”.This will bring you to the page to select the fields that you wish to include in your final report.
There are two field selections in the above image, which I have labelled.
The selection on the upper part of the page(Select Fields for Report Results) represents all the fields in your dataset. Use the horizontal scroll bar to navigate through to all fields in a dataset.
The second field selection (Preview – Fields selected for Report results) represents those fields that will be included in your final report – appearing in the data listing or in in a map point when clicked. To add a field from Select Fields, simply click in the grey bar area of the upper field selection (as indicated by arrow 1) You will now see this in the Preview selection. (If the field is shaded green – rather than pink – above, that means it is already included in the Preview fields).
To remove a field from Preview, move your cursor over the grey bar and an “X” will appear (as in arrow 2). Click this and the field will disappear.
When you are happy with the selection of fields to be included in your report, click Next.This brings you to the filtering page.
Now there are innumerable ways to filter data in eSpatial before creating a report. I am just going to provide you with an example where I have applied two filters.Let’s say I just want to create a Simple Report that filters out everything except Sales that were higher than 10 in Pennsylvania (PA).First, I will navigate to the Sales field, using the horizontal scroll slide (arrow 1) and then click the title bar (arrow 2).
In the operators and values field that now appear, the filter title is added and I will select “greater than” from the “select operator” drop-down menu (arrow 3).
I will enter the number 10 (representing sales) and click OK. (NB: since this is a numerical field, there should be no comma separators – so it should always be in the numerical form 100000, rather than 100,000).For my second filter, I will find the State field, click on it (arrow 1, below), then click on select operator and enter value, as I have done in the previous filter. However, in this case, I will enter a text value – PA.
If you hover over one of the filters, it will be highlighted in yellow and an “X” will appear, as indicated by arrow 2. Clicking this “X” will remove the filter completely.
So, now I have my filters in place:
If you’re happy with the filters you have in place, it’s time to click on to the next page, which let’s you customize graphs that will be added to your report.
There are a variety of charts that you can utilize in your report, (as shown above in “Define your chart”). We’ll cover just one example here: a bar chart that is going to show Sales by State.To create this chart, I simply click anywhere on the relevant field columns. If the field is shaded blue, it indicates the X value on the chart, if it is shaded orange it indicates the Y value on the chart – a thumbnail preview is conveniently created at the top of this page.You can use the switching box beside the X value field (indicated by the larger of the two red arrows) to reverse the positions – so the value in X becomes Y, and vice versa.Remember: You have to include at least one numeric value to create a chart – if you have fields that only have text data, then they cannot be converted into a chart.It’s worth experimenting to find which chart best expresses your data. Alternatively, you can completely avoid creating a chart, by just clicking the “X ” in the top right-hand corner of the thumbnail chart box (the Chart 1 box in our sample above).
When you’re happy with your chart selections, click Next. Now all you have to do is name your report and then – for your own convenience – add a description.
Now it’s just a case of clicking “Finish” to generate an interactive map report that contains the datasets, fields, filtering and charts that you wanted.