All,
percentiles only work with numbers, not dates.
If I use the ms function, I can get the number of milliseconds between NOW and
the import date. Then we can use that result in calculating the median age of
the documents using percentiles.
rows=0=true={!tag=piv1 percentiles='50' func}ms(NOW,
All,
We have a dateImported field in our schema.
I'd like to generate a statistic showing the median dateImported (actually we
want median age of the documents, based on the dateImported value).
I have other stats that calculate the median value of numbers (like price).
This was achieved with
