Alteryx Designer Discussions

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

Grouping between Dates

8 - Asteroid

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.

krishnagandhi_0-1605032864493.png

Thanks! Workflow is attached

 

Hi @krishnagandhi 

 

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!

 

christine_assaad_0-1605034799717.png

 

Alteryx Certified Partner

Another solution 

 

For the generate rows you need to declare the start of the sequence and the end of it, besides it should be the same type

 

It hope it helps

Labels