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,
importDate)=true={!stats=piv1 }status
I hope this helps someone else :) Also, let me know if there's a better way to
do this.
Cheers,
Jim
On Tuesday, May 1, 2018 03:27:10 PM PDT, Jim Freeby
wrote:
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 something like:
rows=0=true={!tag=piv1
percentiles='50'}price=true={!stats=piv1 }status
I have not found a way to calculate the median dateImported. The mean works,
but we need median.
Any help would be appreciated?
Cheers,
Jim