How to Create Rolling Time Periods in Spotfire

Often times it’s appropriate to look a recent trend or the performance of something, without looking at the entire history. For example, an oil well might have been producing for many years, but from a diagnostic perspective you may only care about what it’s done in the last 3 months. Or 6 months. Or 7 days, or whatever time period you come up with.

This can be called a “rolling time frame” or a “look-back period”.

Download the Spotfire example shown in the Screenshots


Continue reading

How to Limit Data using an Expression in Spotfire

Have you ever wanted to limit the data displayed in a visualization without using filters?

Most of the time your Spotfire projects have multiple graphs on a page, with each one serving a different purpose. Let’s say you want one of those charts to limit data more than the filter settings, like a specific time period (ex: “This year’s production”).

Continue reading

How to create a Spotfire dashboard in under 5 minutes

In this post I show how to create a working dashboard – in less than 5 minutes! The picture below shows the final product.


What is a dashboard? The answer seems to vary depending on who you ask, but Stephen Few, the well-respected author of Information Dashboard Design, says that: “A dashboard is a visual display of the most important information needed to achieve one or more objectives, consolidated and arranged on a single screen so the information can be monitored at a glance.”

In other words, you shouldn’t have to work hard to find the information you need!
Continue reading

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