Have you ever wanted to display a ratio in your dashboard based on 2 fields from your dataset? Have you ever wanted to display the sum of multiple fields? Have you ever wanted to calculate the average price per square foot for real estate in your dashboard?

With SpatialKey’s advanced calculations feature, you can now do all of these things and more!

Before we dive into this feature, it’s important to outline two different ways your can compare or create advanced calculations in your data.

  1. To compare between two datasets, use a Comparison Map Layer
  2. To compare or calculate fields within a single dataset, just keep on reading below, you’re already in the right place!

There are a couple of ways to use advanced calculations in your dashboard. You can use them both in visualization pods and map layers:

  • Map layer (heat, graduated circles, thematic, bivariate)
  • Statistics pod
  • Unique value list
  • Histogram
  • Timeline and other date pods

To access an advanced calculation, simply select the “Advanced Calculation” option when selecting a metric. See example below for the Statistics pod.

advanced_calculations_1

You can calculate simple ratios, summations, differences, etc. or create your own custom equation if you have more complex needs. You can optionally add a custom label for your calculation as well.

Use our wizard for some simple calculations between two fields:

advanced_calculations_setup1

Or type out your own equation, similar to Excel:

advanced_calculations_setup2

Advanced calculations work in most of the visualization pods, and can also be a powerful way to visualize your data on the map.

advanced_calculations_layer

advanced_caulcations_layer2