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
employeesfield
- add "dot size" metric
- use unique count aggregation
- on
companyfield
- add "split lines" bucket
- use terms aggregation
- on
industryfield - i set size close cardinality of data
- add "x-axis"
- use histogram aggregation
- on
revenuefield - guess interval, need play bit
- finally, click apply
this configuration pretty complex, resulting visualization shows lot of information.

Comments
Post a Comment