Two filterpane assocaition

[srujanaponnuru]

Hi All,

I have a requirement as below:

two filter panes 

1. Function

2. Metrics

In backend i created two inline tables:

Load * Inline [

Function

FinanceHealth

Opearational helath

credit risk

2nd inline:

Load * inline [

Metrics,_Metric_Flag

A1,A

B1,A

C1,A

D2,B

E2,B

F2,B

X3,C

Y3,C

Z3,C

in Metrics filter pane i have written the logic as below:

=if(GetFieldSelections(Function) = 'Finance Health', if(_Metric_Flag = 'A', Metrics),

if(GetFieldSelections(Function) = 'Operational Health', if(_Metric_Flag = 'B', Metrics),

if(GetFieldSelections(Function) = 'Credit Risk', if(_Metric_Flag = 'C', Metrics))))

Problem: 

When i click on Function as Finance health, only A1, B1, C1 should be visible in Metrics Filter pane

So when i click on A1 in Metrics pane, in Function filter pane all the other two (Operations and Credit ) is getting selected. 

I  want to click function as Finance and in metrics all A1, B1, C1 should be visible, and if i click on A1 in metrics filter pane, function should remain on Finance health only.

Help me 

[GaryGiles]

Create you inline tables like this, with the _Metric_Flag as a common field between the tables:

Function:
Load * Inline [
Function,_Metric_Flag
FinanceHealth,A
Opearational helath,B
credit risk,C
];

Metrics:
Load * inline [
Metrics,_Metric_Flag
A1,A
B1,A
C1,A
D2,B
E2,B
F2,B
X3,C
Y3,C
Z3,C
];

Then you the Filters panes will interact, using Function as the dimension in one filter and Metrics in the other.

To get each Filter pain to only show values based on selections made, you can the following as the dimension expressions for the Filter panes:

=aggr(only([Function]), [Function])

=aggr(only([Metrics]), [Metrics])