Alteryx Designer Discussions

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

Setting up for Time Series

dgogue
7 - Meteor

Hi team,

Currently trying to use the time series plot.  My data runs monthly from Jan 2016-Aug 2021.

The date field is currently formatted:

yyyy-MM-dd

 

One issue i need help solving is:

Date in data set is ahead by one month (ie sales for January 2016 will have a date as 2016-02-07).  

I would like the time series plot to show me patterns by the actual month that sales took place so i need to fix the above problem.

 

Also, how much do i need to parse the date field to work in time series tool?  or does the date field not actually matter? 

1 REPLY 1
jdunkerley79
16 - Nebula
16 - Nebula

A formula like:

DateTimeAdd(DateTimeTrim([date],"month"),-1,"months")

should sort the date out for you and realign.

 

If your dates are in the format you said should work fine with TImeSeries tool but I am not an expert on that tool

Labels