Data Sets

Data sets define the filters and fields used for searching and displaying your Salesforce data in Geopointe. They are the most important component to understanding how searches on the map work.

This document will cover the following topics:

Data Set Basics

After performing the Post-Install Steps, you should see default data sets on your Saved Layers tab. You'll recognize the defaults because they will include the Salesforce Object name followed by (All). You should see them as part of your list, below the folders section.

When you hover over a data set, you'll notice a gray highlight bar and three dots to the right. This is the Layer Options menu. If you click on the menu, you will have one or two options: Edit Data Set and Delete Data Set (Note: Geopointe end users cannot delete nor make permanent changes to an org-wide data set). To demonstrate the capabilities of a data set, click Edit Data SetThis will bring up the Data Set editing module.


Data Set Filters

The Filters tab is where your data set magic happens. This is how you parse and filter your data to support analytical and business needs.

Here are your filtering options:

Show Filter
 - Filter by record ownership by selecting All Records or just My Records (records owned by the current user) from the dropdown. (On Account Team is also an option if Account teams is enabled, and My Territory related filters are enabled for Salesforce Territory Management users.) Note: End users only see records they have access to. We honor the Salesforce accessibility settings.

Field Filters - Filter by fields on the object.

Add Logic - Once you have more than one filter, a new option to Add Logic appears. By default, values separated by commas inside a filter value operate as an OR. Individual filters operate as an AND against each other. If you wanted a data set to filter with an OR between filters, you would add filter logic once all desired filters are created.

Cross Object Filters - Cross-object filters allow you to filter based on records related to the map object. If the object shows up as a related list on your page layouts, it will be accessible here. In its most basic form, a cross-object filter can be a simple with/without (example: Accounts with Opportunities). However, you can take it a step farther, to Accounts with Open Opportunities worth greater than $10,000.

Filters are complex and can be applied in a large variety of ways.

Learn more about Data Set Filters

Data Set Fields

Fields included here will be returned with your search results, much like fields added to reports or list views. Name and address automatically display; here you would include any other field(s) useful to you on the map or in an export.

Click Add Field. A field picker wizard will pop up with a list of available fields; it'll look just like the filter field selector. Add the chosen field by clicking Select.

Once you've added the fields you need, rearrange them into your preferred order by dragging them with the list icon on the right. You can remove a field by clicking the next to it. You can choose where you want it to display (either in the list or inside the info window on the map) by checking or unchecking those boxes.

Data Set Markers

The pins are extremely customizable, to make the map searches a personalized experience. On the Markers tab, you can change a few aspects of the marker: the color, the label, the marker type, and its icon. Click on the Marker Pin to bring up the editing box. Below I chose a red and a flame icon for my hot accounts, but left it as a static marker.

Your other marker types are Single Field and Multiple Fields, allowing you to have multiple pin styles based on one or more field values. You can also do the same for the Label, to see textual information below the marker. 

For more information on the full breadth of your coloring options, check out the Configuring Data Set Markers document, or see the process in action in the video below. 

Other Data Set Settings

The final section in the Data Set edit module is reserved for various settings that don't fit under another heading. Here's a quick rundown:

Order By - You can pre-sort data set results by a specific field, ascending or descending. Note: turning this on could potentially slow down the search; this can always be done after the search is performed.

Limit - Limit allows you to return only a certain number of results. Use cases might include creating a data set of Top Ten customers, or limiting the results end users can see. 

Available in Visualize - If you create a data set that you do not want to be visible in SpatialKey for Analytics users, uncheck this box.

Refresh Interval - If you are tracking data on the map that could change frequently throughout the day, you can set that particular data set to auto-refresh. This field is measured in seconds.

One Column Address - If you need to see your address in five separate fields instead of one combined field, uncheck this box.

Id - Admins and developers can use this ID to call the data set in the API or URL Parameters.

Saving a Data Set

You have a couple of options for saving a data set.

Save - Overwrites the data set you have been editing. Only admins can overwrite an org-wide data set. End Users will only see the Save option on data sets they own or are given read/write access to inside a folder.

Save As - Create a new data set. We recommend this if you're modifying multiple filters from one of the default data sets. End Users can do a Save As against an org-wide data set to save personal changes and customizations.

Delete - The delete button is available on any data set you own or you have editing access for. Only admins can delete org-wide data sets.

Note: Geopointe admins can be distinguished differently from Salesforce admins. A Geopointe admin is based on the Profile setting. Check out the Post Install - Users and Profiles document for more information.

Data Set Folders

Data Set Folders allow you to sort Data Sets much like you would Salesforce reports. Private data sets are stored inside the My Personal Saved Layers folder and you have a broad range of sharing options available for other folders.

For more information on data set folders, check out the Saved Layers Folders document. 

Create a New Data Set

To create a new data set from scratch, you do so by clicking the [+] to the right of the data set search bar. On the next window, choose Data Set.

The following box will ask for a data set Name, the Map Object you're creating it against, and a Folder, if that's where you want it to be saved. End users will only be able to add data sets to their personal data sets folder or to a folder where they've been read/write access. When ready, click Create Data Set and it will take you to the edit window.

Data Sets can also be created from a report. To use a report as the source, it must be enabled by a Geopointe Admin. When a map object that matches up to a compatible report is selected, the option to use a report will appear. For detailed information on setup, limitations, and behavior, see our full documentation on using a Salesforce Report as a Data Set Source.

Learn More

Data Set Strategy - Get pointers on creating data sets that will best suit your team.
Data Set Markers - Apply marker configuration strategies and options.
Data Set Folders - Organize your data sets.
Data Set Filters - Use filtering to control what data appears on the Map.
Salesforce Report as a Data Set Source - See your Salesforce reports geographically.