The OVER function is a very useful function in Spotfire that calculates expressions and aggregations across different groups of data. I’ve previously written about the OVER function, which you can check out here. This post has additional examples using the OVER function, focusing on multiple columns and expressions requiring the Intersect function.

# Standard Deviation in Spotfire Expressions and Visualizations – Part 2 of 2

There are many different ways to use standard deviation in TIBCO Spotfire – the video in this post shows 6 different examples of how you can use standard deviation in Spotfire to learn more about your data.

For example, we can make statistical outliers stand out with color to alert us when a condition deviates outside of the desired range:

# Standard Deviation in Spotfire Expressions and Visualizations – Part 1 of 2

Standard deviation is a statistical calculation that’s used to describe the spread of data around its average value. Standard deviation is simply the square root of the data’s variance, and the variance describes how close each data point is to the overall average. Standard deviation is useful in when analyzing the distribution a dataset, as shown in the screenshot below.

# How to use Data on Demand with Markings in Spotfire

The Data on Demand feature in Spotfire lets you define conditions that must be met before data is loaded from the source into Spotfire. Instead of loading all data at once, data will only be loaded for the conditions that you specify.

In this video you’ll learn how to load Data on Demand from a large database by selecting, or marking, data points on a map chart, as shown in the screenshot below.

# How to plot Pie Charts as Markers on a Map Chart in Spotfire

The mapping capabilities in Spotfire have come a long way over the last few years. They are great for visualizing data spatially and looking at trends over a geographic region. There’s a unique feature in Spotfire that lets you plot mini pie charts on the map, instead of the standard markers.

In this tutorial, you’ll learn how to use pie charts as markers on a map chart, as shown in the picture below.