SOLVED
Weekly summary with the daily data
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
moinshaik
7 - Meteor
‎11-05-2019
04:53 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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 |
Solved! Go to Solution.
Labels:
- Labels:
- Data Investigation
- Time Series
4 REPLIES 4
JosephSerpis
17 - Castor
‎11-05-2019
05:01 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎11-05-2019
05:22 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
15 - Aurora
‎11-05-2019
05:30 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @moinshaik, here's @JosephSerpis' solution with dates formatted like yours:
JosephSerpis
17 - Castor
‎11-05-2019
05:40 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @moinshaik I amended the solution to work with Alteryx dates. Let me know what you think?