In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

Filter data for previous day

mercurial_maverick
8 - Asteroid

Hello all,

 

I'm have existing alteryx workflow which publishes output to an excel file. Currently there is data in the excel file from previous runs. I need to add in a filter tool for the field "date" to filter for only previous day's data and append to the excel file. For example, tomorrow when I run the workflow it filter for date = previous day and append previous day's data to the output file. any idea how to achieve this using the filter tool?

10 REPLIES 10
MChung
6 - Meteoroid

@JosephSerpis 

 

Hello Joseph, 

 

I am having this exact problem. I would like to output a table that is only showing the previous day's data. For example, "how many interviews were conducted by Group A yesterday?" Mimicking the formula in this thread is giving me errors. The format for the date field on my report is written as, "2020-08-13". How would I use the formula to output the data that I need? Thank you in advance.  

Labels
Top Solution Authors