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

WeeklyData.yxmd

Developer

Accepted answers

binu_acs

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

WeeklyData.yxmd

All comments

NMangera

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

binu_acs

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

WeeklyData.yxmd

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!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703