Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
Please suggest as what is causing the problems in the below expression where im trying the caluclate the count of all till prev date(excluding few types[Status Desc]) + the current date (excluding few types[Status Desc])
fabs
(count({$<STATUS_DESC-={'Resolved','Standby provided','Cancelled','Under Observation'},REGION={'EAST','WN-EAST'},
INCIDENT_DATE={"=$(=date(daystart((INCIDENT_DATE))))+(>=$(=daystart(MAX(INCIDENT_DATE))))"}>}IN_INCIDENT_NO))
INCIDENT_DATE format is MMDDYYYYHHMMSS
Please help by suggesting your thoughts of improments in the above exp...
Thanks,
Hassan
Hi,
Try this
(count({$<STATUS_DESC-={'Resolved','Standby provided','Cancelled','Under Observation'},REGION={'EAST','WN-EAST'},
INCIDENT_DATE={"=$(=date(daystart([INCIDENT_DATE])))+(>=$(=daystart(MAX([INCIDENT_DATE]))))"}>}IN_INCIDENT_NO))
Try This...........
count({$<STATUS_DESC={"*"}-{'Resolved','Standby provided','Cancelled','Under Observation'},REGION={'EAST','WN-EAST'},
INCIDENT_DATE={">=$(=Date(daystart(vMaxDate)))<=$(=Date(floor(DayEnd(vMaxDate))))"}>}IN_INCIDENT_NO))
vMaxDate=Date(max(INCIDENT_DATE),'MMDDYYYYHHMMSS')
not helping...please correct if there is some problem in the below expression...
fabs
(count({$<STATUS_DESC={'*'}-{'Resolved','Standby provided','Cancelled','Under Observation'},REGION={'EAST','WN-EAST'},
INCIDENT_DATE={"=$(=DATE(daystart(max(INCIDENT_DATE))-1,'MMDDYYYYHHMMSS'))"}>}IN_INCIDENT_NO))
any advises??please suggest
Explain what INCIDENT_DATE={"=$(=date(daystart((INCIDENT_DATE))))+(>=$(=daystart(MAX(INCIDENT_DATE))))"} is supposed to mean. And post a sample document with some data that should be used for the calculations and also show what the result should be.