Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
QSense
Creator II
Creator II

set analysis script

Hello,

I wrote a set analysis statement caluclates between max(answertime) -1 and max(answertime)

but ıi does not bring any values.

I am probably making mistake .

Could you help me

=sum({$<ANSWERTIME={">=$(date(max(ANSWERTIME)-1,'DD.MM.YYYY 00:00:00')) <$(=date(max(ANSWERTIME),'DD.MM.YYYY 00:00:00'))"}>}CALL_AMOUNT)

1 Reply
QSense
Creator II
Creator II
Author

=sum({$<ANSWERTIME={">$(=date(max(ANSWERTIME)-10,'DD.MM.YYYY hh:mm:ss')) <=$(=date(max(ANSWERTIME),'DD.MM.YYYY hh:mm:ss'))"}>}CALL_AMOUNT)

this is true.