Gojo Member

Hi David. Just to follow up here, as mentioned above, I have twelve fields that list monthly budgets amounts, one for each month in the year. the 12 fields are labeled as such, budget month 1, budget month 2, budget month 3, etc. I also have a start date and end date range, these dates ranges will differ from user to user.…

Hi David, My apologies for being unclear. My question is what woud be the best way to set up such a process in the ETL, so that it works properly?

Thank you David and Grant. David, to answer your question: ——-By the way, this might just be because you're showing example data. But are you trying to get the daily average or the average by id across all dates? Because right now your example data is the average by id across all dates (the average for each id is the same…

Hi David, My apologies for my late reply. Thank you for the detailed response! I set this up, so the budgets appear on each day. I do have another follow-up question, if you have two datasets, one primary, and the other the calendar dataset, and both have date columns. So eventhough there is a unique identifier, because…