Using a filter pane to modify chart

[morenoju]

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!

[dberkesacn · Accepted solution]

Hi, backend, you can create an island table ( not connected to your data model) by using inline load. Best Dan.

[MarioCenteno]

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)))