mcount

mcount(X, window, [minPeriods=1])

Please see mFunctions for the parameters and windowing logic.

Return the number of non-NULL values of X in a sliding window.

x = 7 4 5 8 9;
mcount(x, 3);
// output: [1,2,3,3,3]

mcount(x, 3, minPeriods=2);
// output: [,2,3,3,3]

x1 =1 2 3 NULL 5;
mcount(x1, 3);
// output: [1,2,3,2,2]

mcount(x1, 3, minPeriods=3);
// output: [,,3,,]

m=matrix(1 2 NULL 4 5, 6 7 8 9 NULL);
m;

mcount(m,3);

s=indexedSeries(date(2020.05.26)+1..8, 3 4 9 NULL 4 6 NULL 8)
mcount(s,4d)

mcount(s,1w)

Related functions: count