Slide 1: Activity of Project Managers In-Platform

Table: pm_project

Chart Query Information: This chart pulls and aggregates data for records that have a planned end date before the current date viewing the chart and the actual end date being after the current day of viewing the chart or the actual end date does not contain details.

Query: work_end>javascript:gs.endOfToday()^ORwork_endISEMPTY^end_date<javascript:gs.beginningOfToday()

Aggregate: Count

Table: pm_project

Chart Query Information: This chart pulls and aggregates data for records that have been updated after the last 30 days and have an actual end date after the current date viewing the chart or records that do not have details set for the actual end date.

Query: work_end>javascript:gs.endOfToday()^ORwork_endISEMPTY^sys_updated_on<javascript:gs.beginningOfLast30Days()

Aggregate: count

Table: pm_project

Chart Query Information: This chart pulls and aggregates records that do not have project manager details filled in and the actual end date is empty or the actual end date is after the current day viewing it.

Query: work_end>javascript:gs.endOfToday()^ORwork_endISEMPTY^project_managerISEMPTY

Table: pm_project

Base Chart Query Information: This chart is generated by pulling and aggregating records that have an actual end date after today or Records that have an actual end date that is empty.

Query: work_end>javascript:gs.endOfToday()^ORwork_endISEMPTY

Table: sys_user_has_role

Chart Query Information: This chart will include data pulled and aggregated for records that include role name project management and a user login before the last 30 days or Last log in time is empty.

Query: role.name=project_manager^user.last_login_time<javascript:gs.beginningOfLast30Days()^ORuser.last_login_timeISEMPTY

Aggregate: Count distinct on user

Chart Query Information:

Table: pm_project

Chart Query Information: This chart shows the aggregate of records that have been updated before the last 30 days and have an actual end date after today or they do not have an actual end date assigned to them.

Query: work_end>javascript:gs.endOfToday()^ORwork_endISEMPTY^sys_updated_on<javascript:gs.beginningOfLast30Days()

Aggregate: count

Table: sys_user_has_role

Chart Query Information: This chart pulls the aggregate of records that include the role name project manager and either indicates a last log in time of greater than 30 days ago or a last login time that is empty.

Query: role.name=project_manager^user.last_login_time<javascript:gs.beginningOfLast30Days()^ORuser.last_login_timeISEMPTY

Aggregate: Count distinct on user

Table: sys_user_has_role

Chart Query Information: This chart shows the aggregate of all projects with role name being equal to project manager.

Query: role.name=project_manager

Aggregate: count distinct on user

Table: dmn_stakeholder_register

Chart Query Information: This pulls data that shows the aggregate of records that have task type set to stakeholder registers that are active and have a user login time in the last 30 days.

Query: sys_class_name=dmn_stakeholder_register^active=true^user.last_loginONLast 30 days@javascript:gs.beginningOfLast30Days()@javascript:gs.endOfLast30Days()

Aggregate: count

Table: pm_project

Chart Query Information: This Query creates an aggregate of all occurrences where the data reflects the actual end date being after the current day it is viewed or actual end date is empty while also always having a Project Manager assigned.

Query: work_end>javascript:gs.endOfToday()^ORwork_endISEMPTY^project_managerISNOTEMPTY

Aggregate: count distinct on project manager

Chart Query Information: This heatmap shows which day active projects were last updated.

Chart Query Information: This heatmap shows which day project managers last logged in.

Chart Query Information: This chart will pull active projects and group them by how recently they have been updated on. These will then be grouped by month and reflected in bars of the chart.

Base Chart Query Information: work_end>javascript:gs.endOfToday()^ORwork_endISEMPTY

Time Chart Query Information: for each bucket, group by updated field on the project record

Chart Query Information: This chart will pull in all users with a project manager role and then they will be grouped by the last login time. This will be using month as the trend type.