Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account here.

Alteryx Designer Desktop Discussions

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

Time Series Plot - Date Error

vkarthi8
7 - Meteor

I have the below 2 questions, if someone could help me on this:

 

1.My data starts from August month, but when i have the Time Series Plot, the Interactive Output (I) shows the month as January. How to correct this? 

2. I have daily data for a particular details and the weekend data has with outliers. How to exclude the weekend data in the Time Series Plot?

 

 

 

 

2 REPLIES 2
DataNath
17 - Castor

Hey @vkarthi8 I've seen this raised before and the behaviour is actually expected for Alteryx. The following is from: https://help.alteryx.com/20221/designer/ts-plot-tool

 

DataNath_0-1668440842576.png

 

The TS plots use a default date display which happens to be in January - see here even though the dates I feed in are July+

 

DataNath_1-1668440856914.png

DataNath_2-1668440870006.png

 

In response to your second point, you can filter weekends out with something like this:

 

DataNath_3-1668440893941.png

 

DateTimeFormat([Date],'%a') NOT IN ('Sat','Sun')

 

Hope this helps!

vkarthi8
7 - Meteor

@DataNath - Thank you for giving a headsup on this.. it helps ..

Labels