Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Consider the following table of data consisting of Time and Target for that time, and Quality and Target for Quality.
Group | Time | Time Target | Quality | Quality Target |
1 | 100 (1) | 115 | 0.10 (1) | 0.15 |
2 | 111 (1) | 116 | 0.11 (1) | 0.12 |
3 | 123 | 116 | 0.32 | 0.13 |
4 | 120 | 117 | 0.09 | 0.12 |
5 | 75 (1) | 118 | 0.23 | 0.11 |
6 | 132 | 119 | 0.11 | 0.17 |
I wish to get a KPI to COUNT the following conditions
Each group has a different target so i cannot use a fixed value but i need to use the column Name within the expression.
The below does not work.
=COUNT({<Qual = {"<$(Targ_Qual)"}, Time = {"<$(Targ_Time)"},PRODUCT={"Product 1"},WK={"WK1"} >}DISTINCT OUC)
it is possible to do comparisons of columns in set analysis syntax is soemthing like this.
Identifier= {"=Qual<Targ_Qual"}
but i have not tried a situation with and condition (targ time and targ_qual)
if they are in same table i would create a flag in the script and use that in the set analysis.
it is possible to do comparisons of columns in set analysis syntax is soemthing like this.
Identifier= {"=Qual<Targ_Qual"}
but i have not tried a situation with and condition (targ time and targ_qual)
if they are in same table i would create a flag in the script and use that in the set analysis.
I have ended up getting a solution by make 2 flag fields in the data as suggested. then using this in the set anaysis.
Still curious on how to do this without the flag field to save on space?