Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am a bit confused about what I am doing and need some help.
I have the script below which works out the median of value in the script. the median values are to be used later as KPI object.
My question is What expression can I write to create the KPI object so that it is still dynamic and when users make selections they are shown the Median of the selection given it has been calculated in the script. Do I sum?Avg? the median field
Please Note this is based on large data set hence why we decided to calculate the median in the script.
Script
TABLE:
Load *, Code&category as key;
Load * Inline [Code, category, value
EP.236, EqkcV, 641
EP.236, EqkcV, 3048
NF.209, EqkcV, 319
GG.813, Kvol, 112
GG.813, Kvol, 292
GG.813, Kvol, 1560
GG.813, yudtv, 448
NF.209, yudtv, 1784
NF.209, yudtv, 2112
VS.847, yudtv, 360
VS.847, yudtv, 570
VS.847, yudtv, 2076
];
NoConcatenate
med:
lOAD key,
Median(value) as Medianval
Resident TABLE
Group BY key;
Median ia also a chart function, so it can be used on viz level.
Tomasz