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

In this video, I demo a Spotfire model that uses Decline Curve Analysis (DCA) to forecast oil and gas production. With just a few inputs and some simple TERR scripting, we can fit a curve to historical data, and then use those inputs to forecast future production. These same concepts can be applied to other datasets to forecast values for other industries or applications.

Check it out:

If the embedded player above isn’t working, this video is also on YouTube:

How to Build a Forecast in Spotfire
I mention in the video I mention that actually building the forecast is out of the scope of a short video or blog post. To learn more about forecasting in Spotfire, make sure to visit this link:

Questions / Comments
I hope you’ve enjoyed this overview of forecasting with TIBCO Spotfire. If you have any questions or comments, or if there’s something you’d like featured on this blog, feel free to email me at or leave a comment below.

4 thoughts on “How to Forecast Data with TIBCO Spotfire

  1. Spencer Reply

    You are down right awesome…. Thank you so much! Love your blog!

    • Kyle LaMotta Post authorReply

      Thank you Spencer!! I really appreciate the feedback, glad it was helpful!

  2. Gabriel Reply

    hello, i’m trying to calculate a % accumulation of a variable over time; i’m using this formula: Sum([PLOTS_PUBLISHED]) THEN Sum([Value]) OVER (AllPrevious([Axis.X])) / Sum([Value]) OVER (All([Axis.X])) as [% PUBLISHED]

    the problem is, i would like to have the division made by another value (in another column [FORECAST] so that at any time i know which is the % of the FORECAST completion
    can you help me do it? i run out of ideas

  3. ganesh Reply


    Nice to be visiting your blog again, it has been months for me. Well this article that i’ve been waited for so long.

    I have a data set of users and the date they have logged into the system. I want to show a cumulative chart which shows the number of new users of every month on top of returning users. I have attached a picture for reference. The X axis would be the Months and the Y axis would be the count of User Ids
    THANK YOU!! This saved my butt today, I’m immensely grateful.


Leave a Reply

Your email address will not be published. Required fields are marked *