Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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])