Problems with statistics: Wrong tickets amount, and "Staff" section only shows me

molul

PROBLEM 1: Wrong tickets amount.When I go to Dashboard->Department, I see 50 opened tickets since the system was installed two weeks ago. This is not true, and it seems it's counting the tickets I created in the testing before making the osTicket installation public. But I did delete all of them and I even went to phpmyadmin and deleted all ticket_event entries, as it was suggested in a non-official osticket page. Too bad I didn't check the numbers were 0 when opening the system to the customers.QUESTION: is there any way to manually set the right values so the statistics can go on from there?PROBLEM 2: "By staff" tab only shows meSo far there are 19 closed tickets assigned to different people. However, the statistics only show me in the "By staff" tab. I was thinking that it might be due to me closing the tickets, but some were not closed by me, so it shouldn't be that. Has anyone experienced the same problem? About problem 2, it seems everyone at the company only see themselves in the "Staff" tab. Not what I expected, but maybe it was programmed like that.

Mart

Hi, I'm seeing odd things in Statistics also.v1.8.1.2When logged in as an admin I'd expect to see all staff members tickets on the staff tab. Instead I only see 2 out of the 5. Even though the missing ones have tickets in their queue.Also, actually let me ask more more applicable question. Am I able to find any user documentation anywhere? Shortly I'll be training users on the use and admin of this software, but I can't see anything on the osTicket site, and the wiki is pretty bare.Some of my questions around "expected behaviour" might be answered there.For example. I have a department with 2 open tickets. Under statistics on the dashboard that department only shows 1. Perhaps I am missing something somewhere.....That might be found in user docs :) )

ntozier

No offense to the devs, but the Dashboard is... insufficient. I think that's the polite way to put it. My uderstanding is that there is a revamp planned for it at some point (probably circa 2.0). I personally ignore it's existence as much as I can.

johnweidauer

To remove the "test" data, or the deleted data from the dashboard, you can execute this query in mysql:DELETE FROM ost_ticket_event where ticket_id not in (SELECT ticket_id FROM ost_ticket);I have done this on my system and I have not noticed any issues as a result, v1.8.1.2To the topic of not seeing all tickets, could it be that the not all teams have been assigned to the logged in user? Staff - Staff Members, Edit the user, scroll down to Assigned Teams section?