Histogram aggregation?


(Steve Suh) #1

Hi,
I have a phone number as one of my fields. Is it possible to bucket by the area code? Do I have to make that a separate field in the document ahead of time or can I calculate the area code from the phone number field and make that the bucket.


(Lee Drengenberg) #2

Hi Steve,
I'm pretty sure you would have to make that a separate field in the documents.

The only exception way I could think of without that, is if the phone number were a number data type you could possibly create a scripted field named area_code with a script like doc['phone_number'].value / 10000000. That might possibly truncate the number to just the first 3 digits. But phone numbers often are string types and scripted fields only work on numbers.

Regards,
Lee


(system) #3