Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a chart that I want to read data from different tables depending on a selection by the user.
I wanted to add a filter pane with two values, and then use something like if(getFieldSelections...) to show data from one table or another in the chart.
Where should I create that field with two possible values? In the load script? How?
Or should this be a master item dimension? Or a variable?
Thanks much!
Hi, backend, you can create an island table ( not connected to your data model) by using inline load. Best Dan.
Hi, backend, you can create an island table ( not connected to your data model) by using inline load. Best Dan.
Try
For example
LOAD * INLINE [
CUST_NAME, STATUS
A, PASS
B, FAIL
C, PASS
D, FAIL
E, PASS
F, FAIL
G, PASS
H, FAIL
];
[measure_names_real]:
load * inline [
measure_real
PASS,
FAIL
];
Expression :
if( only(measure_real)='PASS', count(STATUS),
if( only(measure_real)='FAIL', count(STATUS)))