# Google Charts with data from Elasticsearch? **URL:** \ **Category:** Elasticsearch\ **Created:** [April 1, 2013, 9:22pm UTC](https://discuss.elastic.co/t/google-charts-with-data-from-elasticsearch/11407 "2013-04-01T21:22:37Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![OffensivelyBad\_2](https://avatars.discourse-cdn.com/v4/letter/o/51bf81/32.png) [@OffensivelyBad\_2](https://discuss.elastic.co/u/OffensivelyBad_2)\ **Post date:** [April 1, 2013, 9:22pm UTC](https://discuss.elastic.co/t/google-charts-with-data-from-elasticsearch/11407/1 "2013-04-01T21:22:37Z")
Let me preface this topic by saying that I'm a noob to Elasticsearch and Google Charts. I'm testing some visualizations utilizing Google Charts and up until this point I've been using: google.visualization.arrayToDataTable to use some sample data. My question is, how do I pull in data from an existing Elasticsearch server? Any information (the more the better) that can be provided on this would be appreciated immensely. -- 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). ---
**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\ **Post date:** [April 1, 2013, 10:11pm UTC](https://discuss.elastic.co/t/google-charts-with-data-from-elasticsearch/11407/2 "2013-04-01T22:11:28Z")
Have a look at scan and scroll: [http://www.elasticsearch.org/guide/reference/api/search/search-type/](http://www.elasticsearch.org/guide/reference/api/search/search-type/) Is it what you are looking for? -- David 😉 Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs Le 1 avr. 2013 à 23:22, OffensivelyBad [shawnroller10@gmail.com](mailto:shawnroller10@gmail.com) a écrit : Let me preface this topic by saying that I'm a noob to Elasticsearch and Google Charts. I'm testing some visualizations utilizing Google Charts and up until this point I've been using: google.visualization.arrayToDataTable to use some sample data. ## My question is, how do I pull in data from an existing Elasticsearch server? Any information (the more the better) that can be provided on this would be appreciated immensely. 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). -- 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). ---
**Author:** ![otisg](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/otisg/32/492_2.png) [@otisg](https://discuss.elastic.co/u/otisg)\ **Post date:** [April 2, 2013, 3:34am UTC](https://discuss.elastic.co/t/google-charts-with-data-from-elasticsearch/11407/3 "2013-04-02T03:34:40Z")
Hi, You want to lok at Dangle: [http://www.fullscale.co/dangle/](http://www.fullscale.co/dangle/) ## Otis ELASTICSEARCH Performance Monitoring - [Sematext Monitoring | Infrastructure Monitoring Service](http://sematext.com/spm/index.html) On Monday, April 1, 2013 5:22:37 PM UTC-4, OffensivelyBad wrote: > Let me preface this topic by saying that I'm a noob to Elasticsearch and > Google Charts. > > I'm testing some visualizations utilizing Google Charts and up until this > point I've been using: > google.visualization.arrayToDataTable > to use some sample data. > > My question is, how do I pull in data from an existing Elasticsearch > server? Any information (the more the better) that can be provided on this > would be appreciated immensely. -- 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). ---
**Author:** ![OffensivelyBad\_2](https://avatars.discourse-cdn.com/v4/letter/o/51bf81/32.png) [@OffensivelyBad\_2](https://discuss.elastic.co/u/OffensivelyBad_2)\ **Post date:** [April 2, 2013, 3:34pm UTC](https://discuss.elastic.co/t/google-charts-with-data-from-elasticsearch/11407/4 "2013-04-02T15:34:56Z")
David, I'm not sure that link helps me with pulling data from Elasticsearch into chart. Otis, Dangle.js looks like a great tool, however the documentation is fairly limited. I'm new to most of this and Google Charts seemed to make things very simple and intuitive. I see that Charts can pull in JSON documents for the data source, however I'm wondering how I would run a query against Elasticsearch to retrieve a document that would be used as the data source. Also, it would be great if it had the capability to select the report parameters (ex. date range for the Elasticsearch query) and then generate the chart from the returned data. On Monday, April 1, 2013 5:22:37 PM UTC-4, OffensivelyBad wrote: > Let me preface this topic by saying that I'm a noob to Elasticsearch and > Google Charts. > > I'm testing some visualizations utilizing Google Charts and up until this > point I've been using: > google.visualization.arrayToDataTable > to use some sample data. > > My question is, how do I pull in data from an existing Elasticsearch > server? Any information (the more the better) that can be provided on this > would be appreciated immensely. -- 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). ---
**Author:** ![egaumer](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/egaumer/32/2365_2.png) [@egaumer](https://discuss.elastic.co/u/egaumer)\ **Post date:** [April 3, 2013, 12:31am UTC](https://discuss.elastic.co/t/google-charts-with-data-from-elasticsearch/11407/5 "2013-04-03T00:31:41Z")
Have a look at this blog series which will help explain how to marshall data to/from elasticsearch using JavaScript. [http://www.fullscale.co/blog/2013/02/28/getting\_started\_with\_elasticsearch\_and\_AngularJS\_searching.html](http://www.fullscale.co/blog/2013/02/28/getting_started_with_elasticsearch_and_AngularJS_searching.html) [http://www.fullscale.co/blog/2013/03/07/getting\_started\_with\_elasticsearch\_and-AngularJS\_faceting.html](http://www.fullscale.co/blog/2013/03/07/getting_started_with_elasticsearch_and-AngularJS_faceting.html) [http://www.fullscale.co/blog/2013/03/20/getting\_started\_with\_elasticsearch\_and\_AngularJS\_d3.html](http://www.fullscale.co/blog/2013/03/20/getting_started_with_elasticsearch_and_AngularJS_d3.html) -Eric On Tuesday, April 2, 2013 11:34:56 AM UTC-4, OffensivelyBad wrote: > David, I'm not sure that link helps me with pulling data from > Elasticsearch into chart. > > Otis, Dangle.js looks like a great tool, however the documentation is > fairly limited. I'm new to most of this and Google Charts seemed to make > things very simple and intuitive. > > I see that Charts can pull in JSON documents for the data source, however > I'm wondering how I would run a query against Elasticsearch to retrieve a > document that would be used as the data source. > > Also, it would be great if it had the capability to select the report > parameters (ex. date range for the Elasticsearch query) and then generate > the chart from the returned data. > > On Monday, April 1, 2013 5:22:37 PM UTC-4, OffensivelyBad wrote: > > > Let me preface this topic by saying that I'm a noob to Elasticsearch and > > Google Charts. > > > > I'm testing some visualizations utilizing Google Charts and up until this > > point I've been using: > > google.visualization.arrayToDataTable > > to use some sample data. > > > > My question is, how do I pull in data from an existing Elasticsearch > > server? Any information (the more the better) that can be provided on this > > would be appreciated immensely. -- 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). ---
**Author:** ![polyfractal](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/polyfractal/32/48162_2.png) [@polyfractal](https://discuss.elastic.co/u/polyfractal)\ **Post date:** [April 3, 2013, 12:36pm UTC](https://discuss.elastic.co/t/google-charts-with-data-from-elasticsearch/11407/6 "2013-04-03T12:36:16Z")
The SegmentSpy plugin[https://github.com/polyfractal/elasticsearch-segmentspy](https://github.com/polyfractal/elasticsearch-segmentspy)uses Google Charts to create bar charts, so you could take a look at the source to see how things are working. That said, I wouldn't recommend using Google Charts for anything except the simplest visualizations. I quickly ran into limitations and had to perform some quirky hacks to get things to work (can't easily do multiple bar colors, stacked charts only use log scale for the bottom bar, etc). Dangle + elastic.js is a lot more robust. -Zach On Monday, April 1, 2013 5:22:37 PM UTC-4, OffensivelyBad wrote: > Let me preface this topic by saying that I'm a noob to Elasticsearch and > Google Charts. > > I'm testing some visualizations utilizing Google Charts and up until this > point I've been using: > google.visualization.arrayToDataTable > to use some sample data. > > My question is, how do I pull in data from an existing Elasticsearch > server? Any information (the more the better) that can be provided on this > would be appreciated immensely. -- 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). ---
**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:43am UTC](https://discuss.elastic.co/t/google-charts-with-data-from-elasticsearch/11407/7 "2017-07-06T02:43:04Z")