SELECT FLOOR(UNIX_TIMESTAMP(dateField)) as time_sec, count(*) as value, 'No. of Requests' as metric FROM table WHERE $__timeFilter(dateField) GROUP BY dateField ORDER BY dateField ASC
The above mysql query i want to see in time series visualization , I am able to see the output in seconds (I mean No. of requests per second). But I want the number of requests in a minute , how to use group by clause with $__timeGroup(dateField,‘1m’)?? Can anyone help me how to group by in mysql please?