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:

simple line chart

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:

  1. start line chart
  2. switch options tab of sidebar (since 4.1)
    • uncheck "show connecting lines"
    • check "scale y-axis data bounds"
  3. switch data tab
  4. modify "y-axis"
    • use average aggregation
    • on employees field
  5. add "dot size" metric
    • use unique count aggregation
    • on company field
  6. add "split lines" bucket
    • use terms aggregation
    • on industry field
    • i set size close cardinality of data
  7. add "x-axis"
    • use histogram aggregation
    • on revenue field
    • guess interval, need play bit
  8. finally, click apply

this configuration pretty complex, resulting visualization shows lot of information.

scatter plot


Comments

Popular posts from this blog

java - Could not locate OpenAL library -

c++ - Delete matches in OpenCV (Keypoints and descriptors) -

sorting - opencl Bitonic sort with 64 bits keys -