Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
I have been working on 1 dimension value list but the current requirement wants to me take up 2 dimension value list.
The first dimension is
=ValueList('A','B','C','D','E','F')
For the above value list, how do i create another value list against the value from the first
A Z
A X
B Y
C U
D P
E K
F L
The output is given above.
why are you thinking to use ValueList for your use case?
The current dashboard that i am working on is basically related to KPI's and it has 2 dimensions and 5 different columns who values has to be calculated cell by cell.
Is there an another way of doing this.?
Please let me know if its possible?
Thanks,
Ishan
ok so you should add another ValueList dimension and check the combination of both dimensions values in your 5 measures expressions.
Absolutely. Thats right.
something like this?
If you know what the values are going to be, you might create a simple inline table and iterate over it's values.
Temp:
load * inline [
dim1,dim2
A,Z
A,X
B,Y
C,U
D,P
E,K
F,L
];
then use dim1 and dim2 in your visualization instead of value loops. May not work if you need actual relationship between dims and the data your measuring