More OVER Function Examples: Multiple columns, Intersect function, and LeBron James

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.


Continue reading

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.

Standard Deviation plotted on Spotfire chart

Continue reading