Trying to get Weekly data for the past 7 days

[Jay2022]

Hi,

I have a workbook that I would like to get the last 7 days worth of entry each week. However, I am not able to figure it out just yet meaning do I use a formula or a bsic filter and if so what and how. I have added a sample of that I have so far.

Thank you

[NMangera]

the file type shared is a workflow. Can you share a sample of the data please?

[binuacs · Accepted solution]

@Jay2022 You can use the filter tool to find the last 7 days based on the current date

[RobertOdera]

Hi, @Jay2022 

Absent a sample for us to look at, try the below:

1. create a new column called Today_Date, given by DateTimeToday() in Alteryx. Set the Data Type as Date

2. create another column called 7_Days_Ago_Date, given by DateTimeAdd([Today_Date],-7,'days') in Alteryx. Set the Data Type as Date

3. Add a filter tool to your data stream where your Data Date Column >= 7_Days_Ago_Date

That should give you only the last 7 days...

However, also sound like we might need to work the Date into Weeks and only filter to show the most recent week (this way, you only have data pertinent to that week).

Please provide a sample plus the desired out, and the community will help accordingly - Cheers!