Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi mates!
I got this table:
DATO | KPI | VAL DATO | VAL KPI |
D.001 | D.001.K1 | 99,2205% | 98,4679% |
D.001 | D.001.K1 | 99,2205% | 98,4679% |
D.001 | D.001.K1 | 99,2205% | 98,4679% |
D.001 | D.001.K1 | 99,2205% | 98,4679% |
D.001 | D.001.K2 | 99,2205% | 100,0000% |
D.001 | D.001.K2 | 99,2205% | 100,0000% |
D.001 | D.001.K4 | 99,2205% | 98,9989% |
D.001 | D.001.K4 | 99,2205% | 98,9989% |
D.001 | D.001.K4 | 99,2205% | 98,9989% |
D.001 | D.001.K4 | 99,2205% | 98,9989% |
D.001 | D.001.K5 | 99,2205% | 100,0000% |
D.001 | D.001.K5 | 99,2205% | 100,0000% |
D.001 | D.001.K5 | 99,2205% | 100,0000% |
D.001 | D.001.K6 | 99,2205% | - |
D.001 | D.001.K6 | 99,2205% | - |
D.001 | D.001.K6 | 99,2205% | - |
D.001 | Gar_5 | 99,2205% | - |
Now I´m getting VAL DATO as the average of all values of VAL KPI (without null values).
I want to get the average of these values by KPI (without null values), the table will be like this:
DATO | KPI | VAL DATO | VAL KPI |
D.001 | D.001.K1 | 99,3667% | 98,4679% |
D.001 | D.001.K1 | 99,3667% | 98,4679% |
D.001 | D.001.K1 | 99,3667% | 98,4679% |
D.001 | D.001.K1 | 99,3667% | 98,4679% |
D.001 | D.001.K2 | 99,3667% | 100,0000% |
D.001 | D.001.K2 | 99,3667% | 100,0000% |
D.001 | D.001.K4 | 99,3667% | 98,9989% |
D.001 | D.001.K4 | 99,3667% | 98,9989% |
D.001 | D.001.K4 | 99,3667% | 98,9989% |
D.001 | D.001.K4 | 99,3667% | 98,9989% |
D.001 | D.001.K5 | 99,3667% | 100,0000% |
D.001 | D.001.K5 | 99,3667% | 100,0000% |
D.001 | D.001.K5 | 99,3667% | 100,0000% |
D.001 | D.001.K6 | 99,3667% | - |
D.001 | D.001.K6 | 99,3667% | - |
D.001 | D.001.K6 | 99,3667% | - |
D.001 | Gar_5 | 99,3667% | - |
Thank you very much guys!!
Try avg({<[Val KPI]={">0"}>}total [Val KPI])
Thank you Gysbert,
Sorry but I'm trying to do it on Script, is it possible?
Thanks again.