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 ?