on a selected date range , how to find the following ?

[gauravgg]

hi

i have the following table

ID	Date	Ticket Type	Status
001	01-Jan-2016	A	open
002	02-Jan-2016	B	open
003	06-Jan-2016	A	open
001	05-Jan-2016	A	closed
006	01-Feb-2016	D	open
007	02-Mar-2016	B	open

on the selected date range in what

Number of "open" tickets ,

Number of "closed" ,

Number of tickets closed within month (ie ticket raised in a month is closed in the same month)

For example

form the above table , if i select 1-Jan-2016 to 30-Jan-2016

Number of open tickets:- 2

Number of closed tickets :- 1

Number of tickets closed within that month :- 1

i want to show in table and also in KPI

can anyone help me?

[lakshmikandh]

Number of "open" tickets , - count (distinct if(Match(Status,'Open'),ID))

Number of "closed" , - count (distinct if(Match(Status,'Closed'),ID))

Number of tickets closed within month (ie ticket raised in a month is closed in the same month)

sum(aggr (

if( interval( if(Match(Status,'Closed'),Date) - if(Match(Status,'Open'),Date) ,'D') <=30, 1 , 0),

ID))