How to Create Custom Short Number Formats in Spotfire

Click Here to download the Spotfire template shown in this article!

This article explains how to create custom short number formats in Spotfire, specifically using standard oilfield abbreviations.

When you’re working with large numbers on the axes of your visualizations, sometimes all of the zeros or extra digits can take up unnecessary space and become distracting, wasting valuable real estate on your dashboard.

Continue reading

How to use the OVER Function in Calculated Columns in TIBCO Spotfire

Click Here to download the Spotfire template shown in the video

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.

Continue reading