elasticsearch - Is it possible to create an XY (aka scatter) plot using Kibana 4? -
i have few million documents in elasticsearch index numeric fields, foo
, bar
. there way use kibana 4 create graph foo
values on x axis , bar
values on y axis? very, basic chart 1 might create using excel.
i'm fine sampling/aggregations of kind. i understand these tools won't show me plot 20 million data points. i'm trying see if there's obvious relationship between foo
, bar
creating graph.
to plot correlation between revenue , employee count use line chart this:
in order justify creating scatter plot chart though (since they're awesome , wanted to) generated fake data looked this:
{ name: faker.company.companyname(), employees: _.random(3, 30), revenue: _.random(10000, 100000), industry: _.sample(industries) }
and plotted in visualize breaking down piece-by-piece:
- start line chart
- switch options tab of sidebar (since 4.1)
- uncheck "show connecting lines"
- check "scale y-axis data bounds"
- switch data tab
- modify "y-axis"
- use average aggregation
- on
employees
field
- add "dot size" metric
- use unique count aggregation
- on
company
field
- add "split lines" bucket
- use terms aggregation
- on
industry
field - i set size close cardinality of data
- add "x-axis"
- use histogram aggregation
- on
revenue
field - guess interval, need play bit
- finally, click apply
this configuration pretty complex, resulting visualization shows lot of information.
Comments
Post a Comment