Grabbing Date Questions

[jennnnyk]

Hi all, I am running in to a problem on " how I can calculate the total sales from the previous 10 days excluding all weekends and the day before the holidays from a few different dates". Are there any tools that would be recommended to use. The data that have has date column and the day of week. 

Example: I will have the date: 06-24-2020, I want to calculate the total sales from previous 10 day excluding weekends and holidays.  And I also have the date: 06-28-2020, I want to do the calculation the same way, but also have to exclude 6/24. 

Thanks for the help in avdvance!

[randreag]

hi @jennnnyk 

I attached an example of how can you accomplish what you need 

In the Text Input of holidays you can also put the dates you want to exclude

It is an idea perhaps needs some more modifications

[SeanAdams]

Hey @jennnnyk 

There are a few steps here:

a) Compute your earliest date.   There's a great post by @NicoleJohnson on how to do this here: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Networkdays-in-Alteryx/td-p/70976

Add this date onto your dataset as a new column

b) For each row - check if it's within this date range using a filter

c) Summarize sales using Summarize tool.