count the value between date range

[settu_periasamy]

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.

[senpradip007]

PFA. hope it will help.

[settu_periasamy]

thanks pradip. is it possible to do this, without adding date field in the script?

[jagan · Accepted solution]

Hi,

Try this expression

Count({<Call_date = {">=$(TimeStamp(start))<=$(TimeStamp(end))"}>} CallID)

Regards,

Jagan.

[settu_periasamy]

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)