community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
#SANTALYTICS

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More
We will be upgrading the Gallery to our 2019.4 release this Saturday, December 7th beginning at 9:00am MT. We expect the outage to take last approx. 2.5 hours.

Need help for Formula

Highlighted
Asteroid

Hi,

 

I have the sample data like below.I have the data from 2016 to till today everyday data will get added.But only given few dates below.  When i see Monday data will be there till Monday like below.

 

Sample Data: 
DateId's
10/15/2018 21:161
10/15/2018 23:331
10/15/2018 23:461
10/13/2018 1:201
10/13/2018 8:461
10/13/2018 14:121
10/14/2018 12:091
10/15/2018 5:041
10/15/2018 6:241
10/15/2018 16:231
10/13/2018 0:021
10/15/2018 13:541
10/14/2018 11:441
10/14/2018 19:001
10/14/2018 19:151

 

I need a formula to calculate Saturday,Sunday and Monday for Monday when i ran my workflow like below. 

 

Output 
DateTotal id's
10/13/20184
10/14/20188
10/15/201812

 

 

Alteryx Certified Partner
Alteryx Certified Partner

One way to approach this is to compute the daily values for all days, then just filter that data to only the relevant days. The dates filtered will have a minimum and maximum range since Monday's reports will need to pull data from 3 days.

 

I've attached an example solution that will show how to use some of the date/time functionality in Alteryx to achieve this. 

 

 

Labels