How to plot Pie Charts as Markers on a Map Chart in Spotfire

The mapping capabilities in Spotfire have come a long way over the last few years. They are great for visualizing data spatially and looking at trends over a geographic region. There’s a unique feature in Spotfire that lets you plot mini pie charts on the map, instead of the standard markers.

In this tutorial, you’ll learn how to use pie charts as markers on a map chart, as shown in the picture below.


Continue reading

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