Create

Data sets already in kibana index pattern.

I want build graph lile as follows using following data. its already created index in kibana

Please help me out only how to create graph.

  1. second column is day wise date but * i want its as month wise on x
  2. Incident Id column as count
  3. Priority column as bar. p1, p2, p3image

|Incident ID|Open Date|Priority|

|Ticket NA|26-Jun-18|Ticket NA|
| INC189984|26-Jun-18|P2|
| INC190142|26-Jun-18|P2|
|INC188047 |18-Jun-18|P1|
|INC186980 |14-Jun-18|P2|
|INC186440 |12-Jun-18|P2|
|INC185010 |7-Jun-18|P1|
|INC184638 |6-Jun-18|P1|
|INC184199 |4-Jun-18|P2|
|INC183786|3-Jun-18|P2|
|INC182775|30-May-18|P2|
|INC177080|8-May-18|P2|
|INC174778|28-Apr-18|P2|
|INC174430|26-Apr-18|P3|
|INC173422|23-Apr-18|P3|
|INC172811|21-Apr-18|P3|
|INC172846|21-Apr-18|P1|
|INC171262|17-Apr-18|P1|
|INC171036|16-Apr-18|P2|
|INC170829 |15-Apr-18|P3|
|INC170392|13-Apr-18|P2|
|INC170382|13-Apr-18|P2|
|INC169994|12-Apr-18|P2|
|INC169416|10-Apr-18|P3|
|INC168762|9-Apr-18|P1|
|INC168447|7-Apr-18|P2|
|INC168370 |6-Apr-18|P2|
|INC168112|6-Apr-18|P1|
|INC167704|5-Apr-18|P1|
|INC167763|5-Apr-18|P3|
|INC166877|3-Apr-18|P2|
|INC166825|2-Apr-18|P3|

image

I want similar graph.

Create a date histogram aggregation as the X axis, with a terms sub aggregation, then Y axis as a count aggregation.

@warkkolm
I want to take "priority" column as bars like P1,p2 ,p3 and month wise also or similar graph as above mention in image.

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.