Grouping between Dates
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
So i have some daily data that is great, but i need to compare it to another group of data that is only in weekly format. So i am trying to group the daily data to weekly, but having some issues.
I created a workflow, the input is the daily data and below that i created the weekly dates (every Saturday) and i created a record id for each week, i was thinking i could use the generate row formula to generate all the dates in between and then the record id would be the same for each group. That way i could do a join and sum the data. But i'm running into issues with the generate rows. Any help would be appreciated... or if there is an easier way to look at this.
Thanks! Workflow is attached
Solved! Go to Solution.
- Labels:
- Optimization
- Time Series
- Tips and Tricks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Please check the attached.
I used Generate row to add automatically 7 days, create the start and end o a week, then generate the days in between. Hope it helps. Cheers!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator