This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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.