Cross Tables are a great way to quickly summarize data and evaluate relationships between different variables in Spotfire. If you’ve ever worked with Pivot Tables in Excel, then you’ve probably recognized that Spotfire Cross Tables are very similar.CLICK HERE To download the Spotfire template shown in the video.
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.
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.
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.Click here to download the Spotfire file shown in the screenshot!
This blog post demonstrates several examples of Custom Expressions using the OVER function. In a couple of previous blog posts I’ve focused on using the OVER function in calculated columns, so to mix it up this time we’ll be looking at OVER functions within a visualization.