Forum Discussion
website analysis
Hi
I trying to build a report on intranet usage, which should show the number of page views by sites.
In the data below, I would like the to count the number of page views by site:
http://contoso.sharepoint.com/sites/intranet/ has 52 page views
http://contoso.sharepoint.com/sites/intranet/hr/ has 12 page views
http://contoso.sharepoint.com/sites/intranet/hr/handbook has 8 page views
http://contoso.sharepoint.com/sites/intranet/sales/ has 12 paes views
http://contoso.sharepoint.com/sites/intranet/hr/sales/team1/ has 4 pages views
etc..
Can this be done in PowerBi? How?
The data, I've got looks like this. I've got one line per pages view in a Azure SQL DB.
Hi Torbenan,
You should first import above data into Power BI desktop.
Then, to count page views per site, you can "Group by" data rows.
Regards,
Yuliana Gu
1 Reply
Hi Torbenan,
You should first import above data into Power BI desktop.
Then, to count page views per site, you can "Group by" data rows.
Regards,
Yuliana Gu