Using Kibana3 to graph a trend, is it possible?


(Vincent Massol) #1

Hi guys,

We're using Kibana3 (latest version) in XWiki
(http://activeinstalls.xwiki.org/kibana/#/dashboard/elasticsearch/XWiki%20Installs)
to measure installs of XWiki. Every day a running XWiki instance will send
a ping to our ElasticSearch server thus allowing us to measure active
instances of XWiki in the wild.

I'm very new at Kibana and I'm having a hard time figuring out how to
display a graph of active installs over time. By active, I mean the count
of all installs received over a 2 days period. Thus I'd like to have a
graph over time of a count of installs of every 2 days.

Is this possible with Kibana?

FTR here's the data each install is pushing to our ES server:

{
"_index": "installs",
"_type": "install",
"_id": "24aa62b4-cf43-4996-b026-ad61f4671d26",
"_score": 1.9225419,
"_source": {
"distributionId": "org.xwiki.enterprise:xwiki-enterprise-web",
"formatVersion": "1.0",
"distributionVersion": "5.2",
"date": "2013-12-03T23:17:34.393Z",
"extensions": []
}
}

Thanks a lot for any pointer!
-Vincent

--
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.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/52324f75-f63c-4b75-8ff2-3f04f12626e8%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


(Binh Ly-2) #2

Sure, first Configure Dashboard (upper right gear), and make sure Index
settings point (cover) your index. Timepicker time field: date

Add a Histogram Panel to your dashboard. In the Panel settings:

Chart Value: count
Time Field: date
Auto Interval: uncheck
Interval: 2d

If it's not showing any data, click the i(nspect) icon on the panel to
debug the query sent to ES and check it to see if it is what you expect.

--
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.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/f05af6d5-5941-4aaf-ab42-15ed617cac56%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


(Vincent Massol) #3

Thanks but this will not day what I need. I need the sum of all 2 days
counts from the beginning (the whole period).

AFAIU there's no way of doing this and I need to compute that sum on the
client side...

Thanks
-Vincent

On Monday, March 24, 2014 4:28:05 PM UTC+1, Binh Ly wrote:

Sure, first Configure Dashboard (upper right gear), and make sure Index
settings point (cover) your index. Timepicker time field: date

Add a Histogram Panel to your dashboard. In the Panel settings:

Chart Value: count
Time Field: date
Auto Interval: uncheck
Interval: 2d

If it's not showing any data, click the i(nspect) icon on the panel to
debug the query sent to ES and check it to see if it is what you expect.

--
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.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/8808e601-1df6-4978-b447-70027e861d0b%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


(system) #4