Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 !
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
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
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)
Great thank you for everything !
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])
@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