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