I have a Universe query and an Excel query.
The Universe query contains 5 weeks of data while the Excel query contains a full year.
I need to have the data merged on the Week End Date, among other dimensions and when I use the Week End Date from the Universe query I'm able to only show the counts from the 5 weeks of Universe data. I need to be able to remove the Week End Date and show the counts from the Excel file for just the 5 weeks from Universe query.
I have tried ForEach([Week End Date]) but haven't had any success. Is there another way to accomplish this?