Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
=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.