Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
i have the field CallID and Call_date (this is date with time format). I need to show the count based start and end date.
see the below screen shot.
Just i want to show, call_date(date only) and count of CallID based on the date. sample is attached.
Hi,
Try this expression
Count({<Call_date = {">=$(TimeStamp(start))<=$(TimeStamp(end))"}>} CallID)
Regards,
Jagan.
PFA. hope it will help.
thanks pradip. is it possible to do this, without adding date field in the script?
Hi,
Try this expression
Count({<Call_date = {">=$(TimeStamp(start))<=$(TimeStamp(end))"}>} CallID)
Regards,
Jagan.
Thank you Jagan. Just i have add the "=" infront of Timestamp. Now it is working.
final expression is Count({<Call_date = {">=$(=TimeStamp(start))<=$(=TimeStamp(end))"}>} CallID)