# How to get the metrics of daily open tickets count from open and closed date and create bar chart
**URL:** https://discuss.elastic.co/t/how-to-get-the-metrics-of-daily-open-tickets-count-from-open-and-closed-date-and-create-bar-chart/121737
**Category:** Kibana
**Created:** [February 27, 2018, 9:16pm UTC](https://discuss.elastic.co/t/how-to-get-the-metrics-of-daily-open-tickets-count-from-open-and-closed-date-and-create-bar-chart/121737 "2018-02-27T21:16:29Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@narschang](https://discuss.elastic.co/u/narschang)
#### Post date: [February 27, 2018, 9:16pm UTC](https://discuss.elastic.co/t/how-to-get-the-metrics-of-daily-open-tickets-count-from-open-and-closed-date-and-create-bar-chart/121737/1 "2018-02-27T21:16:29Z")
Not sure if elasticsearch and kibana support this use case.
We have a DevOp ticket status dashboard to show the number of IT help desk tickets in the pipeline and the status of the ticket. I want to create a bar chart to show the number of open tickets daily and I am not sure how to do it.
DB configuration:
The index name is \_index:devop\_api\_mdn-% and the document id (\_id) is the helpdesk ticket ID. The data is updated hourly and the document of a specific ticket is updated every time when the status of the ticket changes. Since each ticket has an open date and close date (when it's closed), is there a way to get the number of open tickets daily based on the open and close dates? For example, if I have 10 tickets open and closed in January, can I get a date histogram chart to show the open ticket number? I created a chart to show the expected outcome.
I understand that this metrics can be achieved by configuring the index a different way, for example - differentiating the ingestion by having date stamp as part of the index name to keep a record of the daily open count. The issue here is that if we do it that way, we will end up have a lot of duplicated data in the system.
Based on how we configure the database and data points available, is there a way or other ways to create the visualization using the feature currently available in Kibana or any of the plug-ins?
---
### Author:  [@timroes](https://discuss.elastic.co/u/timroes)
#### Post date: [March 3, 2018, 6:45pm UTC](https://discuss.elastic.co/t/how-to-get-the-metrics-of-daily-open-tickets-count-from-open-and-closed-date-and-create-bar-chart/121737/2 "2018-03-03T18:45:52Z")
Hi,
sorry first for the late response. Due to Elastic{ON} I couldn't have a look yet into this. I think you will actually be able to solve the requested chart within Timelion (and only there :D), but I would get back to you next week, since I need to play around a bit to figure out a solution, that will really work in all cases.
Thanks for your patience and sorry for the delay.
Cheers,
Tim
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [March 31, 2018, 6:46pm UTC](https://discuss.elastic.co/t/how-to-get-the-metrics-of-daily-open-tickets-count-from-open-and-closed-date-and-create-bar-chart/121737/3 "2018-03-31T18:46:00Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.