
- AAD User TemplateHost site for a Users One Drive files. Historically it has held other artifacts. Users could go and create libraries, blogs or other SharePoint classic concepts.
- AccessedOdataLinkAnalyst accessed the OData link for a query.
- AccessRequestAcceptedAn access request to a site, folder, or document was accepted and the requesting user has been granted access.
- AccessRequestCreatedUser requests access to a site, folder, or document they don't have permissions to access.
- AccessRequestDeniedAn access request to a site, folder, or document was denied.
- AccessRequestUpdatedAn access request to an item was updated.
- Active Guest UsersAll guest users who were active for the report period and are also flagged as activebased on todays user data. Used in the site collection activity table to display the number of Site Collection Guests simply titled 'Guests.'
- Active Internal UsersAll internal users who were active for the report period and are flagged as having an active active directory account (have not had their active directory account deleted or inactivated). Used in the site collection activity table to display the number of Site Collection users simply titled 'Users.'
- Active UsersNumber of active Yammer user accounts for a specified timeframe.
- Activities (SharePoint Page)'SharePoint Site Activity'[Active Files] + 'SharePoint Site Activity'[Page Views]
- Activity (Column)A descpription of the activity that took place. This includes everything from users being added to a group, checking files in/out, sharing policy/invitation changes and more.
- Activity - FileAll drive activities where the object was a file. Total Activities where 'Activity Type' [Object Type] = File
- Activity - File SyncAll file activities where the activity was from automatic syncronization.
- Activity TypeA grouping of activity types into three main categories: Sharing, System, and Usage. This can be used to quickly filter down activity types or can be added to a visualizations 'legend' to make the grouping clear and colour coded.
- AddedToGroupUser added a member or guest to a SharePoint group. This might have been an intentional action or the result of another activity, such as a sharing event. For details check out this Microsoft article(...)
- AddedToSecureLinkA user was added to the list of entities who can use a secure sharing link.
- Administered GroupsThe total groups that a user is a Group Administrator of in Yammer. This is great for counting groups that are administrated by each user, and flagging users who are group admins. This visual can be found on the Group Activity page of most Yammer reports.
- All Activity (Pulse)All Activity = [Email - User Activities] + [Teams - All Messages] + [SharePoint - User Activities] + [OneDrive - User Activities] + [Skype - Sessions] + [Yammer - User Activity]
- All FilesTotal files for the selected site or site collection.
- All Guest UsersAll Users who are from outside of the organization'stenant. Any users with the #ext added to their name are external to the tenant and are included within this total.
- All Internal UsersAll Users from within the companies tenant. Any users with the #ext added to their name are external to the tenant and are not included within this total.
- All SharePoint ActivitiesThe total SharePointactivities captured by the tyGraph Harvester for the report period. These activities inlcude the following:AccessRequestCreated, AddedToSecureLink, AnonymousLinkCreated, AnonymousLinkRemoved, AnonymousLinkUsed, CompanyLinkCreated, CompanyLinkUseds, FileAccessed,(...)
- All Site CollectionsTotal site collections.
- All SitesTotal sites
- All Yammer ActivityCalculation = [Likes] + [Posts] + [Reads].
- All Items .aspxDisplay page for lists and libraries. This is not unique to a particular list or library. When analyzing "Object Name" we recommend you do it in the context of a single site or with the "Object Path" included in the visual othewise you are seeing activity for the all items page across(...)
- AllowedDataLocationAddedA SharePoint or global administrator added an allowed data location in a multi-geo environment.
- AllowedDataLocationDeletedA SharePoint or global administrator removed an allowed data location in a multi-geo environment.
- AllowGroupCreationSetSite administrator or owner adds a permission level to a site that allows a user assigned that permission to create a group for that site.
- Anonymous Guest UserAnonymous users are users who have a shareable link to a folder or document and can view or edit the document or upload to the folder (depending on the type of link) without having to log in with a username or password. Anonymous links can be freely passed around between users and are valid(...)
- AnonymousLinkCreatedUser created an anonymous link to a resource. Anyone with this link can access the resource without having to be authenticated.
- AnonymousLinkRemovedUser removed an anonymous link to a resource. The link can no longer be used to access the resource.
- AnonymousLinkUpdatedUser updated an anonymous link to a resource. The updated field is included in the EventData property when you export the search results.
- AnonymousLinkUsedAn anonymous user accessed a resource by using an anonymous link. The user's identity might be unknown, but you can get other details such as the user's IP address.
- Attachment (Measure)Total attachments added to messages. This can be pivoted by the message, user, date and group (both public and private).
- Authenticated users with Microsoft accountsYou can share sites, files, and folders with users who have a Microsoft Account or a work or school account from another Office 365 subscription in much the same way that you share sites and documents with your internal users. Permissions and groups work the same for authenticated external(...)
- Authenticated users without Microsoft accountsYou can share files and folders with anyone who has an email address. If the person you're sharing with doesn't have a Microsoft Account or a work or school account, they will be sent a one-time access code for authentication each time they access the file or folder. You can't share sites with(...)
- Average Days to Respond (Measure)The average time between each message in a thread including the initiating message. This can be aggregated at the Channel or Team level. Example: John posts on 1 Dec gets a reply on 2 Dec, and then a user comments again on 7 Dec, the Avg = (1+6)/2 = 3.5. The average is NOT the difference(...)
- Avg. Days to Repsond (previous period)The total time in days between responses in Yammer for the previous days to the current report period. If you're filtered to the last 7 days then the previous period is the 7 days prior to the last date of your current period. For example March 25th - March 31st. Previous period would be March(...)
- Avg. Days to RespondThe average number of days that passed before a thread or group of threads received a response.
- Avg. Days to Respond %The average days to respond divided by the average days to respond across all groups in the dataset.
- Avg. Days to Respond (all groups)The average days to respond for all groups regardess of your group filtering selection
- Avg. Days to Respond KPIThis is the same as the Avg. Days to Respond POP but with an up and down arrow KPI Indicator
- Avg. Days to Respond MaxThe longest avergage days to respond for a thread or group. We use this for the max value on guage visuals.
- Avg. Days to Respond (PoP%)The percentage change of average days to respond for the current report period compared to the previous period.
- Avg. Hours to RespondAverage days to respond but down to the hour, This is only for those of you who like to be extra precise!
- AvgSeenByA hidden tyGraph measure calculating the average number of Thread Views for all conversations in each group.
- Benchmarking LaunchA tyGraph tool that anonamously aggregates and displays basic network statistics for the use of comparison and goal setting. This allows customers to benchmark scores like Engaged Members %, Engaged Groups, and MAE Score with customers of similar charictaristics anonymously. This program is(...)
- BotAddedToTeamA user adds a bot to a team.
- BotRemovedFromTeamA user removes a bot from a team.
- Breadth PointsA compontent of the Influencer Score. This is the number of groups that you have contributed to for the report period multipiled by 100 to make it relative to other scores in the Influencer Score.
- Breadth Points (Teams Influencer Score)Breadth Points measures the extent of a users channel participation. The more channels that a user has joined the higher their Breadth Points. Breadth Points = Sum of User Channels
- CanceledQueryAnalyst canceled a running query.
- % Change Engaged MembersThe month over month difference in engaged members expressed as a percentage. This metric is intended for time series visualizations and therefore should always be pivoted on Month Year Short or an equivalent time intelligence axis or row context.
- % Change Engaged Members (Static)The difference in engaged members from the previous full month and the month prior to the previous full month expressed as a percentage. Example. On 14 October the metric would calculate the difference in engaged members for the month of August compared to the month of September. This is best(...)
- % Change MAEThe month over month difference in MAE Score expressed as a percentage. This metric is intended for time series visualizations and therefore should always be pivoted on Month Year Short or an equivalent time intelligence axis or row context.
- % Change MAE (Static)The difference in MAE Score from the previous full month and the month prior to the previous full month expressed as a percentage. Example. On 14 October the metric would calculate the difference in engaged members for the month of August compared to the month of September. This is best(...)
- % Change MessagesThe month over month difference in messages expressed as a percentage. This metric is intended for time series visualizations and therefore should always be pivoted on Month Year Short or an equivalent time intelligence axis or row context.
- % Change Messages (Static)The difference in messages from the previous full month and the month prior to the previous full month expressed as a percentage. Example. On 14 October the metric would calculate the difference in engaged members for the month of August compared to the month of September. This is best(...)
- ChannelAddedA user adds a channel to a team.
- ChannelDeletedA user deletes a channel from a team.
- Channels (Measure)Total number of teams channels on the network. Currently this is based on a the current date and is not historic. This can be pivoted on Member Name to reflect the number of channels to which each user is a member.
- Client TypeThe specific type of platform used to send a yammer message. A subsection of client type group, allowing a drilldown into client type group. Categories include: Android, Chrome Extension, Email, iPhone, TripIt, Twitter, unknown, Web, Windows 8, Windows Phone, etc. A great use of Client type(...)
- Client Type GroupA summary of Client Type. Groups all Client Types into four major categories: Web, Email, Mobile, and Other. This allows for convenient comparison of message posting patterns within your network. Though this visual is often seen categorizing messages posted, it can be used with metrics such as(...)
- CompanyLinkCreatedUser created a company-wide link to a resource. company-wide links can only be used by members in your organization. They can't be used by guests.
- CompanyLinkRemovedUser removed a company-wide link to a resource. The link can no longer be used to access the resource.
- CompanyLinkUsedUser accessed a resource by using a company-wide link.
- ComplianceRecordDeleteA document that was classified as a record was deleted. A document is considered a record when a retention label that classifies content as a record is applied to the document.
- ComplianceSettingChangedA retention label was applied to or removed from a document. This event is triggered when a retention label is manually or automatically applied to a message.
- Compounding FiltersWhen two or more filters compound with each other in a PowerBI report to prodouce an overall filter result unintended by the user (usualy all blanks). When two or more filters are applied simultaniously the report will return data that fits the criteria for both. Example: a report level(...)
- ConnectorAddedA user adds a connector to a channel.
- ConnectorRemovedA user removes connector from a channel.
- ConnectorUpdatedA user modified a connector in a channel.
- Consumption ScoreSum of passive actions made by a user in Yammer. The total of this value is used for the lurker ratio. Consumption Score = Message Likes + File Downloads + File Views + Note Views. This score is the nominal component used to account for passive actions taken on the network, also known as(...)
- Content TypeThe category of a given file. Example: application, video, image etc. An example of the difference between the content type and file type is, an application that is uploaded as a .txt file. Content type would designate it as an application but the file type remains a document.
- Contribution Points (Teams)This is a subscore (component of the Influencer Score) that weights a users contribution by assigning weighting to conversational actions. Threads = 2 Points, Messages = 1 Point, Likes = 0.5 Points. Contribution Score = (Threads* 2)+ (Messages)+ (Likes* 0.5)
- Contribution Points (Yammer Influencer Score)A weighted total of points given to a user for contributing content in conversations. Where Announcements are worth3 Points,Threads Initiated 2 Points, Replies, Praises, and Shares are worth 1 Point, and Likes are worth 0.5 points.
- Contribution ScoreSum of concerted actions made by a user in Yammer. The total of this value is used for the contribution component of the Lurker ratio. Contribution Score = Messages + Message Shares + Topic Mentions + User Mentions + User Praises + File Uploads + Notes. The goal of this score is to separate(...)
- Create DateDate and time the group was created at in the format YYYY-MM-DD HH:MM:SS. Useful for reference when analyzing the lifespan of a group.
- CreatedThe date that the site was created
- Created AtDate that the corresponding network was created.
- CreatedAtThe exact date and time when the thread was created, formatted as YYYY-MM-DD HH:MM:SS.
- Cross FilteringThe ability to filter all of the visuals on a Power BI page by selecting a datapoint on a neighboring visual. Example: Selecting Dean Swann on the Influencer bar chart, will filter all other visuals on the tab to Dean Swann (where visual interaction is selected, see visual interactions for details).
- Current Active UsersNumber of users that currently have an active Yammer account. I.e. not suspended, deleted, or pending. Not time sliceable.
- CustomizeExemptUsersA SharePoint or global administrator customized the list of exempt user agents in the SharePoint admin center. You can specify which user agents to exempt from receiving an entire web page to index. This means when a user agent you've specified as exempt encounters an InfoPath form, the form(...)
- DataExportVerified admin exports Yammer network data. Only verified admins can perform this operation.
- DateUnique dates. Ranging from Network Create Date to present day.
- DateIntAn integer created based on Date field in YYYYMMDD format. Used to join all other tables with Date fields.
- DayDay value of date.
- Day of WeekDay of the week for given date value.
- DayInWeekDay of week represented with a numeric value. Example: Wednesday =4, Saturday =7.
- Dec 2019 Update Guide - tyGraph for OneDriveA comprehensive document outlining the features we added in our Dec 2019 release!
- Dec 2019 Update Guide - tyGraph for SharePointA comprehensive document outlining the features we added in our Dec 2019 release!
- Dec 2019 Update Guide - tyGraph for TeamsA comprehensive document outlining the features we added in our Dec 2019 release!
- Dec 2019 Update Guide - tyGraph for YammerA comprehensive document outlining the features we added in our Dec 2019 release!
- Deleted Messages Flag ('Messages' [IsActive])A column in the messages table that showsmessages that identifies if the message has notbeen deleted in Yammer. So if this flag is "True" then the message has not been removed. For users looking to see what messages have been deletedselect "False" for this column.
- DeletedResultAnalyst deleted a query result.
- DepartmentAn optional field where a users company department can be entered. Useful for the management of combined operations between departments.
- Digital Transformation Score (DTS)DTS = ((DTS - Email]*1)+([DTS - OneDrive]*3)+([DTS - SharePoint]*3)+([DTS - Skype]*3)+([DTS - Teams]*5)+([DTS - Yammer]*5)
- DomainThe domain from the user's email address, typically the company website.
- DownloadedReportAnalyst downloaded a query result file.
- DrivesTotal drives in the tenant or selection. This measure can be seen on the OneDrive Overview page where it is used as the baseline of the Engaged Drives guage.
- DTS - EmailThe total days that a user has sent or recieved email multiplied by one.
- DTS - OneDriveTotal days that a user has had one drive activity multiplied by three.
- DTS - SharePointThe total daysthat eachuser has taken an action in SharePoint multiplied by three. The SharePoint activities considered in this measure is File Views/Edits, Files Shared Externally, Files Shared Internally, Files Synced, Pages Visited.
- DTS - SkypeThe total days that each user has taken an action in Skype multiplie by three (see DTS weighting image for overview). ASkype activity is defined as when Total Sessions is >0. See the 'Skype Sessions Table' in Power BI for details.
- DTS - TeamsThis is the total days for each user that has taken an action in Teams multiplied by five. For this measure Teams activity is defined as when a user has any chat messages, meetings, private messages, or voice calls. For details see the Teams Activity table. For an overview see the DTS(...)
- DTS - YammerThis is the total days for each user that has taken an action in Yammer multiplied by five. For this measure Yammer activity is defined likes, reads or posts. For an overview see the DTS Weighting visual.
- (dynamic) Current PeriodThe total of all selected Dynamic Actions. This measure is important because you can shape your engagement metrics based on activities that you value. See the Metricsetrics slicer in the left pane of your default report pages.
- Dynamic File DownloadsTotal files downloaded. This measure is dynamic because can be toggled in or out of the reports using the "MAE Score Metrics" column in the form of a filter.
- Dynamic File Downloads (unique)Total downloads where only the first download per user per file is counted. This is better if you want to reduce the weighting of downloads in your engagement measure and thereby reduce volitility in the MAE Score. This measure is dynamic because can be toggled in or out of the reports using(...)
- Dynamic File UploadsFiles uploaded to Yammer. This measure is dynamic because can be toggled in or out of the reports using the "MAE Score Metrics" column in the form of a filter.
- Dynamic File ViewsTotal file view activities in Yammer. This measure is dynamic because can be toggled in or out of the reports using the "MAE Score Metrics" column in the form of a filter.
- Dynamic File Views (unique)Total file views where only the first view per user per file is counted. This is better if you want to reduce the weighting of downloads in your engagement measure and thereby reduce volitility in the MAE Score. This is especially popular where communications teams are only interested in the(...)
- Dynamic LikesTotal likes. This measure is dynamic because can be toggled in or out of the reports using the "MAE Score Metrics" column in the form of a filter.
- Dynamic MAE ScoreThe total of all selected MAE Actions. This measure is important because you can shape your engagement score based on activities that you value. See the MAE Score slicer in the left pane of your default report pages.
- Dynamic MentionsTotal mentions. This measure is dynamic because can be toggled in or out of the reports using the "MAE Score Metrics" column in the form of a filter.
- Dynamic Message SharesTotal shares. This measure is dynamic because can be toggled in or out of the reports using the "MAE Score Metrics" column in the form of a filter.
- Dynamic MessagesTotal messages. This measure is dynamic because can be toggled in or out of the reports using the "MAE Score Metrics" column in the form of a filter.
- Dynamic New Group MembersTotal hashtags or topics used in a thread. This measure is dynamic because can be toggled in or out of the reports using the "MAE Score Metrics" column in the form of a filter.
- Dynamic Note ViewsTotal hashtags or topics used in a thread. This measure is dynamic because can be toggled in or out of the reports using the "MAE Score Metrics" column in the form of a filter.
- Dynamic NotesTotal notes. This measure is dynamic because can be toggled in or out of the reports using the "MAE Score Metrics" column in the form of a filter.
- Dynamic PraisesTotal praises. This measure is dynamic because can be toggled in or out of the reports using the "MAE Score Metrics" column in the form of a filter.
- Dynamic Topic MentionsTotal hashtags or topics used in a thread. This measure is dynamic because can be toggled in or out of the reports using the "MAE Score Metrics" column in the form of a filter.
- EmailEmail address of the given user
- Email - % Active Users[Email - Active Users] / [Users - AllActive. Where "Email - Active Users" is all users who have sent or received an email for the report period, and "Users - Active Users" are any user with Office 365 activity for the report period and an Active Directory login.
- Email - Active UsersA distinct count of users who have had any Email Activity for the report period as defined by the "Email - User Activities" calculation. Essentially the total unique users who have sent or recieved email for the report period.
- Email AddressEmail of the user in the custom member list. Often used as an ID.
- Email - All ItemsThe total "items" in mailboxes based on the most recent record for each user in the filtered set.
- Email - All TrafficCalculation = 'Email Activity'[Received]+ 'Email Activity'[Sent]. This is used to measure the total amount of email traffic by user or work group. There is no distincion made between the sender or the recipient for tyGraph Pulse. For details on email traffic interactions see the tyGraph for(...)
- Email - % Capacity UsedCalculation= [Email - Storage (GB)] / [Email - Storage Limit (GB)]. Where "Email - Storage (GB)" and "Email - Storage Limit (GB)] is based on the most recent record for that userin the report time frame.
- Email - DevicesTotal devices utilzed by users given the most recent record for each user.
- Email - MailboxesTotal users/mailboxes with Mailbox usage for the report period.
- Email - Most Recent Mailbox Activity DateMost recent activity date for a user or aggregate of users. Though perhaps self explanitory this measure is very helpful for determining unused accounts within work groups or divisions.
- Email - Read/Received RatioCalculation ='Email Activity'[Reads] / 'Email Activity'[Received]. Often refered to as the "open rate" by email marketers this measure allows you to see what percentage of emails a user is actually opening. Analysts also like to evaluate this on aggregate and over time to look for changes in(...)
- Email - ReadsTotal emails opened. This does not indicate that the user actually read the content or spend any set period of time on the given email message.
- Email - ReceivedTotal emails receieved. Often pivoted on a user or work group.
- Email - SentTotal emails sent. Where: "Send actionsis the number of times an email send action was recorded for the user." (full url to the microsoft docsin item url)
- Email - Sent/Received RatioCalculation ='Email Activity'[Sent] / 'Email Activity'[Received]
- Email - Storage (GB)Total email storage based on the most recent records for each mailbox.
- Email - Storage Limit (GB)The total or singular mailbox storage limit based on the "Prohibit send receive quota." The "Prohibit send receive quota (MB) refers to the storage limit when the mailbox can no longer send or receive emails. If your organization's policies prevents you from viewing reports where user(...)
- Email - Storage (TB)Email storage based on the most recent record for each mailbox, expressed in terabytes.
- Email - User ActivitiesCalculation = 'Email Activity'[Reads] + 'Email Activity'[Sent]
- Email - UsersThe distinct users who have had email activity recorded for the report period.
- Engaged Group Members (%)The number of engaged members represented as a percentage of the total group members. This metric is unique from Engaged Members, in that it excludes users who are not a member of the filtered group or not a member of any group at all. For example, in a group with 100 members, if 50 of them(...)
- Engaged Group Members % (dynamic)Unique group members who have taken one of your selected MAE Actions over all users currently in that group.
- Engaged Group Members (dynamic)Total unique users who have taken one of your selected MAE Actions within a group.
- Engaged Group Members KPI (dynamic)Engaged Group members % POP but with an up and down arrow KPI Indicator
- Engaged Group Members PoP% (dynamic)The percentage change in engaged group members from the previous period to the current. The previous period is the same span of dates immediately before your report period. If you are filtered to the last 7 days then the previous period is the 7 days prior to the last date of your current(...)
- Engaged Group Members - previous period (dynamic)The number of engaged group members from the previous period. The previous period is the same span of dates immediately before your report period. If you are filtered to the last 7 days then the previous period is the 7 days prior to the last date of your current period. For example March 25th(...)
- Engaged GroupsA count of all groups (for the defined time period) that generated activity (MAE points) and therefore are classified as engaged. The engaged classification is assigned to any group that has had activity that would generate a MAE value. This is time sliceable, meaning that it is possible for a(...)
- Engaged Groups %The number of engaged groups expressed as a percentage of the total number of groups on the network. See Engaged Groups for details on what defines an engaged group.
- Engaged Groups (dynamic)The unique number of groups who have had any one of your selected MAE Score actions within the report period.
- Engaged Groups KPISame as engaged groups % but with a an up and down arrow KPI Indicator
- Engaged Groups KPI (dynamic)The percentage change in engaged groups based on your MAE Score Selection but with an up and down arrow KPI Indicator.
- Engaged Groups (PoP%)Percentage change of engaged groups from the previous period to now. The goal is to be increasing or maintaining this percentage. To increase your percentage consider deleting/archiving in active groups. Another way to drive adoption is to add users, content, or influencers to your failing(...)
- Engaged Groups PoP% (dynamic)The percentage change in engaged groups based on your MAE Score Selection.
- Engaged Groups (previous period)Engaged groups for the previous period. The previous period is the same span of dates immediately before your report period. For example, if you are filtered to the last 7 days then the previous period is the 7 days prior to the last date of your current period. For example March 25th - March(...)
- Engaged Groups - previous period (dynamic)The number of engaged groups from the previous period. The previous period is the same span of dates immediately before your report period. If you are filtered to the last 7 days then the previous period is the 7 days prior to the last date of your current period. For example March 25th -(...)
- Engaged MembersA classification assigned to any unique user who has had activity that would generate a MAE value. This is time sliceable, meaning that it is possible for a user who is no longer part of the organization to be listed as an engaged member if your timeframe includes dates when they were active(...)
- Engaged Members %The number of engaged members divided by the number of registered members for the report context. Engaged members are any user who has taken at least one action for the report period. A registered member is any user who has joined the network and has not been suspended or deleted in the given(...)
- Engaged Members (dynamic)The number of unique user who have taken any one of your selected MAE Score acts of engagement for the current report period.
- Engaged Members / Group Members (%)Engaged members over total group members. This helps you understand what percentage of users are engaged out of the people who have actually joined the group. If this percentage is over 100% then it means that users are engaging in the group without joining it. This can only happen in public(...)
- Engaged Members KPI (dynamic)The percentage change in engaged members but with an up and down arrow KPI Indicator
- Engaged Members PoP% (dynamic)The percentage change in engaged members who took any one of your selected MAE Score acts of engagement in the current report period.
- Engaged Members (Previous Month)Engaged Members Calculation fixed to the most recent full month. Often added under the tooltips section of a visual to show the total number of engaged members for the previous month when the user hovers the cursor over a country visual. Example Oct 23 this would show total engaged members for(...)
- Engaged Members - previous period (dynamic)The number of unique users who took one of your selected acts of engagement in the previous period. The previous period is the same span of dates immediately before your report period. If you are filtered to the last 7 days then the previous period is the 7 days prior to the last date of your(...)
- Engaged Members / Registered Members (%)Engaged Members over all users. This is the percentage of the entire network that is engaging in a particular group. This is useful to compare across groups in your tenant to see where your overall population is spending their time.
- Engaged Members (Two Months Prior)Engaged Members Calculation fixed to the 2nd full month. Often added under the tooltips section of a visual to show the total number of engaged members for the previous month when the user hovers the cursor over a country visual. Example Oct 23 this would show total engaged members for the(...)
- Engaged Non-Members (dynamic)The unique number of users who have taken any one of your selected MAE Score acts of engagement in the current report period but are not currently members of the group.
- Engaged Non-Members KPIThe percentage users who are engaged in your group but haven't joined except this measure has an up and down arrow KPI Indicator
- Engaged Non-Members KPI (dynamic)The percentage change in non members but with an up and down arrow KPI Indicator
- Engaged Non-Members (PoP%)The percentage change of users in your group who haven't bothered to join from the previous period to now. You want this percentage to go down in most cases.
- Engaged Non-Members PoP% (dynamic)The percentage change in engaged non members from the previous period to the current one.
- Engaged Non-Members (previous period)The number of users who are engaged in your group but haven't joined from the previous period. The previous period is the same span of dates immediately before your report period. If you are filtered to the last 7 days then the previous period is the 7 days prior to the last date of your(...)
- Engaged Non-Members - previous period (dynamic)The unique number of users who have taken any one of your selected MAE Score acts of engagement in the previous period but haven't joined the group. The previous period is the same span of dates immediately before your report period. If you are filtered to the last 7 days then the previous(...)
- Engaged Team Members (%)The number of engaged members divided by the total number of team members. This measure is great for evaluating enagement percentages within a team context instead of engaged members % because sometimes a team can have more users engaged than are actually members. If you use Engaged Members %(...)
- Engaged TeamsThe total number of unique teams that have had an act of engagement for the report period. This is calculated in a similar was as Engaged members where an enaged team is based on teams where there has been MAE activity greater than or equal to one
- Engaged Teams (%)The number of engaged teams divided by the total number of teams in the report context
- ExecutedQueryAnalyst ran a query.
- ExemptUserAgentSetA SharePoint or global administrator added a user agent to the list of exempt user agents in the SharePoint admin center.
- Export DataA Power BI feature that allows a user to export a table or visual to an excel spreadsheet. Values will be expressed in excel as a table regardless of the visualization type. Example: Bar charts will be exported with the axis and the bar values expressed in a table style.
- External UserAn external user is someone from outside your Office 365 subscription to whom you have given access to one or more sites, files, or folders. There are two types of external users.
- File ActivitiesTotal file activities
- File DescriptionUnstructured subtitle entered by the user to describe the document.
- File DirectoryA value assigned to a file for the sake of categorization and easy indexing. Ex. All files starting with the letter A will have an A in the field.
- File DownloadsThe total number of downloads made for a given time period, including multiple downloads. This is often pivoted on file name giving you file downloads per file. Can also be pivoted on Member Name or Group Name.
- File Downloads AverageThe mean of the total file downloads across the filtered set of files. Typically used as an average across several files in a group. Example: Pivoting file downloads average on Group Name to result with file downloads per group.
- File ExtExtension that the file belongs to.
- File NameThe file name that the member list is associated with
- File OwnerThe Member Name of the user who posted the document.
- File Sync Full DownloadsTotal files that were entirely downloaded as part of a one drive or SharePoint sync. User establishes a sync relationship and successfully downloads files for the first time to their computer from a SharePoint or OneDrive for Business document library.User establishes a sync relationship and(...)
- File Sync Full UploadsTotal files that were uploaded for the first time. Microsoft defines this as when the user establishes a sync relationship and successfully uploads files for the first time from their computer to a SharePoint or OneDrive for Business document library.
- File Sync Incremental DownloadsTotal files that were entirely downloaded as part of a one drive or SharePoint sync. User successfully downloads any changes to files from SharePoint or OneDrive for Business document library. This event indicates that any changes that were made to files in the document library were downloaded(...)
- File Sync Incremental UploadsTotal files that were uploaded as part of a small modification or change to an existing file in the cloud. Microsoft defines this as: User successfully uploads changes to files on a SharePoint or OneDrive for Business document library. This event indicates that any changes made to the local(...)
- File Type (SharePoint)A category of the given file. Example: document, image, video. An example of the difference between the content type and file type is, an application that is uploaded as a .txt file. Content type would designate it as an application but the file type remains a document.
- File UploadsNumber of unique files uploaded to the network.
- File ViewsThe total number of views a file has recieved for a given time period, including multiple views. This is often pivoted on file name giving you views per file. Can also be pivoted on Member Name or Group Name. Due to the nature that views are provided by Yammer 95% of views are collected and(...)
- File Views AverageThe mean of the total file views across the filtered set of files. Typically used as an average across several files in a group. Example: Pivoting file views average on Member Name to result with file downloads for each user.
- FileAccessedUser or system account accesses a file.
- FileAccessedExtendedThis is related to the "Accessed file" (FileAccessed) activity. A FileAccessedExtended event is logged when the same person continually accesses a file for an extended period (up to 3 hours). The purpose of logging FileAccessedExtended events is to reduce the number of FileAccessed events that(...)
- FileCheckedInUser checks in a document that they checked out from a document library.
- FileCheckedOutUser checks out a document located in a document library. Users can check out and make changes to documents that have been shared with them.
- FileCheckOutDiscardedUser discards (or undos) a checked out file. That means any changes they made to the file when it was checked out are discarded, and not saved to the version of the document in the document library.
- FileCopiedUser copies a document from a site. The copied file can be saved to another folder on the site.
- FileCreatedUser uploads a file.
- FileDeletedUser deletes a document from a site.
- FileDeletedFirstStageRecycleBinUser deletes a file from the recycle bin of a site.
- FileDeletedSecondStageRecycleBinUser deletes a file from the second-stage recycle bin of a site.
- FileDownloadedUser downloads a file.
- FileIDUnique numeric value assigned by Yammer used to identify a file. Useful for searching for a specific file or guarenteeing that a visual is calculating a metric for a specific file only.
- FileMalwareDetectedSharePoint anti-virus engine detects malware in a file.
- FileModifiedUser or system account modifies the content or the properties of a document on a site.
- FileModifiedExtendedThis is related to the "Modified file" (FileModified) activity. A FileModifiedExtended event is logged when the same person continually modifies a file for an extended period (up to 3 hours). The purpose of logging FileModifiedExtended events is to reduce the number of FileModified events that(...)
- FileMovedUser moves a document from its current location on a site to a new location.
- FilePreviewedUser previews files on a SharePoint or OneDrive for Business site. These events typically occur in high volumes based on a single activity, such as viewing an image gallery.
- FileRenamedUser renames a document on a site.
- FileRestoredUser restores a document from the recycle bin of a site.
- SharePoint FilesTotal files belonging to an account, app, or reader.
- Files DownloadedNumber of unique files downloaded by a member or members. Often used to compare the unique number of files that a user has downloaded rather than the number of downloads made by that user.
- Files ViewedNumber of unique files viewed by a member or members. Often used to compare the unique number of files that a user has viewed rather than the number of views made by that user.
- FileSharedUser shares a file with another user.
- FileSyncDownloadedFullUser establishes a sync relationship and successfully downloads files for the first time to their computer from a document library.
- FileSyncUploadedFullUser establishes a sync relationship and successfully uploads files for the first time from their computer to a document library.
- FileUpdateDescriptionUser changes the description of a file.
- FileUpdateNameUser changes the name of a file.
- FileUploadedUser uploads a document to a folder on a site.
- FileVersionRecycledUser deletes a version from the version history of a file. The deleted version is moved to the site's recycle bin.
- FileVersionsAllMinorsRecycledUser deletes all minor versions from the version history of a file. The deleted versions are moved to the site's recycle bin.
- FileVersionsAllRecycledUser deletes all versions from the version history of a file. The deleted versions are moved to the site's recycle bin.
- FileVisitedUser views a file.
- Filter OutliersA binary value used to remove anomalous files that dampen the true signal of a network. By default no files are filtered out, though tyGraph Admins may provide a list of files to flag as outliers.
- FolderCopiedUser copies a folder from a site to another location in SharePoint or OneDrive for Business.
- FolderCreatedUser creates a folder on a site.
- FolderDeletedUser deletes a folder from a site.
- FolderDeletedFirstStageRecycleBinUser deletes a folder from the recycle bin on a site.
- FolderDeletedSecondStageRecycleBinUser deletes a folder from the second-stage recycle bin on a site.
- FolderModifiedUser modifies a folder on a site. This includes changing the folder metadata, such as changing tags and properties.
- FolderMovedUser moves a folder to a different location on a site.
- FolderRenamedUser renames a folder on a site.
- FolderRestoredUser restores a deleted folder from the recycle bin on a site.
- Full NameA users first and last name.
- GeoAdminAddedA SharePoint or global administrator added a user as a geo admin of a location.
- GeoAdminDeletedA SharePoint or global administrator removed a user as a geo admin of a location.
- GeoQuotaAllocatedA SharePoint or global administrator configured the storage quota for a geo location in a multi-geo environment.
- Group CreatorThe single user who founded a given group. Often used to find users on a network who are creating the most groups by pivoting groups on Group Creator and sorting by groups.
- Group Creator EmailThe email of the group creator. Useful for creating a table of Group Name and Group creator email for export (see Export data) and generating mass emails to group creators of a collection of groups. Example group creator emails of groups where the last message posted has been greater than a(...)
- Group Delete URLDisplays the URL to a given groups delete options page in Yammer. If the user clicks on the displayed URL in tyGraph their a new browser window will open to the delete settings of that particular group.
- Group DirectoryA phonebook style value assigned to a group for the sake of categorization and easy indexing. Example: 'tyGraph for Yammer' group will have a T in the field. Example #2: 'The Yammer Champs' group would be categorized by T.
- Group Feed URLBasically the group url. We call it Group Feed URL so you can distinguish between this and the Group Settings URL or the Group Delete URL. Use this if you want a url taking you straight to the group from the report.
- Group IDUniquely identifies a group. Used for associating items like messages, threads, files, notes, and activities to a particular group.
- Group Member Joined DateA column in the Group Membership table of known Joined Dates for Yammer group members. The Joined Date is a column is taken from the Yammer Activity News Feed. It is backfilled into the group members table independently after group members have already been collected.
- Group MembersThe total number of members that have joined a group and are currently a member. Often pivoted on Group Name or Group ID to show the number of members in a group. If this measure is pivoted on Member Name or User ID it will 1 for all users who have joined at least one group. (See 'Member(...)
- Group NameUnstructured title assigned by the user to identify a group.
- Group Report GuideThe general access guide for the group report. This report is availible through tyGraph Online only.
- Group Settings URLDisplays the URL to a given groups settings page in Yammer. If the user clicks on the displayed URL in tyGraph a new browser tab/window will open to the settings of that particular group so long as that user is logged into Yammer and has permissions for that group.
- GroupAddedSite administrator or owner creates a group for a site, or performs a task that results in a group being created. For example, the first time a user creates a link to share a file, a system group is added to the user's OneDrive for Business site. This event can also be a result of a user(...)
- GroupCreationUser creates a group.
- GroupDeletionA group is deleted from Yammer.
- GroupRemovedUser deletes a group from a site.
- GroupsThe total number of groups on the Network. Often used as a baseline for other metrics or visuals. Example: The Engaged Groups gas guage.
- Groups - Current SP ConnectedThe total number of groups that are SharePoint connected. The column that defines this for each group can be found in the'Office Groups' table under the [SharePoint Connected] column.
- Groups - % PublicCalculation = [Groups - Public] / [Groups - Number of Groups]. This is a great measure for organizations encouraging work groups to work out loud by having public groups availible for the organization.
- GroupUpdatedSite administrator or owner changes the settings of a group for a site. This can include changing the group's name, who can view or edit the group membership, and how membership requests are handled.
- Guest UsersTotal user logins where the user is a guest. Compared to other metrics this includes both active and inactive users.
- Harvest DateThe date of the most recent message currently in the dataset expressed in UTC. It is important to note that this date will not move forward if the tyGraph harvester collected no new messages on a particular day. This is more likely for small networks that generate no new messages especially on(...)
- HasPhotoValue indicating users who have not changed their default Mugshot
- Help Tips Guide - tyGraph for TeamsAn export of every help tip from our Microsoft Teams product. This document includes the help tip pop up that coincides with every visual for every page.
- Hidden Networks VisualCan be found in the tyGraph for Yammer Dec 2019 report update. This shows interactions between users across groups between users where the size of a users dot is their influencer score and the strenth of the bond is the number of interactions they've had with each other. A user interaction is(...)
- HostSiteSetA SharePoint or global administrator changes the designated site to host personal or OneDrive for Business sites.
- HubSiteJoinedA site owner associates their site with a hub site.
- HubSiteOrphanHubDeletedA SharePoint or global administrator deleted an orphan hub site, which is a hub site that doesn't have any sites associated with it. An orphaned hub is likely caused by the deletion of the original hub site.
- HubSiteRegisteredA SharePoint or global administrator creates a hub site. The results are that the site is registered to be a hub site.
- HubSiteUnjoinedA site owner disassociates their site from a hub site.
- HubSiteUnregisteredA SharePoint or global administrator unregisters a site as a hub site. When a hub site is unregistered, it no longer functions as a hub site.
- Impact Points (Teams Influencer Score)A score that evaluates the impact of a user in a network, team, or channel. The more that collegues mention, reply to, or like messages by the user, the higher their score. Impact Points = [Replies by Others] + [Likes Recieved] + [Mentions Recieved]
- Impact Points (Yammer Influencer Score)This is is a sub component of the Influencer Score which applies points to actions that have impact on the network. Impact score is the only score that is entirely out of the users control in that all of the activities that it counts are done by other users interacting with the users content.(...)
- Inactive DaysNumber of days that the site has been inactive. Note that this is based on the most recent harvest date.
- Influencer Score - Guide SlideshowA little slideshow put together by the team to help unpack the Influencer Score
- Influencer Score (Teams)This score applies a weighting of a users activity in teams to place value on collaborative actions rather than the raw nominal amount of actions that the user is taking. The score is usually used for ranking within a group or network context to find users of most influence in their community.(...)
- Interacted With MemberFull name and Yammer ID of the user that UserUID (Member Name from User's table) has interacted with
- Interaction TypeType of interaction; user like, message post(reply) or user mention.
- InteractionsAn interaction is messages, likes, or mentions between you and others inside a conversation.
- Internal UsersTotal number of users who are from the home company that owns the site.
- Is ExternalFlag for users who are from another tenant.
- Is ReccomendedAn "Is recommended" conversation is a thread where the Sentiment Score is low (less than 0.25) and the thread has been viewed by more users than usual for that group. We combine this with the unanswered threads to show conversations that have not been answered and fit this criteria. This often(...)
- IsActiveA binary (true/false) value indicating if the messages is active, i.e. not deleted.
- IsCommunityA binary value that identifies networks that are not restricted to a common email domain. "Membership, messages and other data in the Community are completely separate from membership, messages and data in the parent company network; users must toggle between networks to access these separate(...)
- IsDirectMessageA binary (true/false) value that indicates if a message was a direct message.
- IsExternal (Group Table)A flag for External Yammer Groups
- IsFileA true/false categorization to identify files vs folder.
- IsJoinedA binary (true/false) value that identifies the "user has #joined your network" messages.
- IsNetworkAdminIndicates if the praised user is a network admin.
- IsOfficialA binary variable indicating if the note was marked as an official note on the network.
- IsPrivateA binary (true/false) value indicating if a message is posted in a private group or as a direct message.
- IsShareA binary (true/false) value indicating if the message is a share of another message.
- IsSystemMessageA binary value indicating if a thread is generated by the system, i.e. "so-and-so user has joined your network"
- IsThreadA binary (true/false) value that indicates if the message was the first post of the thread; the thread starter.
- IsVerifiedAdminA binary value indicating if a user's account is authorized the additional privileges of a Verified Administrator.
- IsYamJamA binary value that identifies if the given topic was created as part of a "YamJam" event. tyGraph Admin needs to provide the list of Topics to be flagged as YamJams.
- Job TitleThe company position or job title of the respective user.
- Key FundamentalsDean highlights five important keys to unlocking insights about your Yammer network. Looking for more information about tyGraph for Yammer? See tygraph.com or email us at tyGraph@unlimitedviz.com.
- Last Activity GroupA grouping for inactive days made for easy toggling between activity ranges. This includes timeframes like 0-3 Months, Over 1 year etc.
- Last Message PostedA categorical variable assigned to group when the last message was posted at. Possible categories are: Zero messages 0-3 Months Ago, 3-6 Months Ago, 6-12 Months ago, Over 1 Year Ago.
- Last ModifiedThe last date that the library item was modified.
- Latest Activity DateThe most recent activity date in the dataset.
- LegacyWorkflowEnabledSetSite administrator or owner adds the SharePoint 2013 Workflow Task content type to the site. Global administrators can also enable work flows for the entire organization in the SharePoint admin center.
- Licensing - ActivationsThe total number devices activated. This measure is based on the[Devices Activated] column in the Office Activations table.
- Licensing - Plan AssignmentsA distinct count of all licensed users. Taken from the 'Product Plan Assignments' table.
- Licensing - PlansA count of all Product Plans. Based on the Plan ID column in the 'Product Plans' table.
- Licensing - Workload LicensesTotal user licenses where the user has not been suspended or deleted. Total taken from the[Licenses] column in the'User Licenses table.
- LikesNumber of likes on messages.
- Likes per MessageThe total number of likes divided by the total number of messages for a selected filter range. Often pivoted on a group or thread to guage the popularity of messages and to quickly identify likely areas of collaboration.
- Likes (received)Number of likes on a users messages.
- List Column DeletedA user deleted a SharePoint list column.
- List Item DeletedA user deleted a SharePoint list item.
- List URLComplete url of the given list
- ListColumnCreatedA user created a SharePoint list column. A list column is a column that's attached to one or more SharePoint lists.
- ListColumnUpdatedA user updated a SharePoint list column by modifying one or more properties.
- ListContentTypeCreatedA user created a list content type. A list content type is a content type that's attached to one or more SharePoint lists.
- ListContentTypeDeletedA user deleted a list content type.
- ListContentTypeUpdatedA user updated a list content type by modifying one or more properties.
- ListCreatedA user created a SharePoint list.
- ListDeletedA user deleted a SharePoint list.
- ListItemCreatedA user created an item in an existing SharePoint list.
- ListItemRecycledA user moved a SharePoint list item to the Recycle Bin.
- ListItemRestoredA user restored a SharePoint list item from the Recycle Bin.
- ListItemUpdatedA user updated a SharePoint list item by modifying one or more properties.
- ListRestoredA user restored a SharePoint list from the Recycle Bin.
- ListUpdatedA user updated a SharePoint list by modifying one or more properties.
- LocationA location provided by an HR Integration with the tyGraph dataset. Usually location is broken down into City, State/Province, Country, or Office Location.
- LockRecordThe record status of a retention label that classifies a document as a record was locked. This means the document can't be modified or deleted. Only users assigned at least the contributor permission for a site can change the record status of a document.
- Lurker RatioThe total consumption score divided by total overall contribution on the network (sum of contribution and consumption score). Lurker Ratio = Consumption Score /(Contribution Score+ Consumption Score). This is pivoted on Member Name in the content consumption page. Not to be confused with the(...)
- LurkersThe total number of users who have had activity without interacting with people.
- MAE MedianMedian MAE score across all groups for a specified timeframe. Excludes All Company and Direct Messages.
- MAE Running TotalThe total MAE score continually calculated to account for the cumulative MAE as it was generated for any given point in time.
- MAE ScoreMeasure of Active Engagement: Users take actions on Yammer and these actions are measures of engagement. This includes the following 12 metrics: Messages, Message Likes, Message Shares, Topic Mentions, User Mentions, User Praises, File Uploads, File Downloads, File Views, New Notes, Note(...)
- MAE Score (Adjusted)This is a MAE Score that uses Unique User Downloads, and Unique User File Views instead of the total downloads and file views. Calculation = [Messages]+[Likes]+[Message Shares]+[Topic Mentions]+[Mentions]+[Praises]+[File Uploads]+[File Downloads (unique)]+[File Views (unique)]+[Notes]+[Note(...)
- MAE Score (Previous Month)MAE Score Calculation fixed to the most recent full month. Often added under the tooltips section of a visual to show the total MAE generated for the previous month when the user hovers the cursor over a country visual. Example Oct 23 this would show total MAE for the month of September.
- MAE Score (Teams)A total of activities taken in teams. MAE Score = [Messages]+[Likes]+[Mentions]
- MAE Score (Two Months Prior)MAE Score Calculation fixed to the 2nd full month. Often added under the tooltips section of a visual to show the total number of MAE generated for the previous month when the user hovers the cursor over a country visual. Example Oct 23 this would show total MAE for the month of August.
- MeetingExclusionCreatedAnalyst created a meeting exclusion rule.
- Member First Name DirectoryA phonebook style value assigned to a members first name for the sake of categorization and easy indexing. Example: A member with first name of William would be summarized with the letter W.
- Member GroupingA categorical variable assigned to summarize the number of members in a given group. This allows for the easy grouping of small, midsized and large Yammer groups. The 4 main groups are: N/A, 0-1, 2-9, 10-50.
- Member GroupsA total number of groups of which a user is a member. Often pivoted on Member Name or User ID.
- Member Last Name DirectoryA phonebook style value assigned to a members last name for the sake of categorization and easy indexing. Example: A member with last name of Johnson would be summarized with the letter J.
- Member List NameThe title or grouping assigned to a customized group of users. The Custom Member List (CML) offers a fast way of filtering more than two users. CMLs are assigned a name that corresponds to the team they represent. This allows the analyst to quickly select all users be removed or isolated for(...)
- Member NameThe first and last name of the user followed by their Yammer User ID in square brackets.
- MemberAddedA team owner adds members to a team.
- MemberRemovedA team owner removes members from a team.
- MemberRoleChangedA team owner changes the role of members in a team. The following values indicate the Role type assigned to the user.
- Mention IndicatorA binary value indicating if the given thread has user mentions.
- Mentioned Member NameThe first and last name of the user who was mentioned followed by their Yammer User ID in square brackets.
- MentionsTotal number of at mentions from conversations. Depending on the context this measure can be used to show mentions received, given, or as a total of a aggregate such as group.
- Mentions (received)The number of @ mentions that a user has received from conversationsin the report period.
- Message BodyUnstructured data entered by the user to convey an idea. The first 100 characters of the contents of a message.
- Message ContributorsUnique number of members that posted any type of message on the network; including direct messages.
- Message FilesNumber (and name) of files associated to a message.
- Message LikesNumber of likes on messages.
- Message Private SharesA single message can be shared multiple times. This is a calculation of the number of times a private message has been shared; includes both direct messages and private group messages.
- Message Public SharesNumber of times a public message has been shared.
- Message SharesTotal number of times a message has been shared.
- MessageDeletedUser deletes a message.
- MessageIDUnique numeric value assigned by Yammer that uniquely identifies a message.
- MessagesNumber of messages posted on the network; includes threads and replies for public group, private group, and direct messages.
- Messages per ContributorTotal number of messages per users for the given filter context. Included any type of post.
- Messages per DayAverage number of messages per day; includes any type of post.
- Messages (Previous Month)Messages Calculation fixed to the most recent full month. Often added under the tooltips section of a visual to show the total number of messages for the previous month when the user hovers the cursor over a country visual. Example Oct 23 this would show total messages for the month of September.
- Messages PrivateNumber of private messages posted on the network; includes threads and replies for private group and direct messages.
- Messages Private DirectNumber of private messages posted in a direct chat conversation.
- Messages Private GroupNumber of private messages posted in a private group.
- Messages PublicNumber of private messages posted on the network; includes threads and replies for public group messages.
- Messages SharedUnique number of messages shared.
- Messages (Two Months Prior)Messages Calculation fixed to the 2nd full month. Often added under the tooltips section of a visual to show the total number of messages for the previous month when the user hovers the cursor over a country visual. Example Oct 23 this would show total messages for the month of August.
- MessageTypeA categorical value that describes the type of message. Categories include: announcement, chat,message,poll, praise, system.
- Microsoft Product Nameshttps://docs.microsoft.com/en-us/azure/active-directory/users-groups-roles/licensing-service-plan-reference
- Microsoft Reference Pagehttps://msdn.microsoft.com/en-us/office-365/office-365-management-activity-api-schema
- Modern SharePoint SitesWe collect data for modern SharePoint sites the same as traditional SharePoint sites.
- MonthDate filter based on month only. (example all Januaries all time)
- Month YearMonth and year for given date. (ex. January 2015)
- Month Year ShortThe month represented in a 3 character string and the year. (ex. Jan 2015)
- Most Recent Activity DateAlso the most recent Sharepopint Activity Date in the dataset.
- Most Recent Activity DateThe most recent datpoint in the Yammer activity table.
- NameThe name the item commonly used by files only.
- Network Groups Class (Benchmarking Report)A division of networks based on the number of groups that they have on thier network for the month period. This is often used to analyze your engaged groups % against companies that feild a similar number of groups.
- Network NameThe name of the Yammer network.
- NetworkConfigurationUpdatedNetwork or verified admin changes the Yammer network's configuration. This includes setting the interval for exporting data and enabling chat.
- NetworkSecurityConfigurationUpdatedVerified admin updates the Yammer network's security configuration. This includes setting password expiration policies and restrictions on IP addresses. Only verified admins can perform this operation.
- NetworkUserSuspendedNetwork or verified admin suspends (deactivates) a user from Yammer.
- New Group MembersNumber of members that joined a group. A user that leaves and re-enters the group multiple times will count multiple times.
- New GroupsA list of groups created within the network. Can be used to count the number of groups added to a network for a given time period. Also used as a flag to identify new groups created within a given time frame.
- New Network MembersA list of members added to a network for a defined period of time. Can also be used to count the number of users added to a network for a given time period.
- New UsersNumber of new users created in a specified timeframe. Also used as a flag to identify new members that have joined within a given time frame.
- NewsFeedEnabledSetSite administrator or owner enables RSS feeds for a site. Global administrators can enable RSS feeds for the entire organization in the SharePoint admin center.
- Note DescriptionUnstructured subtitle entered by the user to describe his/her note.
- Note NameUnstructured title entered by the user to describe the given note.
- Note ViewsNumber of views on a specific note.
- NoteIDUnique numeric value assigned by Yammer used to identify a note.
- NotesNumber of unique notes created in a specified timeframe.
- Object NameThe name of the given file or folder.
- Object TypeA sub-grouping of activity type. For a full list of the breakdown see the linked image.
- OfficeOnDemandSetSite administrator enables Office on Demand, which lets users access the latest version of Office desktop applications. Office on Demand is enabled in the SharePoint admin center and requires an Office 365 subscription that includes full, installed Office applications.
- OneDrive - % Active DrivesCalculation =[OneDrive - Active Drives] / [OneDrive - Drives]. Where active drives are drives listed in the'OneDrive Usage" table and have File activity for the report period.
- OneDrive - Active FilesTotal active One Drive files added up from the[File Activity] column in the'OneDrive Usage' table.
- OneDrive - Active UsersDistinct count of users listed in the'OneDrive Activity' table.
- OneDrive - DrivesThe number of unique OneDrive drives.
- OneDrive - External SharesTotal extenal shares where an external share is defined as any access granting action that opens an object to an entity outide of the organizational tenant.
- OneDrive - Internal SharesTotal shareing activities toward users within the tenant.
- OneDrive - Storage Allocated (GB)Total gigabytes of storage allocated for each drive based on the most recent record.
- OneDrive - Storage Used (GB)Total storage used for the most recent record of each drive.
- OneDrive - Total FilesTotal files for each drive. Total taken from the [DailyFiles] column in the'OneDrive Usage' table.
- OneDrive - User ActivitiesTotal activities taken by users in the drive. This is the total of all records in from the [File Activities] column in the'OneDrive Activity' table.
- OneDrive - UsersDistinct count of all users in the'OneDrive Activity' table.
- Owner EmailThe email of the site owner
- Owner Email ActionA clickable url icon that opens an email client to the owner of the selected site.
- Owner NameName of the site owner
- Owner TypeCategory to destinguish between owners that are users and generated group owners that are not linked to a users email.
- Page ActivitiesTotal number of pages created. This is defined by the Activity Type Detail 'Object Type'
- Pages Visited (SharePoint Site Activity Table)The visits to unique pages by users within the selected SharePoint site.
- PageViewedUser views a page on a site. This doesn't include using a Web browser to view files located in a document library.
- PageViewedExtendedThis is related to the "Viewed page" (PageViewed) activity. A PageViewedExtended event is logged when the same person continually views a web page for an extended period (up to 3 hours). The purpose of logging PageViewedExtended events is to reduce the number of PageViewed events that are(...)
- PathThe site path for the item.
- Path URLThe full item url.
- PeopleResultsScopeSetSite administrator creates the result source for People Searches for a site.
- Period Over Period (POP)These measures compare the current time frame to data from the previous parallel period. For example, if I’m filtered to the last 30 days then these measures evaluate the previous 30 days before my current period.
- PermissionLevelAddedA permission level was added to a site collection.
- PermissionLevelModifiedA permission level was changed on a site collection.
- PermissionLevelRemovedA permission level was removed from a site collection.
- PermissionLevelsInheritanceBrokenAn item was changed so that it no longer inherits permission levels from its parent.
- Praised Member NameThe first and last name of the user who was praised followed by their Yammer User ID in square brackets.
- PreviewModeEnabledSetSite administrator enables document preview for a site.
- Pricing Calculator - Excel GuideThe tyGraph Price Calculator allows you to determine the price of tyGraph based on your network size. If you are looking for more than two tyGraph products, then we have an Enterprise bundled price. This allows you to purchase all tyGraph products for one bundled price.
- Private GroupsNumber of active private groups as of the last harvest.
- ProcessProfileFieldsNetwork or verified admin changes the information that appears on member profiles for network users network.
- Public GroupsNumber of active public groups as of the last harvest.
- Pulse Data HarvesttyGraph Pulse has a data refresh every 24 hours. Admin reports are reccomended to have thier refresh scheduled immidately prior to the time the analyst arrives at work. Ad-hoc (manual) refreshes can also be made at anytime for the Admin Dataset. Pulse reports in tyGraph Online are refreshed(...)
- Quarter YearQuarter and year of the given date. (ex. Q1 2015)
- QuarterOfYearDesignates the appropriate quarter for the given date.
- Reach PointsThe number of people you interacted with on any of the threads where you contributed. See also: User Interactions
- Reach Points (Teams Influencer Score)The unique number of collegues that the user has interacted with. Reach Points = [Unique users interacted with]
- Registered MembersAny user who has been added to the Yammer network and has not had their account suspended or deleted. This metric is time sliceable. For any given or selected period it will give you the total Registered members for that period.
- Registered Members Class (Benchmarking Report)A size grouping that allows you to filter to networks of similar size. This is based on the number of registered members in your network for the report month.
- Registered Members (guest)The total number of external users who have joined the network and have not been suspended or deleted.
- Registered Members (Teams)Any licensed user for Microsoft teams who has not been suspended or deleted in the report period regardless if the user has actually signed in or used teams before.
- Relative DayRolling date filter that only displays data from the current day, previous day, or both as selected by user preference.
- Relative MonthRolling date filter that only displays data from the current month, previous month, or both as selected by user preference.
- Relative YearRolling date filter that only displays data from the current year.
- RemovedFromGroupUser removed a member or guest from a SharePoint group. This might have been an intentional action or the result of another activity, such as an unsharing event.
- RemovedFromSecureLinkA user was removed from the list of entities who can use a secure sharing link.
- Reply IndicatorA customer visible indicator of the HasReply field; showing values of "Has Reply" or "No Reply".
- Report PeriodA visual aid designed to be added to any report at the discretion of the user. Allows you to quickly observe the time frame being applied to your report. This increases awareness of filtering settings and helps to prevent compounding filters. This reflects all active filters, slicers, and(...)
- Responded not @mentionedNumber of threads that have received a response from a member (cannot be the thread initiator) when there were no members @mentioned. Excludes direct messages.
- Responded not @mentioned (%)Total number of thread that qualify 'responded not @mentioned' divided by the total number of threads that contained a @mention in the initiating thread excluding direct messages.
- Responses in Last 24 HoursNumber of messages posted in the past 24 hours of the last data refresh.
- Responses per ThreadThe number of responses per thread.
- Result StatusIndicator for the result of activities. There are six possible results: NA, fail, failed, succeeded, success, and true.
- RLS Report Management for Power BI Apps (Guide)One of the great advantages of reports presented in tyGraph Online is the ability to easily constrain the data under a pre-defined role using Row Level Security (RLS). For organizations that cannot access tyGraph Online can take advantage of Power BI Apps to create the same effect. This app(...)
- Rolling 3 MonthsRolling date filter that restricts data to the most recent 3 months inclusive. Meaning that if the current month is August 2016 then data will include the May 2016- Aug 2016.
- Rolling 7 DaysRolling date filter that restricts data to the most recent 7 days inclusive.
- Rolling 12 MonthsRolling date filter that restricts data to the most recent 12 months. Meaning that if the current month is August 2016 then data will include the Jul 2015- Aug 2016.
- Rolling 30 DaysRolling date filter that restricts data to the most recent 30 days inclusive.
- SecureLinkCreatedA secure sharing link was created to this item.
- SecureLinkDeletedA secure sharing link was deleted.
- SecureLinkUsedA user used a secure link.
- Seen byTotal users who have viewed a thread. This is not dynamic on a user level but is instead the lastest seen by count reported by yammer for each thread.
- Selected MetricsA submeasure used by tyGraph to determine what measures the user has chosen in the MAE Score selection pane.
- SenderTypeA categorical value describing the user who wrote the message. Categories include: guide, user.
- SendToConnectionAddedA SharePoint or global administrator creates a new Send To connection on the Records management page in the SharePoint admin center. A Send To connection specifies settings for a document repository or a records center. When you create a Send To connection, a Content Organizer can submit(...)
- SendToConnectionRemovedA SharePoint or global administrator deletes a Send To connection on the Records management page in the SharePoint admin center.
- Sentiment ScoreSentiment Score is the average Sentiment Value for your selected messages. Negative messages will have a sentiment close to zero, positive messages will score closer to one. The sentiment value is calculated Microsoft Azure Text Analytics API from Azure Cognitive Services.
- Sentiment ValueA value from zero to one given to messages by the Microsoft Azure Text Analytics API from Azure Cognitive Services. We then average these values to calculate a conversation, group, or users sentiment score. Some companies opt to only return Sentiment Values for a recent window (say the(...)
- SharePoint - % Active FilesCalculation= [SharePoint - Active Files] / [SharePoint - Files]. Where [SharePoint - Active Files] is the total of active files.Active Files is the number of active files on the site. A file is considered active if it has been saved, synced, modified or shared within the specific time(...)
- SharePoint - % Active SitesCalculation =[SharePoint - Active Sites] / [SharePoint - Sites]. Where an active site is any Site that has activity data in the[Activities] column in the'SharePoint Site Activity' table for the report period.[SharePoint - Sites] is a unique count of sites that have not been deleted.
- SharePoint - Active UsersA distinct count of all users in the 'SharePoint User Activity' table.
- All SharePoint FilesThe total files recorded in SharePoint.
- SharePoint - FilesThe total 'SharePoint Site Activity'[Files] omitting sites that have been deleted.
- SharePoint - Most Recent Activity DateThe most recent date recorded in the'SharePoint Site Activity' table.
- SharePoint - Most Recent User Activity DateThe most recent date of data collected into the'SharePoint User Activity' table. This can be used to observe any differences between data in the SP User Activity table and the SP SiteActivity table.
- SharePoint SitesA distinct count of all SharePointSiteID's in the'SharePoint Site Activity' table that have not been deleted.
- SharePoint - Storage Quota (GB)The total storage space across sites based on the most recent quota foreach SharePoint site.
- SharePoint - Storage Used (GB)The total storage space used across all non deleted sharepoint sites.
- SharePoint - Storage Used (TB)This is just theSharePoint - Storage Used (GB) expressed in terabytes.
- SharePoint - User ActivitiesA simple total of the[SharePoint Activities] column from the 'SharePoint User Activity' table.
- Sharing ActivitiesTotal number of items shared. This is defined by the Activity Type Detail 'Object Type'
- SharingInheritanceBrokenAn item was changed so that it no longer inherits sharing permissions from its parent.
- SharingInheritanceResetA change was made so that an item inherits sharing permissions from its parent.
- SharingInvitationAcceptedUser (member or guest) accepted a sharing invitation and was granted access to a resource. This event includes information about the user who was invited and the email address that was used to accept the invitation (they could be different). This activity is often accompanied by a second event(...)
- SharingInvitationCreatedUser shared a resource in SharePoint Online or OneDrive for Business with a user who isn't in your organization's directory.
- SharingInvitationRevokedUser withdrew a sharing invitation to a resource.
- SharingInvitationUpdatedAn external sharing invitation was updated.
- SharingRevokedUser (member or guest) unshared a file, folder, or site that was previously shared with another user.
- Site Collection URLThe full url of the site collection.
- Site Collections with ActivityTotal number of site collectons which had usage activity for the report period. This is defined by the Activity Type Detail 'Activity Type'
- Site CollectionUIDAn ID for every site and personal portals.
- Site ContentType CreatedA user created a site content type. A site content type is a content type that's attached to the parent site.
- Site SettingsA clickable link to the site settings page.
- Site URLThe site full url
- SiteAdminChangeRequestUser requests to be added as a site collection administrator for a site collection. Site collection administrators have full control permissions for the site collection and all subsites.
- SiteCollectionAdminRemovedSite collection administrator or owner removes a person as a site collection administrator for a site. This activity is also logged when an admin removes themselves from the list of site collection administrators for a user's OneDrive account (by editing the user profile in the SharePoint(...)
- SiteCollectionCreatedA SharePoint or global administrator creates a site collection in your SharePoint Online organization or a user provisions their OneDrive for Business site.
- SiteColumnCreatedA user created a SharePoint site column. A site column is a column that isn't attached to a list. A site column is also a metadata structure that can be used by any list in a given web.
- SiteColumnDeletedA user deleted a SharePoint site column.
- SiteColumnUpdatedA user updated a SharePoint site column by modifying one or more properties.
- SiteContentTypeDeletedA user deleted a site content type.
- SiteContentTypeUpdatedA user updated a site content type by modifying one or more properties.
- SiteDeletedSite administrator deletes a site.
- SiteRenamedSite administrator or owner renames a site
- SitesTotal number of SharePoint sites. Total is taken from the Sharepoint Sites table
- Sites with ActivityTotal number of SharePoint sites within the site collection that have had activity for the report period.
- Skype - % Active Meeting AttendeesCalculation = [Skype - Meeting Attendees] / [Users - All Active]. Where All Active Users are users in active directory, that have an activated O365 license, and have not been suspended or deleted.
- Skype - DevicesA count of devices being used for each user.
- Skype - Meeting AttendeesA distinct count of meeting attendes taken from the Skype Meeting Attendancetable.
- Skype - Meeting OrganizersA distinct count of users who have organized meetings. This is down to a user and is taken from the Skype Meetings table.
- Skype - SessionsA total of sessions in Skype taken from the [Total Sessions] column in the 'Skype Sessions' table.
- SoftDeleteSettingsUpdatedVerified admin updates the setting for the network data retention policy to either Hard Delete or Soft Delete. Only verified admins can perform this operation.
- Storage Space (Bytes)Total storage space availible to a Library Item in bytes
- Storage Space (GB)Total storage space availible to a Library Item in gigabytes
- Storage Space (MB)Total storage space availible to a Library Item in megabytes
- System ActivitiesTotal system generated activities. This is defined by the Activity Type table.
- TabAddedA user adds a tab to a channel.
- TabRemovedA user removes a tab from a channel.
- TabUpdatedA user modified a tab in a channel.
- TeamCreatedA user creates a team.
- TeamDeletedA team owner deletes a team.
- Teams - % Active UsersCalculation = [Teams - Active Users] / [Users - All Active]. Where teams active users are any user who has: Posted a Chat Message, Private message, attended a call, attended a meeting, liking messages, apps, working on files, searching, following/favoritinga team, following/favoriting a channel.
- Teams - All MessagesCalculation =[Teams - Chat Messages] + [Teams - Private Messages] + [Teams - Voice Calls]
- Teams - Chat MessagesThe total chat messages posted in teams. Where a chat messages are the number of unique messages that the user posted in a team chat during the specified time period.
- Teams - DevicesThe average number of people using each client type each day. Each person/device/date combination is counted once. Used in the Teams Device Usage Pie Chart on the Teams Page of tyGraph Pulse
- Teams - MeetingsMeetings is the number of participants who have attended a scheduled teams meetingduring the specified time period. This means that if you were on a group call with three other people there would be four meetings, one for each user who attended.The calculation is asimple total of the(...)
- Teams - Private MessagesA simple total of the [Private Messages] column in the'Teams Activity' table where "Private Messages" are the number of unique messages that the user posted in a private chat during the specified time period.
- Teams - Voice Calls (Calls Card in Pulse)Are the number of calls that the user participated in during the specified time period. Calls include incoming and outgoing calls. So if I phone you and you answer we both get one call. The calculatoin is a simple total of the [Voice Calls] column in the 'Teams Activity' table.
- Teams - WOL %Calculation = [Teams - Chat Messages] / [Teams - All Messages]. Where chat messages are the number ofunique messages that the user posted in a team chat during the specified time period.
- TeamsSessionStartedA user signs in to a Microsoft Teams client. This event doesn't capture token refresh activities.
- ThreadThe first message in a yammer conversation. Does not include messages within a thread.
- Thread Impact([Thread Responses] + [Message Likes] + [Seen By]) * [Thread Contributors] /100
- Thread MessageText content of a thread.
- Thread ResponsesThe total number of responses under a thread. Not inclusive of the initial thread.
- Thread TopicA comma delimited list of all topics associated to a thread.
- Thread TypeA categorical value that describes the type of thread. Categories include: announcement, chat,message,poll, praise, system.
- ThreadInitiatorThe Member Name of the user who started the thread.
- ThreadsNumber of messages that initiated conversations.
- Threads per ContributorThe total threads divided by the total message contributors.
- Threads per DayTotal number of threads initiated in a day. Typically seen averaged out in scenarios where the time period is greater than one day.
- Threads with MentionsNumber of initiating messages that have an @mention.
- Threads with Mentions (%)Percent of initiating messages that have an @mention.
- Threads with ResponsesNumber of initiating messages that have a response.
- Threads with Responses (%)Percent of initiating messages that have a response.
- Threads with TopicsTotal number of threads *and all each threads subsequent messages* that have a topic or topics mentioned below. Example if a thread had 3 topics used in the conversation Threads with Topics would equal 1 for that thread.
- Time Of DayA calculated value of the hour that a message was posted, ranging from 0 to 23.
- TitleName in the form of a title often given to library folders
- TopicA continuous alphanumeric value preceded by a # used to identify the topic, i.e. topic name.
- Topic DirectoryA value assigned to a topic for the sake of categorization and easy indexing. Ex. All topics starting with the letter A will have an A in the field.
- Topic FollowersTotal number of users who have opted to followa a given topic.
- Topic IDUnique numeric value assigned by Yammer that uniquely identifies a topic.
- Topic MentionsNumber of times a topic has been mentioned per thread. Example: If a topic is mentioned twice in messages after the initiating message, it will be counted once. A thread with a topic used in the initiating message and in subsequent ones, no matter how often will still be counted as one topic(...)
- Topic Mentions Running TotalCumulative total of topic mentions for a specified timeframe.
- TopicsUnique number of topics.
- Total GroupsTotal number of active groups as of the last harvest. Not time sliceable.
- tyGraph Access Methodology (Guide)Looking expand access to tyGraph tools to a larger audience in your organization? The tyGraph Access Methodology outlines the basic framework for how we deliver secure and dynamic data for a variety of business roles.
- tyGraph for OneDrive OverviewThe business OneDrive assigned to each employee in the organization, we call the employee OneDrive. The business repository assigned to an employee, we call this the professional OneDrive. Personal OneDrive's are never inclueded in this product.
- tyGraph for SharePoint - OverviewAn excerpt from a September tyGraph Demo outlining the basics of tyGraph for SharePoint. The SharePoint component of the demo runs from 22:23 - 30:57.
- tyGraph for Yammer - Help Tips GuideAn export of every help tip from our Yammer Admin report. This document includes the help-tip pop up information that coincides with every visual for every page.
- tyGraph Online - Manage Access GuideAdmins can control who sees the reports that they administrate. This interface allows each administrator to delegate admin and member rights to other users.
- tyGraph PBIX Installation GuideWill demonstrates how to access and set up a tyGraph Report from a Power BI desktop model.
- tyGraph Pulse - OverviewAn excerpt from a tyGraph demo that outlines the basics of tyGraph for Teams. The Teams component runs from 14:36-22:25
- Types of External UsersThere are two types of external users:Authenticated users with Microsoft accounts and Authenticated users without Microsoft accounts
- Un-engaged Members (dynamic)The unique number of users who have not taken any one of your selected MAE Score acts of engagement in the current report period.
- Un-engaged Members KPISame as engaged members (POP%) but with an up and down arrow KPI Indicator
- Un-engaged Members KPI (dynamic)The percentage change un-engaged members but with an up and down arrow KPI Indicator
- Un-engaged Members (PoP%)The number of users who have not taken any of your selected MAE Actions within for the report period.
- Un-engaged Members PoP% (dynamic)The percentage change in members who have not taken any one of your selected MAE Score acts of engagement from the previous period to the current one.
- Un-engaged Members (previous period)The number of users who have not taken any of your selected MAE Actions in the previous period. The previous period is the same span of dates immediately before your report period. If you are filtered to the last 7 days then the previous period is the 7 days prior to the last date of your(...)
- Un-engaged Members - previous period (dynamic)The unique number of users who have not taken any one of your selected MAE Score acts of engagement in the previous period. The previous period is the same span of dates immediately before your report period. If you are filtered to the last 7 days then the previous period is the 7 days prior(...)
- Unanswered ThreadsThread starters without a response; may include system messages such as "so and so has joined your network" if there was no reply.
- Unanswered Threads (%)Percent of threads that do not have a response.
- UnlockRecordThe record status of a retention label that classifies a document as a record was unlocked. This means that the document can be modified or deleted. Only users assigned at least the contributor permission for a site can change the record status of a document.
- UpdatedDataAccessSettingAdmin updated data access settings.
- UpdatedPrivacySettingAdmin updated privacy settings; for example, minimum group size.
- UploadedOrgDataAdmin uploaded organizational data file.
- Usage ActivitiesTotal activities generated by usage. Also defined by the Activity Type talbe
- User ActivitiesActivities made by users on a site basis. Used for tyGraph for SharePoint - Business User Report which is currently in pre-alpha. Often pivoted on AD data to define SharePoint activity by region, country, location, etc.
- User FollowersNumber of current followers for a specified member.
- User InteractionsNumber of user interactions between two members. Used with Member Name from Users table in combination with Interacted With Member from User Interactions table. This is Date, Group, and Thread sliceable.
- User LikesNumber of likes made by a user. Often pivoted on member name to show the number of likes that member has made on a message(s).
- User Mentions"Total number of mentions. Depending on the context this measure can be used to show mentions received, given, or as a total of a aggregate such as group. By default we see User Mentions pivoted on Mentioned Member Name in the ""Top Mentioned Members"" visual on ""The Network"" page. This(...)
- User MessagesNumber of messages posted by a user.
- User PraisesNumber of times a member or members have been praised.
- UserIDUnique numeric value assigned by Yammer for each user in the network.
- Users - All ActiveIs a baseline score used as the denominator for most percentages in pulse that involve users. This is the a count of all users with an active directory account, O365 license, and are not suspended or deleted.
- Users InteractedThe distinct number of people a user has interacted with.
- Users LikedThe total unique members that liked a messages. This is subject to the filters that you have applied. So if you have selected a thread it will count likes from the responses as well. If you'd like to just count response likes you can filter using the Message table attribute:(...)
- Users MentionedNumber of unique members that have been mentioned.
- Users PraisedNumber of unique members that have been praised.
- UserSuspensionUser account is suspended (deactivated).
- ViewedExploreAnalyst viewed visualizations in one or more Explore page tabs.
- Visual Interactions ButtonAn option in PowerBI to change the way that cross filtering works between visualizations on the same report tab.
- WasPrivateA binary value indicating a message that had previously been private but has since been moved to a group.
- Web TemplateThe name of the template used to create the site
- Web URLA web link to the Yammer site for the given network.
- WebRequestAccessModifiedThe access request settings were modified on a site.
- Week OfA date range for selecting a week of the year. This weekly filter starts each week on a Sunday - Saturday calendar. For example the week of 1 Jul 2018 is Sunday 1 July 2018 - Saturday 7 July 2018
- WOL Score (Working Out Loud)Teams messages formulated by the ratio of teams chat to total teams messages of a user. WOL Score = ([Teams Chat Messages]/[Total Teams Messages])*[Total Teams Messages]
- Working Out Loud GaugeThis is a total of all public groups that currently exist in your Yammer Network. The baseline for the guage is the total number of Yammer Groups in your network.
- Yammer - % Active UsersCalculation = [Yammer - Active Users] / [Users - All Active]. Where[Yammer - Active Users] are any user who has Liked, Read, or Posted for the report period.
- Yammer - Active UsersA distinct count of users who have Liked, Read, or Posted material in Yammer for the report period.
- Yammer - Avg Daily ActivityThe average number of Yammer activities across all tyGraph Pulse (Yammer) activity types. ie. Likes, Reads, and Posts.
- Yammer - DevicesThe total devices being used to access Yammer.
- Yammer - LikesTotal likes made byuser(s) in Yammer.
- Yammer - PostsA total of all messages posted by a user in Yammer. This includes Threads, and replies.
- Yammer - ReadsThe total threads rendered on a users screen, sometimes referred to a "scroll pasts"
- YearYear value of the given date.