Trend Line Slope

Hi, I am trying to figure out how to manually calculate the slope of a trend line in Alteryx. I am looking at a list of supplier purchases and need to identify suppliers that have negative purchasing trends (i.e. throughout the year our company has started to purchase less and less from the supplier either quarter by quarter or month by month). My plan is to use the calculated slope to filter a list of all suppliers and identify which suppliers have negative slopes, indicating any supplier with a negative purchasing trend throughout the year. Obviously I can figure this out for one supplier but I need a way in Alteryx to solve for over 200 at once in order to target specific suppliers. Please let me know if anyone has any insights. Thank!

Accepted answers

JessieC

@danchips24 - You can examine the trend using Scatterplot or TS Plot for time series data.

Using this for slope...

I built this example to calculate slope where Y is purchases and X is time (months) -

Slope.yxzp

All comments

JessieC

@danchips24 - You can examine the trend using Scatterplot or TS Plot for time series data.

Using this for slope...

I built this example to calculate slope where Y is purchases and X is time (months) -

Slope.yxzp

danchips24

I think this definitely works on a certain level, but the data I am looking at has fairly complex trends over time. As such looking solely at the first and last data points of each set does not present an accurate representation of the trending for each supplier.

estherb47

Hi @danchips24

Wondering if this macro would be helpful. https://gallery.alteryx.com/#!app/Least-Squares-Regression--Slope--Intercept-/5ab4ff0f8a9337138c471ab7

There are macros available to pull the regression calculation from a linear regression tool as well. Take a stroll through the public gallery to find more.

Let me know if that helps!

Cheers,

Esther

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15880

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703