6 Replies Latest reply: Jan 22, 2016 12:18 AM by Hasvine Dhurmea

Tickets reaching 5 days

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

• Re: Tickets reaching 5 days

Hey Hasvine

Can you please share with us na exemple of what you want to do? Not sure I understood your issue.

Regards,

MB

• Re: Tickets reaching 5 days

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

• Re: Tickets reaching 5 days

Create a Flag in your Script..

Date(Today())- Date_created as Flag

Now use below expression

=COUNT({<Flag = {">=5"}>}DISTINCT Ticket_num)

• Re: Tickets reaching 5 days

Thank you. It works. :-)

• Re: Tickets reaching 5 days

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)

• Re: Tickets reaching 5 days

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