Looking at our Matomo 4.6.1 data in Power BI.
I want to create a “nothing fancy” dashboard, where one of the cards will show total visitors for a period. However log_visit
table does not have idvisitor
or visitorId
column for me.
I started with https://developer.matomo.org/guides/database-schema and https://matomo.org/faq/how-to/how-do-i-write-sql-queries-to-select-visitors-list-of-pageviews-searches-events-in-the-matomo-database/, then googled and searched this forum before posting.
How can I count users?
Thank you.