Cube: Task

Use this cube to report on tasks according to their status, priority, creation date, and due date. You can also report on tasks according to whether or not they are overdue. You can complete the information on tasks with fields from the following dimensions: 

Branch, Branch rollback, Client, Client Name, Employee, Employee Creation, Employee Creation Name, Employee Name, Employee Primary, Employee Update, Employee Update Name, Task.

Cube fields

Task description:

• Task ID
• Task Billlable
• Task Overdue: false or true
• Task Status: closed, on_hold, pending, rejected
• Task Priority: low, normal, important, urgent

Creation and last update date fields:

• Task Creation Year
  Task Creation Month
  Task Creation Day
  Task Creation Month All
  Task Creation Year-Week
  Task Creation Week
  Task Creation Time
  Task Update Year
  Task Update Month
  Task Update Day
  Task Update Month All
  Task Update Year-Week
  Task Update Week
  Task Update Time
  Task Due Year
  Task Due Month
  Task Due Day

Due date fields:

• Due Month All
  Due Year-Week
  Due Week
  Task Due Time