All articles

Advanced Reporting: Available Data

Overview

Analytic boards are built over a data model that 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.

Available data

The table below contains all the data which can be used whilst building widgets in Advanced Reporting.

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), 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 entry 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 after 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

Top