The OVER function in Spotfire can be very useful when writing custom expressions for calculated columns in Spotfire. It’s used to divide a column into different groups, so that you can evaluate a calculation for each group, instead of the entire column. Unfortunately, examples with OVER expressions in calculated columns are not very well documented in the help files. There are several examples for using it in visualization axis selectors, but not in calculated columns. If you’re familiar with writing SQL statements, the OVER function is very similar to GROUP BY.
Click Here to download the Spotfire template shown in the video