This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Currently trying to use the time series plot. My data runs monthly from Jan 2016-Aug 2021.
The date field is currently formatted:
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?
A formula like:
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