Hi

[#1]

I have the following data with 3 fields, i want to find number of opened tickets which are not closed.

.And also i need to provide filters for year,quarter,month,week.could any one guide me how can i do this.

thanks

soujanya

[ashfaq_haseeb · Accepted solution]

Hi,

Try something like this.

=count(TicketId)-count({$<closeddate ={'*'}>} TicketId)

Regards

ASHFAQ

[#3]

Hi Ashfaq,

Thanks for your quick reply. Its working.

[Anonymous]

Hello Soujanya,

For future posts please be sure to put the question or main issue in the subject line instead of 'Hi' for additional tips see  Getting Started: Questions and Discussion Threads

Best Regards, Sara

[#5]

Thank you Sara for correcting me.Sure from next time i will follow this.