Skip to Content
0
Former Member
Nov 28, 2017 at 10:20 AM

Merged Excel query

45 Views Last edit Nov 28, 2017 at 10:19 AM 2 rev

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?

Attachments

1.png (33.1 kB)