Display script median as KPI

[ericdelaqua]

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;

[tomasz_tru]

Median ia also a chart function, so it can be used on viz level.

Tomasz