Add units next to scale label numbers on a Spotfire chart axis

Click here to download and follow along with the Spotfire file shown in this article

I’ve been asked many times “How do I add units to columns in Spotfire?” It some cases it would be nice to have units next to a chart axis value, as shown in the picture below. Well, the truth is, there’s not a feature in Spotfire that allows you to specifically do this, but there are a couple of workarounds.

1_Example with Units

Continue reading

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