Creating a forecast by fitting a curve to historic data

[Matthew]

Hello everyone, i would love to learn how to use the predictive analytics tools in alteryx (perhaps a neural network?) but so far i havent figured out how to apply those tools to my data.

So instead, i am trying to manually fit a curve to my historic data, and use it as a model for future projections.

So far my historic data appears to fit a geometric pattern ( A * B^(n-1) )

Now what i need to do, is figure out how to fit that curve (green line) systematically onto the blue line.. does anyone know how i can get alteyx to find the best values for A and B to best fit the blue line?.. Once i have that i believe i can then cross multiply those values to fit it onto the orange line.. That would become my "forecast"

Right now i've manually set A = 1.3, and B = 1.02.. but i want alteryx to tell me those values, rather than manually plugging them into the formula

attached is a sample set of data, and a section of the workflow

[Matthew]

This isn't the solution I want, but I've built a rudimentary "forecast" by just multiplying the historic data by the ratio of actual data divided by historic data..

[Matthew · Accepted solution]

in case anyone else has this problem in the future, I've built a geometric regression macro that uses a Python script to find the best fit