Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Guys,
I have 3 tables as shown:
KPI_1 | Correlation_1 | P_value_1 |
A | 0.4 | 0.07 |
B | 0.5 | 0.01 |
KPI_2 | Correlation_2 | P_value_2 |
A | 0.4 | 0.07 |
B | 0.5 | 0.01 |
KPI_3 | Correlation_3 | P_value_3 |
A | 0.4 | 0.07 |
B | 0.5 | 0.01 |
So I want a single correlation filter and single P_Value filter as below: if correlation1 or correlation_2 or correlation_3 >=0.8,"Good correlation", if correlation1 or correlation_2 or correlation_3 <=0.8,"Bad correlation" and similarly for P_value 1,2,3<=0.05,'"Significant" and P_value 1,2,3>0.05,'"Not Significant"
Please help me.
Hi,
You can create an IF formula to get this to work. You have already written out how the logic should work.
Jordy
Climber
Try this,
tab1:
LOAD KPI_1 As KPI,* INLINE [
KPI_1, Correlation_1, P_value_1
A, 0.4, 0.07
B, 0.5, 0.01
C, 0.9, 0.01
];
Left Join(tab1)
LOAD KPI_2 As KPI,* INLINE [
KPI_2, Correlation_2, P_value_2
A, 0.4, 0.07
B, 0.5, 0.01
C, 0.1, 0.01
];
Left Join(tab1)
LOAD KPI_3 As KPI,* INLINE [
KPI_3, Correlation_3, P_value_3
A, 0.4, 0.07
B, 0.5, 0.01
C, 0.1, 0.01
];
Left Join(tab1)
LOAD KPI,
If(RangeMax(Correlation_1, Correlation_2, Correlation_3)>=0.8, 'Good correlation', 'Bad correlation') As Cor_Result,
If(RangeMin(P_value_1, P_value_2, P_value_3)<=0.05, 'Significant', 'Not Significant') As Val_Result
Resident tab1;
Output: