>
> 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
> Subject: Re: [otrs] otrs
statistics about carried forward tickets for
> a day
> 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
>
> > 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
> > ?
> >
> >
---------------------------------------------------------------------
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
