Tickets reaching 5 days

[#1]

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

[miguelbraga]

Hey Hasvine

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

Regards,

MB

[#3]

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

[MK_QSL]

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)

[MK_QSL · Accepted solution]

Create a Flag in your Script..

Date(Today())- Date_created as Flag

Now use below expression

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

[Anonymous]

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

[#7]

Thank you. It works. 🙂