How to get the metrics of daily open tickets count from open and closed date and create bar chart


#1

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?


Follow-up: metrics of daily open count from open and closed date and create bar chart
(Tim Roes) #2

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


(system) #3

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