I want to utilize the Usage Analytics Dashboard that will give me these key insights/KPIs: MetricDescriptionViews per dayTotal number of views per day per dashboard Views per userNumber of views in the past 365 days, broken down by individual users.Total viewsNumber of views in the past 365 days.Total in organizationCount all dashboards or reports in the entire organization that had at least one view in the past 365 days.Rank: Total viewsFor total views of all dashboards or reports in...

This is what I came up with regarding the KPIs that I was trying to achieve. I created a subquery to capture the number of views per dashboard based on the action 'dashboard. loads'. I ran the subquery from the DimDashboards dimensional table that has already been created and added a value called "Dashboardloads".SELECT distinct o.DashboardID AS [Dashboard ID], o.dashboardPath AS [Dashboard Path], CASE WHEN StrParts(o.dashboardPath,'/',1) like '' THEN 'null' ELSE StrParts(o.dashboardPath,'/',1)...

Creating a Custom Usage Analytics dashboard | Help and How-To

MoreDiscussions

Creating a Custom Usage Analytics dashboard | Help and How-To | Sisense Community