Task Statistics

Calculates task statistics.

All data for this function is collected using ServiceNow Aggregate API. In case the Aggregate API is disabled, ServiceNow Table API is used.

Columns

  • Closed - The number of tasks, that were closed today.

  • Created - The number of tasks, that were created today.

  • Longest Waiting - The queue time of the longest waiting task. Formula:
    For tasks that meet the condition: ^assigned_to=^closed_at=^active=true. The formula returns the maximum difference between sys_created_on and the current time.

  • Opened - The number of tasks, that were opened today.

  • Table Name - The name of the table.
    Contains values of Table Name type.

Calculation Parameters

The Grid function has these optional parameters:

  • Assignment Group - Allows you to select from a list of Assignment group names.

  • Company Name - Allows you to select from a list of Company names.

  • Priority - Allows you to select from a list of Task Priorities.

  • State - Allows you to select from a list of Task states.

  • Table - Allows you to select from a list of Task tables.