calculate percentage of answered email in 3 days

[lmabroukf]

Hello, 

I have a problem with a chart I want to build.

My tracker is about information request emails. I want to have the percentage of emails to which we have answered in less than 3 days

I am using this expression to count the number of working days :

NetWorkDays("date of receipt", "reply date")

thank you for your help !

 

[dplr-rn]

in your script create a flag for this purpose

e.g.

if (NetWorkDays("date of receipt", "reply date")<=3,'1,0)  as QuickResponseFlag

use that flag for your percentage calculation

[lmabroukf]

Sorry, I am very new to this ! In what will the flag help for ? and what type of chart do I have to choose ? Thank you very much

[dplr-rn]

flag will help with calculations. basically it helps you identify if a call is answered within 3 days.

e.g. expression with setanalysis below will give you count of calls answered <= 3 days

count({<QuickResponseFlag={1}>} ID) 

expression for % answered <= 3 days

count({<QuickResponseFlag={1}>} ID) /count(ID) 

[lmabroukf]

Great thank you for everything !

[lmabroukf]

I found another solution to this problem if anyone has the same one:

100*Sum(Aggr(If(NetWorkDays("date of receipt", "reply date") <= 3, 1, 0), [id]))/
Count([reply date])

[dplr-rn]

@lmabroukf  your solution will work but i would recommend the script approach.

because

1- if statements are slow compared with set analysis

2- aggr though very powerful is also resource intensive

so if there is a way to do with flags and/or with set analysis that should be the way to do it.

close the thread by marking  as answered