on 09-07-2017 1:45 PM
This question is about Webi/BOXI 4.0 with no universe access.
Hello,
I have a measure variable to bring back the MAX reference number (its actually the result of a nested MAX statement), anyway
I have the reference that I needed.
Now I want to bring return a field using that reference, passing to a new variable to say
=[FIELD I WANT] WHERE (TABLE ID = MaxVar ID)
I get no results.
try to drag all three object in the table along with Type variable and check what is coming?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I have done this anyway. I do this to check that the variables are moving between variable types.
The original ID variable is a Measure
Then I transferred it to a dimension (and tried detail too) - this works fine.
The final variable that uses the reference is also a detail. as shown in the screenshots.
=[FIELD I WANT] WHERE (TABLE ID = MaxVar ID)
All have been added to the table. [FIELD I WANT] column is empty.
User | Count |
---|---|
83 | |
10 | |
10 | |
9 | |
7 | |
6 | |
6 | |
6 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.