Average unique count


#1

Hi,

Is it possible to have the average of unique count of a string field?

For example :
In the document , there is a filed which contains name of store.
I want to have the average number of unique store per hour of day over a complete period.
I know it is possible to have "Date Histogram" with "Hourly" interval but in this situation, I can just have number of unique store instead of average.

P.S : There is a scripted filed which contain " Hour Of Day" .

Regards,


(system) #2