>
> 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 <cryth...@gmail.com>
> Subject: Re: [otrs] otrs statistics about carried forward tickets for
> a day
> To: "User questions and discussions about OTRS." <otrs@otrs.org>
> Message-ID:
> <cakk-oujfdwfbfyh--xd1bkrdqjdffzergpjdk2bgt3kyxmg...@mail.gmail.com>
> 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
> <darshak.m...@elitecore.com>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.
------------------------------------
---------------------------------------------------------------------
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
