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

1-Spotfire_Lookback_Period

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.

1_-_5_minute_spotfire_dashboard

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