Hi Aneela,
At glace, there's some issues with your query. Is there a particular reason
for you to use `group by milliseconds`? otherwise you shouldn't be group by
such rapidly changing variable. And also, the count aggregate function
does not require any parameters and it does not have to be
Hi,
I have been using following siddhi query to get the events count per minute;
ts as timestamp (string) and ftp_requests as count (int)
from FTPInStream[command == 'USER']
select time:timestampInMilliseconds(time:dateAdd(str:replaceAll(ts,'T',' '), 5,
'hour',"-MM-dd