Submit a ticket My Tickets Login

Filtering Users in Datasets

tyGraph Power BI datasets have the ability to be restricted by a selected User Dimension.

This has many benefits including:

Support Editing of tyGraph Reports to a special interest group within the organization.
Faster lighter datasets
Limit shared datasets to need to know information


Supported Products

Coming Soon

  • tyGraph for Yammer - Q1 2023
  • tyGraph Pulse - No Date Planned

User Filters

There are two user filters that you use in combination to limit the dataset to a subset of your population. Spaces are allowed between words. Leading and trailing spaces do matter. Filter is case sensitive. 

  • User Column- The name of the user column that you would like to use as a filter. 
    • Example "User Country"
  • User Value- A semicolon delimited list of the user values that you would like to have returned. 
    • Example "Canada;United States"
    • Semicolons for delimiting

User Column Options

User Emailanonymous;
User Manager
User Manager NameUnlimitedViz Admin
User TypeMember;Guest
User ContinentEU;AU
User CityToronto;New Jersey
User Zip / Postal CodeL2V 0A5;90201
User State / ProvinceOntario;New York
User CountryCanada;New Zealand
User Country CodeCA;NZ
User Address<External User>;23 Rosedale Ave
User BuildingHead Office;Jersey Office
User OrganizationtyGraph;AvePoint
User DepartmentDevelopment;Research and Development
User Job TitleSales;Developer;Vice President
User DivisionServices;North America Sales;Headquarters
User Business UnitAMEA;LATAM;NA
User IsExternalYes
HR - Attribute01<External User>
HR - OrgLevel01Cargo tray accessory
Any "HR - OrgLevel" or "HR - Attribute" Ranges 01-10


Nuances by Workload

Below are the nuances of how we determine which activities to return. Key Term: Parameterized User - Is the users to be included in the data as defined by the parameter setting.

tyGraph for OneDrive

Filters these tables:

  • User
    • All users in filter.
    • Any external users
  • Drive
    • All drives hosted by user from filtered criteria.
    • Also returns drives where users from that criterion had interactions with drives outside their area.
  • Object
    • Get all prefiltered (sharing activity or usage (by non-owners) in the past 3+current month) objects for owners in the user filter criteria
    • And all objects on which the user-filtered users interacted with (even if outside the user filter parameter)
  • Pulse Storage
    • Gets all Users usage, storage information based on the filtered criteria
  • License User
    • Licenses for all users in filter.
  • Transactions Detail
    • Get all transactions on the prefiltered (sharing activity or usage by non -owners) in the past 3+ current month) items, for user-filtered owned objects 
    • And where the user-filtered users interacted on items outside the user-filter parameter
  • SharePoint Summary User Activity
    • All Transactions with the users by filter.
    • Or any External Users regardless of parameters

For example, Filtered to France users. French user interacts with drive of user from Canada, Canadian drive will be listed as well.

tyGraph for SharePoint

Filters these tables:

  • Sites
    • Any sites with activity from users that fit criteria
  • Objects
    • Any objects with activity from users that fit criteria
  • Users
    • Any users with activity from users that fit criteria 
    • Or anyone that is external
  • Licenses
    • Users that fit criteria & their licenses.
  • Summary User Web File Activity
    • Get all the activity from the web for the users with the filtered criteria
    • Or any external users that have activity on that web.
  • Detail Transactions
    • Any users with activity on site that fit criteria 
    • Any external users with activity on objects related to filtered criteria.
  • SP Web
    • Giving any activity for the sites on filtered criteria regardless of internal/external 
  • Pulse Storage
    • Giving storage information for any web where filtered users have activity on

tyGraph for Teams

Filters these tables:

  • User
    • All users in filter
    • Any external users
  • Attachments
    • Any attachments from messages posted by user of the filtered criteria.
  • Channel
    • Any channels where a user from the filter criteria posted.
  • Channel Tab
    • Any tabs in channels where a user from the filter criteria posted.
  • File Objects
    • Any files with activity against them from users defined by the filter criteria.
  • File Transactions
    • Any activity by users in the filter criteria
    • PLUS any activity by external users on the same object
    • This does NOT include activity by other users on the same object. For example Canadian user views Buget.xlsx only activity by Canadians will be shown plus external users. Activity by US users will not be shown.
  • Licenses 
    • Any licenses assigned to users defined by the filter criteria.
  • Team Members
    • Any team members from the defined filter criteria.
    • * Note this means that Team membership will not be reflective of the actual total. For example filter to Canadian users, team membership will only count Canadians not US members.
  • Mentioned Users
    • Any mentioned users from messages posted by users in filter criteria.
  • Messages
    • Only channel messages posted by users in the filter criteria.
    • Does not include messages that the filtered user participated in but did not post. For example messages that filtered user is mentioned on or reacted to.
    • Implication for Threads
      • Filtered to Canada: If a thread has responses by a mix of Canadians and US Users. Only Canadian responses will be shown and counted. This would deflate the total responses counted in report vs riality.
  • Device Usage
    • Any activity by users in the filter criteria
  • User Usage
    • Any activity by users in the filter criteria
  • Reaction
    • Only counts reactions made on messages posted by the Parametrized Users. 
    • Does not include reactions made by Parameterized Users on messages from other non-parameterized users. 
      • Example Message posted by Canadian will include reactions from US users as well
      • Reactions by Canadian on US message will not be counted.
  • Team
    • Any teams where a parameterized user has posted a message.
    • Does not include teams where the parameterized user is a member but has not posted
  • Threads
    • Any threads where the parameterized user responded.
    • For example US threads where a Canadian replied.



Distributing insights to your stakeholders is an important part of empowering digital transformation. Without insights into change its difficult for areas of the business to see the impact of changes they are making.