Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Try something like this.
=count(TicketId)-count({$<closeddate ={'*'}>} TicketId)
Regards
ASHFAQ
Hi,
Try something like this.
=count(TicketId)-count({$<closeddate ={'*'}>} TicketId)
Regards
ASHFAQ
Hi Ashfaq,
Thanks for your quick reply. Its working.
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
Thank you Sara for correcting me.Sure from next time i will follow this.