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