cancel
Showing results for 
Search instead for 
Did you mean: 

Formula for counting the views per user

vish1996
7 - Data Storage
7 - Data Storage

Sisense provides our company with a usage analytics model. now what i want is to count the total number of views per user ? like how many times they have seen a dashboard? how do i do this ? 

i tried to do count all like DUPCOUNT [Userid] , but this shows unrealistic values. it shows I viewed a dashboard 567 times in the past 7 days. That's not true.

then I realized that DUPCOUNT only works on numeric values, does anyone know how to go about this ?

i have attached screenshots on the fields available to me, if that helps. thank you.

 

1.jpg2.jpg3.jpg4.jpg

1 REPLY 1

tomlinton
Sisense Team Member
Sisense Team Member

Hi! Have you looked at the pre-built "Usage - Dashboards" dashboard provided by Sisense? This has a few charts that already show dashboard viewers. In short, to get the views of a dashboard by user, you would need that information from the "FactActions" table in the Usage Analytics Model. DUPCOUNT does work on non-numeric fields. So if I wanted to see the number of views a dashboard got per user, I might bring in the following information: username from DimUsers, dashboardID from FactActions, and DUPCOUNT(username). This would show me the views per dashboard by user. 

Reasons you may get an "unrealistic" number is that the FactActions table is capturing a lot of actions. So if I am viewing a dashboard, I might select different filters which is causing the dashboard to reload. All of these events might be viewed as me viewing the dashboard, but in reality, I was just viewing it once and interacting with it. Play around with filters from FactActions to see if there are any ActionTypes that you can filter out to get the number down. Hope this helps!

Community Toolbox

Recommended quick links to assist you in optimizing your community experience:

Developers Group:

Product Feedback Forum:

Need additional support?:

Submit a Support Request

The Legal Stuff

Have a question about the Sisense Community?

Email community@sisense.com