set analysis script

QSense — Tue, 30 Sep 2014 09:47:01 GMT

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)

Re: set analysis script

QSense — Thu, 02 Oct 2014 12:43:14 GMT

=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.