report displaying numbers of tickets created per hour

[julio valdez]

Hi,

Is there a way to display how many tickets are received each hour of the day? We do have 'datamart' available though I have not used it.  

Thanks in advance,

~JV

[Thomas Deiler · Accepted solution]

Dear @julio valdez ,

have a look at the Recently Created Issues Report. This shows how many issues are created per hour/day/month + how many got resolved.

So long

Thomas

[julio valdez]

Hi @Thomas Deiler , I've looked at that but it's something I can present to upper management.  I'd like something cleaner etc

Thanks

[Thomas Deiler]

Dear @julio valdez ,

then you have to look for market place apps, that fulfill your requirements or you create your graphics on your own. Either by CSV export or with REST API queries.

So long

Thomas

[julio valdez]

Hi @Thomas Deiler , I like the idea of a report by CSV export. Is there a quick tutorial on how to go about this?  Thanks

[Thomas Deiler]

Dear @julio valdez ,

That's quite simple:

1. use your favorite filter or search for issues.
2. on the result click upper right area on 'Export - > CSV'

The data can be processed with other tools. Apart from Excel have a look at Gnuplot. A good tutorial is here.

With a little bit of scripting, you could read the filter results with the REST API (GET /rest/api/2/search), extract the relevant data from JSON response and process it with gnuplot. Then the result (PDF) can be shared by mail. The script could be triggered by cron eg. daily. Then it is fully automated. All you need is open source - no plugin will be required.

So long

Thomas

[Thomas Deiler]

Dear @julio valdez ,

don't forget to press the "green accept answer" button to indicate other readers the successful answering of your question.

So long
Thomas