script

[QSense]

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)

[anbu1984]

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

[QSense]

It didnt work unfortunately

[ashfaq_haseeb]

Try like this

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

Regards

ASHFAQ

[QSense]

It didnt work unfortunately

[ashfaq_haseeb]

Can you post your sample application to look at.

Regards

ASHFAQ

[anbu1984]

Can you post sample app

[QSense]

It's data big volume I can not share unfortunately

[ashfaq_haseeb]

Hi,

Go through this post

Preparing examples for Upload - Reduction and Data Scrambling

Regards

ASHFAQ

[maxgro]

put your expression in a chart (no dimension, just an expression)

remove label

hover the mouse over the label and look at the popup with your expression, you should see the date instead of the function; compare the format of the date with ANSWERTIME in a listbox, or post the screen (popup and listbox)