community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

AB Trend error . Cannot get it to work.

The error message:

 

AB Trend (25) AB Trend: The range of the dates in the data is not consistent with the test start date and/or the number of periods to base the trend measure on and/or the reporting period of the data.

 

I have tried with multiple parameters with the same error.

 

Attached my workflow and my data.

Alteryx Certified Partner
Alteryx Certified Partner

I've just done some testing and there are two key things to fix here.

 

Firstly, the note at the bottom 'The input data must have data for at least a year plus the number of periods prior to this date, for example, for weekly data with 2 periods selected, you need 54 prior records in your data stream.'

 

This criteria is met in very few (I think only one instance, the last one) in your workflow.

 

Secondly, your data is at a level of aggregation beyond that needed for the tool. You want to predict the gross-margin by store. But actually your dataset is aggregated at day-invoice-week-store.

 

You can drop a summerize tool in before your AB-Trend tool, and then summerize by Store, Week and then aggregate the margin value in the way you want, say sum.

 

Then you can plug this in, and take the 'year of prior records' note into account and you should be good!

 

Example attached from your data.

 

Ben

 

 

Asteroid

Hi @BenMoss,

 

I am working on a Time Series problem wherein I am trying to impute the missing values in a dataset. I have been thinking of using the Trend and Seasonality present in the data for this imputation exercise which I am trying to calculate using the AB Trend Tool.

 

Can you comment on this approach or if I should be adopting some other approach to impute the missing values in the dataset.

 

Thanks,

Ashish

Alteryx Certified Partner
Alteryx Certified Partner

Unfortunately I'm no predictive expert, let's see if others have input, but perhaps you can ask on something like stackoverflow about how to approach the problem and then translate that  to Alteryx.

 

Ben

Meteoroid

Thank you for this

Labels