Weekly summary with the daily data

[moinshaik]

Is there a solution for the below case. I am not able to locate what exactly we need to do. I have a daily data and I need it weekly for example below. Sunday being the weekend day.

10/1/2019	10/6/2019
10/2/2019	10/6/2019
10/3/2019	10/6/2019
10/4/2019	10/6/2019
10/5/2019	10/6/2019
10/6/2019	10/6/2019
10/7/2019	10/13/2019
10/8/2019	10/13/2019
10/9/2019	10/13/2019

[JosephSerpis · Accepted solution]

Hi @moinshaik I mocked something up that I think answers your question. Let me know what you think?

[moinshaik]

I have date already formatted in date format as per the alteryx because of which your solution is not working. Can you please do it for the formatted date. Please see the below screenshot. 

[OllieClarke · Accepted solution]

Hi @moinshaik, here's @JosephSerpis' solution with dates formatted like yours:

[JosephSerpis · Accepted solution]

Hi @moinshaik I amended the solution to work with Alteryx dates. Let me know what you think?