Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Data from TS Plot tool

BenMoss
ACE Emeritus
ACE Emeritus

Hi everyone!

 

I'm doing some work on time-series forecasting and specifically working with the TS plot tool to understand my data.

 

I'm looking to see if it's possible to extract the data beneath the four charts, specifically when I have the 'Time Series decomposition plot' selected?

 

I've included a sample workflow.

 

Is there a quick way to do this or will I have to dive into the R script and write additional outputs from within there?

 

Thanks in advance.

Ben

9 REPLIES 9
MarqueeCrew
20 - Arcturus
20 - Arcturus

Is this what you're looking for?

 

Capture.png

 

If it is, I'll tell you how to get it....

 

Cheers,

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
WSData_dup_359
7 - Meteor

Mark,

 

I would love to know how to get the raw data out of the TS PLOT tool.

 

Not sure about your technique, but there are other "TS" tools where the raw data would be helpful as well.

 

Thanks in advance for any help! 

HossC
Alteryx Alumni (Retired)

Hello @BenMoss!

 

I don't believe that there is a simple way to extract the decomposition data from the TS Plot tool.

However, I have created and attached a macro that will retrieve the data I believe you are looking for.

The configuration for this macro is very similar to the TS Plot tool.

1. Select the target field

2. Select frequency

3. Select the period starting date (optional)

 

TS Decomp 1.PNG

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

The output from this macro will contain the following fields:

1. Period

2. Sub_Period

3. The target field (Bookings in this example)

4. seasonal - the seasonal data points from the Decomposition Plot

5. trend - the trend data points from the Decomposition Plot

6. remainder - the remainder data points from the Decomposition Plot

 

TS Decomp 2.PNG

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

This macro was developed using 11.7, so make sure you are using the latest version of Alteryx or else the macro won't load correctly.

Let me know if you have any questions or if you were looking for something different!

Hoss Carroll
Customer Support Engineer
Alteryx
WSData_dup_359
7 - Meteor

Hoss,

 

Thank you for going above and beyond on this!

 

 

HossC
Alteryx Alumni (Retired)

Hi @WSData_dup_359!

 

I'm glad that this helped! Happy Alteryx-ing!

Hoss Carroll
Customer Support Engineer
Alteryx
pml
5 - Atom

Hi,

 

I need to use the TS Decomp macro in Alteryx 11.3 or Alteryx 11.0. Any advice?

 

Thank you in advance

Charity_K_Wilson
10 - Fireball

Mark,

Please tell me how you got the decomp data out of Alteryx??  It's the R Code, isn't it?  Picking it up earlier on in the process.  You've got my interest!

TimothyL
Alteryx Alumni (Retired)

@HossC

 

Great Tool! Hoss, 

 

Just to check, when we change the field frequency from Monthly to  Daily(weekday), the data frame error pop up. Any advice on this? Everything runs perfectly with default "Monthly" setting. 

 

Attached the workflow.

dgogue
7 - Meteor

Hi,

I'm super new to alteryx. Ive been able to run the TS plot but not sure how to incorporate the macro you wrote.

Does someone mind explaining how to use this macro in a work flow? 

Labels