Slide 1: Activity of Project Managers In-Platform

Active Projects Due

No Updates in Last 30 Days

Active Projects With No Managers

Active Projects with 0 RIDAC

Project Managers who have not logged in last 30 days

Project managers with no Projects

No Update

Percentage of Project Managers Logged in Last 30 Days

Users with Project Manager Role

Stakeholders Logging In

Users with at Least 1 Project Assigned to Them

(Heatmap) Active Projects last update

(Heatmap) Project Managers last login

(Horizontal Bar) Active Projects Last updated

(Horizontal Bar) Project Managers Last Login


Active Projects Due

  • 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

No Updates in Last 30 Days

  • 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

Active Projects With No Managers

  • 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

Active Projects with 0 RIDAC

  • 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

Project Managers who have not logged in last 30 days

  • 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

Project managers with no Projects

  • Chart Query Information:

No Updates in Last 30 Days

  • 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

Percentage of Project Managers Logged in Last 30 Days

  • 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

Users with Project Manager Role

  • 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

Stakeholders Logging In

  • 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

Users with at Least 1 Project Assigned to Them

  • 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

(Heatmap) Active Projects last update

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

(Heatmap) Project Managers last login

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

(Horizontal Bar) Active Projects Last updated

  • 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

(Horizontal Bar) Project Managers Last Login

  • 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.

Did this answer your question?