(rujiaxiao) #1

how to get nb_uniq_visitors by sql?
How to calculate the number of nb_uniq_visitors in the referral type report?
The results calculated using the following statements are inconsistent with the number of nb_uniq_visitors on the piwik page.

select count(DISTINCT idvisitor) from piwik_log_link_visit_action where idsite=1
and date_add(server_time,interval 8 hour)>=‘2018.05.08’ and
date_add(server_time,interval 8 hour)<‘2018.05.09’;

Seek rescue