Tickets updates met/ missed SLA

[0li5a3a]

Hello,

I need to produce a report with the Met and Missed SLA for a support team.

They need to update the tickets every 12 hours, 24 hours,  24 business hours and 7 business days by Severity to met the SLAs.

Severity 1 every 12 hours,

Severity 2 every 24 hours,

Severity 3 every 24 business hours,

Severity 4 every 7 business days.

I have a table which hold the last date and time when a ticket was updated, how  I can solve this problem in Qlikview?

Which functions I need to use to calculate this?

Thanks in advance!

[Chanty4u]

try this way

count({<Seviority={'1'}>}if(UpdatedDate=Date,[TicketNumber]))

like for all seviority's

[0li5a3a]

I need to calculate the difference between the time now and the time when the ticket had been last time updated. something like this:

[olivierrobin]

hello

you can use

now(1)- Date

but be aware of :

The time functions e.g. Now() and Today() will be evaluated whenever a recalculation is required.

Especially the Now() function can become quite costly since it causes a recalculation of the application

[0li5a3a]

I can do this only for 12h and 24h, I can't do this when I have 24 business hours or 7 business days.

thanks