SpatialKey allows dataset Contributors and Creators/Editors to manipulate certain properties of imported columns (fields). The properties that can change include:
- Changing the name/label of a particular column
- Adding a description to the column
- Adjust the format of a numeric field
- Adjust the currency format of a currency field
- Setting the visibility of a column (enabled/disabled)
- Setting the available aggregation options for a column (if the column is a numeric data type) within a report
These properties can be managed through the Manage Data tab. Click on the gear icon to view data settings, then select the “Advanced Settings” option on the left side of the screen. On the “Fields” tab, you can manage column information for your dataset. Each column can be edited individually by hovering your mouse over the column and clicking the “edit“ button that appears.
Selecting the edit option will allow you to edit the label and description, enable or disable a column, adjust the number and currency format, and enable or disable aggregate functions for a column. The contents of the column edit window can vary based on the type of data that is contained within that column. For example, numeric data will contain additional options for controlling the types of aggregates that can be applied to the data within a report.
Editing Labels, Descriptions and Visibility
When a dataset is imported into SpatialKey, the name and label of each column is produced based on the header line of an imported CSV file or from the column definitions from within a shape file. In many cases these names may not be human readable (this is especially true when the data was extracted for another system like a database). You can set the label and description values from within the column details window – these new labels and descriptions will appear when viewing the dataset in dashboards.
If you would like to exclude a column completely from the reports you can uncheck the “Enabled” checkbox. It is important to note that the column still exists along with the associated data, it is simply not visible from within reports. You can also change visibility by clicking directly on the column rows in the table. The agent and agent id columns have been disabled in the example below.
Numeric columns in SpatialKey can have aggregate functions applied to them (sum, average, minimum, maximum). In some cases, having these options does not make sense based on what the data in the column represents. For instance, your data may contain a field called “Average Home Price”. This field is already aggregated (an average) so applying another average or even summing the aggregates would not make much sense.
To eliminate confusion in report creation, the dataset Creator/Editor or Contributor could specify that the “Average Home Price” column should not allow average and sum aggregates to apply, but leaving minimum and maximum since that could have value for filtering. To change which aggregates are available, uncheck the “All” checkbox and then check or uncheck which aggregate functions should apply to the column. Remember, that these options will only be available for numeric data types.