All articles

Wrike Analyze: Available Data

Wrike Analyze is a paid add-on available to regular users on Business and higher accounts.

Overview

Analytics boards in Wrike Analyze are built over a data model which contains key Wrike workspace entities and building blocks, such as Spaces, folders, tasks, timelogs, users and history of status changes.

You can visualize or filter any attribute of any entity. Entities are already connected to each other behind the scenes, so you can build boards that span multiple entities, without specifying relations between entities.

To learn how to build widgets and analytics boards please go to the Wrike Analyze Help Center page.

Available Data

The table below contains all the data which can be used whilst building widgets in Wrike Analyze. Note, that the names of the fields marked with an asterisk * can differ in other Wrike work views (for example, Table view); thus, the names of these fields as reflected in the Wrike workspace, are represented in brackets.

Click here to see the full available data model.

Field Name Description Type
Project All projects shared with current user  
Project ID ID of the project, as seen in workspace Numeric
Project Name Name of the project String
Project Creation Date Date when the project was created Date
Project Completion Date Date when project status was changed into Completed Status Group. Empty if the project is in any status from the Active, Deferred or Cancelled Status Groups Date
Project Start Date Planned project start date Date
Project Due Date Planned project due date Date
Project Status Status of the project String
Project Status (Color) Status of the project combined with its color representation. Use this field in Pie, Bar, Pivot and other charts to make the color match the workspace color of the status String
Project Status Group Status Group of the selected project status. Can be one of Active, Completed, Deferred or Cancelled groups. String
Project Workflow Workflow applied to the selected project String
Project Author User who created the project String
Project Link Link to the project view in workspace String
Project Owner Users, assigned as project owners  
Project Owner ID ID of user who is the project owner Numeric
Project Owner Project owner’s name String
Folder All folders and Spaces shared with current user  
Folder ID ID of the folder/Space, as seen in workspace Numeric
Folder Name Name of the folder String
Folder/Project Custom Field Folders/projects/Spaces custom field values*  
Folder/Project Custom Field ID Numeric ID of the custom field Numeric
Folder/Project Custom Field Name Name of the custom field String
Folder/Project Custom Field Name (ID) Name of the custom field and ID. It's used to distinguish between custom fields with the same name String
Folder/Project Custom Field Type Type of custom field. Can be one of Text, Enumeration* (Dropdown), Numeric* (Number), Date, Boolean* (Checkbox), Money* (Currency), , Percent* (Percentage), Duration, User, Multiselect* (Multiple select) String
Folder/Project Custom Field Any Value Value of the field in string format, always filled in String
Folder/Project Custom Field Date Value Date value of the custom field. Only filled in if the data type is Date Date
Folder/Project Custom Field Text Value String value of the field. Only filled in if the custom field type is Text, Enumeration* (Dropdown) or Multiselect* (Multiple select) String
Folder/Project Custom Field Numeric Value Numeric value of the custom field. Only filled in if the custom field type is Numeric* (Number), Money* (Currency) or Percent* (Percentage), Duration or type is Enumeration* (Dropdown), Multiselect* (Multiple select) and values are numeric Numeric
Folder/Project Custom Field Checkbox Value Checkbox value - true or false. Only filled in if type is Boolean* (Checkbox) Boolean
Folder/Project Custom Field User Value Name of the user, only filled in if the custom field type is User String
Task All tasks shared with current user. Tasks from projects or folders not shared with the user will not be shown  
Task ID ID of the task Numeric
Task Name Name of the task String
Task Creation Date Date when the task was created Date
Task Start Date Planned start date of the task Date
Task Due Date Planned due date of the task Date
Task Completion Date Date when task status was changed into any status from the Completed, Deferred or Cancelled Status Groups. Empty if the task is in any status from the Active Status Group Date
Task Status Status of the task String
Task Status (Color) Status of the task combined with its color representation. Use this field in Pie, Bar, Pivot and other charts to make the color match the workspace color of the status String
Task Status Group Status Group of the task status. Can be one of Active, Completed, Deferred, Cancelled groups String
Task Workflow Workflow of the status assigned to a task String
Task Duration (days) Duration of the task in days Numeric
Task Author User who created the task String
Task Importance Importance of the task. Can be High, Normal or Low String
Task Link Link to the task view in workspace String
Task Effort Mode Possible options: None, FullTime, Basic, Flexible String
Task Effort (minutes) Effort of the task in minutes Numeric
Task Billing Type Task billing type (Billable/Non-billable) String
Ignore Excluded Days Shows if weekends and holidays are ignored when calculating task duration Boolean
Task Assignee Assignees of tasks  
Task Assignee ID ID of the user who is task assignee Numeric
Task Assignee Name of task assignee String
Task Custom Field Custom field values of a task*  
Task Custom Field ID Numeric ID of the custom field Numeric
Task Custom Field Name Name of the custom field String
Task Custom Field Name (ID) Name of the custom field and ID. It's used to distinguish between custom fields with the same name String
Task Custom Field Type Type of the custom field. Can be one of Text, Enumeration* (Dropdown), Numeric* (Number), Date, Boolean* (Checkbox), Money* (Currency),  Percent* (Percentage), Date, Duration, User, Checkbox, Contacts, Multiselect* (Multiple select) String
Task Custom Field Any Value Value of the custom field in string format, always filled in String
Task Custom Field Date Value Date value of the custom field. Only filled in if the custom field type is Date Date
Task Custom Field Text Value String value of the field. Only filled in if the custom field type is Text, Enumeration* (Dropdown) or Multiselect* (Multiple select) String
Task Custom Field Numeric Value Numeric value of the field. Only filled in if the custom field type is Numeric* (Number), Money* (Currency) or Percent* (Percentage), Duration or type is Enumeration* (Dropdown), Multiselect* (Multiple select) and values are numeric Numeric
Task Custom Field Checkbox Value Checkbox value - true or false. Only filled in if type is Boolean* (Checkbox) Boolean
Task Custom Field User Value User Name, only filled in if the custom field type is User String
Task Attributes in Folder/Project Attributes of tasks relative to its folders/projects  
Task Depth Level Depth level of task within the project. 1 means that task is directly attached to a folder or project; subtask or task of the child folder/project can have depth level of 2 and more Numeric
Timelog Timelog entries  
Timelog User ID ID of the user who logged time Numeric
Timelog User Name Name of the user who logged time String
Timelog Date The timelog was created for this date Date
Timelog Time Spent (minutes) Time spent in minutes Numeric
Include Data From Top-level filter used to present information from only certain Spaces/folders. Typically such filter is applied based on the Space/folder selected when creating an analytics board  
Include Data From Name Name of folder/project/Space that limits information displayed in the analytics board String
Include Data From Name (ID) Name of folder/project/Space that limits information displayed in the analytics board, along with its ID. It is used to distinguish folders with the same name String
Include Data From Depth Level Level of depth of information displayed in the analytics board relative to Include Data From folder that limits the displayed information. For example, you can filter on Include Data From Depth Level = 1 to exclude subfolders from the board Numeric
Task Status Change History History of the task status change. It includes the current/previous task status and time spent in the previous status before the change  
Task Status Change History User Name User who made the change String
Task Status Change History Previous Change Date Date when the status of the task was changed to the previous one. If there was no previous change, this equals to task creation date Date
Task Status Change History Change Date Date when the change was made or the current date/time, if last task status is from the Active Status Group Date
Task Status Change History Old Status Status value before the change String
Task Status Change History Old Status Ordered Status value before the change. Statuses are shown in the same order as they are in the workflow itself. It is useful for seeing status changes within one workflow String
Task Status Change History Old Status Ordered (Color) Status value before the change. Statuses are shown in the same order as they are in the workflow itself, with its color representation. It is useful for seeing status changes within one workflow. Use this field in Pie, Bar, Pivot and other charts to make the color match the workspace color of the status String
Task Status Change History New Status Status value after the change String
Task Status Change History New Status Ordered Status value after the change. Statuses are shown in the same order as they are in the workflow itself String
Task Status Change History New Status Ordered (Color) Status value before the change. Statuses are shown in the same order as they are in the workflow itself, with its color representation. It is useful for seeing status changes within one workflow. Use this field in Pie, Bar, Pivot and other charts to make the color match the workspace color of the status String
Task Status Change History Time Spent (minutes) Amount of time task spent in the previous status prior to the change, in minutes Numeric
Project Status Change History History of the project status change. It includes the current/previous project status and time spent in the previous status before the change  
Project Status Change History User Name User who made the change String
Project Status Change History Previous Change Date Date when the status of the project was changed to the previous one. If there was no previous change, this equals to project creation date Date
Project Status Change History Change Date Date when the change was made or the current date/time, if last project status is from the Active Status Group Date
Project Status Change History Old Status Status value before the change String
Project Status Change History Old Status Ordered Status value before the change. Statuses are shown in the same order as they are in the workflow itself. It is useful for seeing status changes within one workflow String
Project Status Change History Old Status Ordered (Color) Status value before the change. Statuses are shown in the same order as they are in the workflow itself, with its color representation. It is useful for seeing status changes within one workflow. Use this field in Pie, Bar, Pivot and other charts to make the color match the workspace color of the status String
Project Status Change History New Status Status value after the change String
Project Status Change History New Status Ordered Status value after the change. Statuses are shown in the same order as they are in the workflow itself. String
Project Status Change History New Status Ordered (Color) Status value before the change. Statuses are shown in the same order as they are in the workflow itself, with its color representation. It is useful for seeing status changes within one workflow. Use this field in Pie, Bar, Pivot and other charts to make the color match the workspace color of the status String
Project Status Change History Time Spent (minutes) Amount of time project spent in the previous status prior to the change, in minutes Numeric
Sharing Service table  
Account ID Service field Numeric
Folder/Project ID Service field Numeric
User ID Service field Numeric
Sharing for Include Data From Service table  
Account ID Service field Numeric
Folder/Project ID Service field Numeric
User ID Service field Numeric

* Custom fields that aren't shared with everyone in the account or don't have any values will not be present.

0 comments

Article is closed for comments.

Top