Use ticket_history table for your query.

I found this useful, but the OP was using the GUI ("I am generating using report tool")... Sadly I'm no help because I do all my reporting direct from PostgreSQL and am not very familiar with Statistics module...

Message: 3 Date: Thu, 6 Feb 2014 07:21:18 -0500 From: Gerald Young Subject: Re: [otrs] otrs statistics about carried forward tickets for a day To: "User questions and discussions about OTRS." Message-ID: Content-Type: text/plain; charset="iso-8859-1"

Use ticket_history table for your query.

On Thu, Feb 6, 2014 at 6:29 AM, Darshak Modi wrote:

...

hi, we want find how many tickets created in a day [ new ], how many are worked upon [ closed ] and if any tickets remain opened. I am generating using report tool. But all tickets that are closed , come only in closed state, and not in new state.

it is difficult to know how many actually created , closed and carried forward if any . I get report like below State Type Thu 30 Fri 31 closed 14 16 new 1 0 open 0 0 Sum 15 16

Here it should come like new is 15, closed 14, open 1. Is that possible ?

--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs

Mike Morris The Music Place 1617 Willowhurst Avenue San Jose, CA 95125 (408) 445-ARTS (2787) ------------------------------------ Your Random Historical Quote: The subjects of its [the Senate's] jurisdiction [on impeachment] are those offenses which proceed from the misconduct of public men, or, in other words, from the abuse or violation of some public trust. They are of a nature which may with peculiar propriety be denominated political, as they relate chiefly to injuries done immediately to the society itself. - James Madison, The Federalist Papers, No. 65. ------------------------------------