Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Issue with page level interactions - formula help

I have a lookuptable called 'Users' with UserID and user name and dateActivated . I have another table ('loginactivity') that has userID and userLogins and date. They are connected via userID and a c...
Need Help
  • RMB's avatar
    RMB
    6 years ago

    In that case, simply add just the logins count measure to the filter on the matrix table.

     

    Login count measure:

    Logins = CALCULATE(COUNT(User_Login[UserID]), FILTER(User_Login, [Action] = "Login"))

     

    Login measure on the matrix filter list and set to is not blank:

     

    And a date selected on the graph that is filtering the matrix to just those users that had a login on that day:

     

  • RMB's avatar
    RMB
    6 years ago

    Just to make sure I understanding correctly, you want a DISTINCT user count?

     

    If you create a measure using the distinct count on the UserID column on the User_Login table you can actually put the AppVersion and count of users in a matrix and not require any further actions to filter.

     

    Count of Users = CALCULATE(DISTINCTCOUNT(User_Login[UserID]), FILTER(User_Login, [Action] = "Login"))

     

    Let me know if that answers the question. 

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

RMB my axis is date from a calendar table (also a shared table) 

 

RMB's avatar
RMB
Resolver II
6 years ago

In that case, simply add just the logins count measure to the filter on the matrix table.

 

Login count measure:

Logins = CALCULATE(COUNT(User_Login[UserID]), FILTER(User_Login, [Action] = "Login"))

 

Login measure on the matrix filter list and set to is not blank:

 

And a date selected on the graph that is filtering the matrix to just those users that had a login on that day:

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    RMB that worked like a dream. Could I ask you about another one? Your help would be GREATLY appreciated.

     

    I want to create another matrix that is filtered BY clicking the same exact graph of user login activity that looks like this:

    AppVersionCount of Users
    1.312
    1.414

    (So that when you click the bar graph, the count of users will change based on how many users logged in with that app version at that time) 

     

    I have the same 2 tables: 

    Logins - but this time, there is a new column with an app version id with each login instance. So the table looks like this

    UserIDLoginActivityDateAppVersion
    1Login2/12/20201.4
    1Login2/13/20201.4
    2Login2/12/2020 1.3

     

    I also have a users table with a unique list of userIDs


    Again, my graph login count measure is from the Logins table and is Logins = CALCULATE(COUNT(User_Login[UserID]), FILTER(User_Login, [Action] = "Login"))

     

    But I need to use App version from the Logins table BUT UserID from the Users table in the matrix 

     

    Does this make sense? 

     

     

    • RMB's avatar
      RMB
      Resolver II
      6 years ago

      Just to make sure I understanding correctly, you want a DISTINCT user count?

       

      If you create a measure using the distinct count on the UserID column on the User_Login table you can actually put the AppVersion and count of users in a matrix and not require any further actions to filter.

       

      Count of Users = CALCULATE(DISTINCTCOUNT(User_Login[UserID]), FILTER(User_Login, [Action] = "Login"))

       

      Let me know if that answers the question.