I’m comparing “Actions” in widget"Visits by Server Time" with my query results on raw data.
This widget shows actions by hour and my query for actions by hour is as follows
server_time, ‘%H’) ‘Hour’, count(1)
server_time)=CURDATE() and idsite=25
GROUP BY DATE_FORMAT(
order by server_time desc
Now problem is that widget is showing more action than my query.
Can anyone please tell me that my query logic is correct or not? and where can I see widget logic?