# Create

**URL:** <https://discuss.elastic.co/t/create/139918>\
**Category:** Kibana\
**Created:** [July 13, 2018, 10:06am UTC](https://discuss.elastic.co/t/create/139918 "2018-07-13T10:06:23Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Raju.Chavan](https://avatars.discourse-cdn.com/v4/letter/r/97f17d/32.png) [@Raju.Chavan](https://discuss.elastic.co/u/Raju.Chavan)\
**Post date:** [July 13, 2018, 10:06am UTC](https://discuss.elastic.co/t/create/139918/1 "2018-07-13T10:06:23Z")

</div>

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 ![image](https://us1.discourse-cdn.com/elastic/original/3X/2/2/221fae215276d6cc4dbc984f5c98ecc9bd984061.png)

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

---

<div class="post-metadata">

**Author:** ![Raju.Chavan](https://avatars.discourse-cdn.com/v4/letter/r/97f17d/32.png) [@Raju.Chavan](https://discuss.elastic.co/u/Raju.Chavan)\
**Post date:** [July 13, 2018, 10:09am UTC](https://discuss.elastic.co/t/create/139918/2 "2018-07-13T10:09:05Z")

</div>

![image](https://us1.discourse-cdn.com/elastic/original/3X/0/6/06e1be22e252686963f1ce7694fbb72771af621a.png)

I want similar graph.

---

<div class="post-metadata">

**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\
**Post date:** [July 13, 2018, 10:25am UTC](https://discuss.elastic.co/t/create/139918/3 "2018-07-13T10:25:52Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Raju.Chavan](https://avatars.discourse-cdn.com/v4/letter/r/97f17d/32.png) [@Raju.Chavan](https://discuss.elastic.co/u/Raju.Chavan)\
**Post date:** [July 13, 2018, 10:40am UTC](https://discuss.elastic.co/t/create/139918/4 "2018-07-13T10:40:28Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [August 10, 2018, 10:42am UTC](https://discuss.elastic.co/t/create/139918/5 "2018-08-10T10:42:38Z")

</div>

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