on 11-28-2017 10:20 AM
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?
in the webi document summary check the option "extended merge dimension" and try.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
94 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.