# Using coordinates, summarizing numeric field in different docs, regional granularities, regional graphs, etc

**URL:** <https://discuss.elastic.co/t/using-coordinates-summarizing-numeric-field-in-different-docs-regional-granularities-regional-graphs-etc/14204>\
**Category:** Elasticsearch\
**Created:** [October 31, 2013, 9:45pm UTC](https://discuss.elastic.co/t/using-coordinates-summarizing-numeric-field-in-different-docs-regional-granularities-regional-graphs-etc/14204 "2013-10-31T21:45:38Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Dieter\_Plaetinck](https://avatars.discourse-cdn.com/v4/letter/d/eada6e/32.png) [@Dieter\_Plaetinck](https://discuss.elastic.co/u/Dieter_Plaetinck)\
**Post date:** [October 31, 2013, 9:45pm UTC](https://discuss.elastic.co/t/using-coordinates-summarizing-numeric-field-in-different-docs-regional-granularities-regional-graphs-etc/14204/1 "2013-10-31T21:45:38Z")

</div>

Hey all,  
I've been playing with elasticsearch and kibana for a few smaller projects  
and am quite satisfied,  
however now I want to do something a little more complicated so I'ld like  
to double check it is indeed possible.

imagine you run a website, and users are uploading content all the time,  
from anywhere in the world, to one of your few datacenters.  
for every finished upload, lets log a document with the following fields:

- datetime of upload
- coordinates
- datacenter\_key (string with about 10 possible values)
- upload\_speed (numeric)

Can we do the following?:

- See on a map how the average upload speed differs geographically, by  
using data of (say) the last 24h or the last week (and averaging the  
upload\_speed value over all those documents! not just counting how many  
documents)  
Can we use the coordinates data to automatically divide into regions  
(they don't have to map to political regions) or is it mandatory to use a  
country/state code?  
Also, is it possible to add the regions together and see a more high  
level overview of the map? (say north america, south america, africa,  
europe, etc etc)

- let's say I want to see how the above evolves over time, so I want to see  
a graph that tells me how the average upload speed (calculated over all  
docs) evolved over time. We should be able to do this:

- get a graph per datacenter key how the average upload speed evolves over  
time.

- Everything above, but upper 90th percentile instead of average.

thanks!  
Dieter

--  
You received this message because you are subscribed to the Google Groups "elasticsearch" group.  
To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com).  
For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out).

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [July 6, 2017, 2:09am UTC](https://discuss.elastic.co/t/using-coordinates-summarizing-numeric-field-in-different-docs-regional-granularities-regional-graphs-etc/14204/2 "2017-07-06T02:09:31Z")

</div>

Closed on July 6, 2017, 2:09am UTC