Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello ,
I have an issue and curious about this.
I want to make set analysis like that ı have date column(A) and ı would like to find last day of this date column
It look like that
sum(A>max(A)-1 <A<max(A) > B)
Sum({$<ANSWERTIME={">=$(Timestamp(max(ANSWERTIME)-1,'DD/MM/YYYY hh:mm:ss TT')) <$(=Timestamp(max(ANSWERTIME),'DD/MM/YYYY hh:mm:ss TT'))">} CALL_AMOUNT)
This is my statement.
I can not solve with document you sent
Attach Sample data.
Or contact me
My skypeID: ashfaqhaseeb
Regards
ASHFAQ
put the expression in variables and try again
there is an equal sign missing by the way :
Sum({$<ANSWERTIME={">=$(=Timestamp(max(ANSWERTIME)-1,'DD/MM/YYYY hh:mm:ss TT')) <$(=Timestamp(max(ANSWERTIME),'DD/MM/YYYY hh:mm:ss TT'))">} CALL_AMOUNT)