Visits by Server Time widget vs raw data query result mismatch


(Saqib Ali) #1

Hi All,

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

SELECT DATE_FORMAT(server_time, ‘%H’) ‘Hour’, count(1)
FROM piwik_log_link_visit_action
where Date(server_time)=CURDATE() and idsite=25
GROUP BY DATE_FORMAT(server_time, ‘%H’)
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?

Thanks

Best Regards
Saqib Ali