Get time accounted and total number of tickets per client from last month

[jdelvecchio]

Hello,
I'm trying to get total time accounted and the total number of tickets per client of the last month.
What I've tried :

Create a TicketAccountedTime stat :
X-axis :
-CustomerID (I chose a few clients, lets say CLIENT1 to CLIENT4)

Value Series :
-none

Restrictions :
-Evaluation by Total Time, Number of Tickets
-Queue : MyQueue
-Ticket Create Time : The last 1 month

Result of this is A CSV file of the type :

ClientList TicketAccountedTimes
CLIENT1 0 (Total Time), 0 (Number of Tickets),
CLIENT2 0 (Total Time), 0 (Number of Tickets),
CLIENT3 0 (Total Time), 0 (Number of Tickets),
CLIENT4 405 (Total Time), 1 (Number of Tickets),

But when I do a research with the web interface, with CustomerID=CLIENT1 and Ticket Create Time = Last 1 month
I get tons of tickets.

Seems like the stats module is very clunky, I can't really rely on it.
Is there another way to get the information I need ?

Thanks in Advance,

Jdelvecchio.

[RStraub]

When you enter "the last month" in stats, it takes all tickets that were created in the month BEFORE the current month. If you do a search however it does the absolute value from NOW.

Try changing the 1 month to 30 days or 5 weeks to get a more precise result.

[jdelvecchio]

I see, thanks RStraub
Tried with 30 days, result is still the same, 0 tickets

[RStraub]

Well, you can always use your ticket search and select "Output -> CSV" in the popup.