Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I need to calculate the amount of tickets which are still after 5 days.
Can it be done by using set analysis?
Thanks,
Hasvine
Create a Flag in your Script..
Date(Today())- Date_created as Flag
Now use below expression
=COUNT({<Flag = {">=5"}>}DISTINCT Ticket_num)
Hey Hasvine
Can you please share with us na exemple of what you want to do? Not sure I understood your issue.
Regards,
MB
Hi Miguel,
Actually, I have a calculate how many tickets have not been closed after the 5 days of work.
Example:
Ticket_num Date_created
1 05/01/2016
2 10/01/2016
3 20/01/2016
4 19/01/2016
5 15/01/2016
6 12/01/2016
I need an expression to calculate how many tickets have exceeded the 5 day on a daily basis.
Any idea...
Many Thanks,
Hasvine
May be something like below...
SUM({<TicketNo = {"=(Date(Today()) - TicketDate>=5"}>}Amount)
or If you don't want to change script..
use directly below expression
=COUNT({<Ticket_num = {"=Date(Today())- Date_created >=5"}>}DISTINCT Ticket_num)
Create a Flag in your Script..
Date(Today())- Date_created as Flag
Now use below expression
=COUNT({<Flag = {">=5"}>}DISTINCT Ticket_num)
may be something like this?
=count({<TicketDate=,Status={'Still'}, TicketDate={'>=$(=Date(max(TicketDate)-5,'DateFormat'))<=$(=date(max(TicketDate),'DateFormat'))>} distinct TicketID)
Make Sure DateFormat should be same as TicketDate Format
Thank you. It works. 🙂