Post_21-Blog_Thumb

How to use Property Controls in Spotfire to Switch between 2 Date Columns on the X Axis

In time-series and trend analysis, it’s common to use dates on the X axis of a chart to show trends over a particular time period. Sometimes it’s useful to show absolute dates (e.g. Month and Year), and other times it’s desired to plot over a normalized scale (e.g. all data points starting at time = 0), as shown in the 2 charts below.

CLICK HERE To download the Spotfire template shown in the video.

1-Mutlple_Date_Scales_on_X_Axis_Spotfire

Continue reading

How to Forecast Data with TIBCO Spotfire

I’ve received several questions recently about forecasting future values in TIBCO Spotfire. Forecasting in Spotfire can be tricky because it’s hard to add rows to your data table. Unlike Excel, you can’t just drag down a formula. It is possible to forecast in Spotfire, and fairly simple once you learn the steps, but it’s definitely not straightforward or obvious.

Forecasting Data with Spotfire
Continue reading

How to Color Line Charts in Spotfire with a Property Control

Do you get frustrated when you set the colors in a Spotfire chart, only to see them change after updating the expression, aggregation method, or display name? In this video, I’ll show you how to assign a color to a document property to make the document property update not only the values on a chart, but also the color.

1-Spotfire_Line_Chart_with_Property_Controls

Click here to download the Spotfire file shown in the screenshot!

Continue reading