We have extended our Early Bird Tickets for Inspire 2023! Discounted pricing goes until February 24th. Save your spot!

Alteryx Designer Discussions

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

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
ACE Emeritus
ACE Emeritus

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