Create

[Raju.Chavan (Rajesh Chavan)]

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, p3

|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|

[Raju.Chavan (Rajesh Chavan)]

I want similar graph.

[warkolm (Mark Walkom)]

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

[Raju.Chavan (Rajesh Chavan)]

@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.