# Line chart with two date count lines for use with ServiceNow incident data

**URL:** <https://discuss.elastic.co/t/line-chart-with-two-date-count-lines-for-use-with-servicenow-incident-data/260735>\
**Category:** Kibana\
**Created:** [January 11, 2021, 3:11pm UTC](https://discuss.elastic.co/t/line-chart-with-two-date-count-lines-for-use-with-servicenow-incident-data/260735 "2021-01-11T15:11:50Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![ykara84](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ykara84/32/106391_2.png) [@ykara84](https://discuss.elastic.co/u/ykara84)\
**Post date:** [January 11, 2021, 3:11pm UTC](https://discuss.elastic.co/t/line-chart-with-two-date-count-lines-for-use-with-servicenow-incident-data/260735/1 "2021-01-11T15:11:50Z")

</div>

Hi, I have ServiceNow incident data in an index and I would like to visualise the the trend of opened and resolved tickets on a per day basis. I can do it in separate visualisations but I cant figure out how to **combine** into one visualisation, so both lines appear in one chart. I've also tried a TSVB but cant seem to combine it into one. Below are the ones ive done separately

Incident opened at:

 ![opened_at](https://us1.discourse-cdn.com/elastic/original/3X/5/f/5ffa9b36459194a2cfbe9bef2a5d152eaa406301.png)

Incident resolved at:

 ![resolved_at](https://us1.discourse-cdn.com/elastic/original/3X/d/1/d1254e87e443affbd48a31e06011d796420ac762.png)

---

<div class="post-metadata">

**Author:** ![flash1293](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/flash1293/32/41227_2.png) [@flash1293](https://discuss.elastic.co/u/flash1293)\
**Post date:** [January 11, 2021, 3:51pm UTC](https://discuss.elastic.co/t/line-chart-with-two-date-count-lines-for-use-with-servicenow-incident-data/260735/2 "2021-01-11T15:51:56Z")

</div>

You should be able to do this in Lens by adding an additional "layer". For the first layer you can do a date histogram on field1, for the second layer on field2:

 ![Screenshot 2021-01-11 at 16.51.02](https://us1.discourse-cdn.com/elastic/original/3X/7/d/7df6b7eb0085f4a83c0c5ebe35ee5e615a8e52de.png)

---

<div class="post-metadata">

**Author:** ![ykara84](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ykara84/32/106391_2.png) [@ykara84](https://discuss.elastic.co/u/ykara84)\
**Post date:** [January 12, 2021, 11:06am UTC](https://discuss.elastic.co/t/line-chart-with-two-date-count-lines-for-use-with-servicenow-incident-data/260735/3 "2021-01-12T11:06:00Z")

</div>

thanks, looks like that does the job

---

<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:** [February 9, 2021, 11:06am UTC](https://discuss.elastic.co/t/line-chart-with-two-date-count-lines-for-use-with-servicenow-incident-data/260735/4 "2021-02-09T11:06:03Z")

</div>

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