Advanced Reporting

[snifty]

Script URL: internal
Version of script: 2.5.0
Hosting company: HIS
URL of phpinfo.php:
URL of session_test.php:
What terms did you try when SEARCHING for a solution: reporting

Write your message below:
I like the way the reports are shown in 'Tickets per day' and 'Tickets per month'. The useful columns for us are the open and closed tickets.
What I'm missing are those colums in the 'Tickets per user' and 'Tickets per category'.
Does somebody know how to implement that?

Thanks in advance!

PS: I just saw that it is the same as here: viewtopic.php?f=13&t=3366&p=14385 But it seems it is not implemented yet.

Please help!

[Klemen]

While some advanced reports may be added to HESK, probably not many as it goes against it's policy of being a simple a fast script.

With 2.5.0 you can export tickets and open the exported XML file in Excel - that will allow you to do advanced reports locally on your computer without putting stress on the server.

[snifty]

Hi Klemen!
I understand your thoughts to keep it fast and simple and I must say that the export ist pretty cool and detailed.
But in my case we don't have that much users/ticktes in the system so performance is not an obstacle.
To run an export each time just to see which user has how many open/resolved tickets is to cumbersome because I have to grab the details from that afterwards as well.
It would be nice to have that information with just one click...

I would be thankful if you could provide me (and others) the right sql statment, the php-implementation I can do on my own. For sure I would publish the final solution for all others (if you allow this).

Best regards!

[Klemen]

Sorry, but I don't have the statements ready.

I will see if I can implement them in the future (need to figure it out and test on large databases), until then you will probably need to hire someone to help with the logic.

[snifty]

Thank you, I appreciate that very much.
I will see what I can do meanwhile.

[snifty]

I sincerely thank you very very much!
Just before I wanted to figure it out myself I saw that you released Version 2.5.1 where that feature I'm asking for was implemented!
I'm sure you helped a lot of other useres as well and made this amazing program even more powerful than it already is! *thumbs up*

[Klemen]

You are welcome - it turned out it wasn't hard to implement and didn't require any language file changes, so I added it to 2.5.1