Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi friends,
Alreday I have used the calculated dimensional in a bar chart by using value list method
=ValueList('Occupied','Partially Occupied','Available')
and expression is if(ValueList('Occupied','Partially Occupied','Available')='Occupied',vOccupied,if(ValueList('Occupied','Partially Occupied','Available')='Partially Occupied',vPartiallyOccupied,if(ValueList('Occupied','Partially Occupied','Available')='Available',vAvailable)))
But i need to bring the calculated dimensional value list method =ValueList('Occupied','Partially Occupied','Available') in script wise as a dimensional
How can I bring the value list in script wise to set as dimensional
Regards,
Vijay.M
Simple create a inline table
LOAD *
[
Dim1
Occupied
Partially Occupied
Available
];
Why cant we use an inline table like
Load Status, <Your expression> as 'value' inline
[
Status
Occupied
Partially Occupied
Available
];
Or it is easy to get
LOAD *
[
Parameters, SNO
Occupied, 1
Partially Occupied, 2
Available, 3
];
And then front-end should be
Dim as Parameters
and expression should this
if(sNO=1,vOccupied,if(SNO=2,vPartiallyOccupied,if(SNO=3,vAvailable)))