logo

NJP

Gantt Dashboard & Reporting

Import · Oct 21, 2019 · article

The 'Gantt Dashboard' has been created to address customer requirements first in UK (Lloyds Banking Group), then Switzerland (PMI Philip Morris international), and France (L'Oréal).

It had great feedback from customers, and from ServiceNow people who saw it.

It is enough flexible to address many requirements, and enough complete to be reusable. This share is here to help you to implement your own Gantts.

Note: ServiceNow stopped the "Share" site as of April first 2021. The Gantt Dashboard is now available for the community only.

The update set works for all versions London, Madrid, New York, Orlando, Paris, Quebec, Rome, San Diego. As it only reads data and displays it on a dashboard, it will probably work for future version.

AFAIK my first customer on London version never had to update anything when upgrading to newer versions.

There are two versions of the Gantt Dashboard, the first working with only on table, the second which can work and display multiple tables, to show in the same Gantt Demands plus Projects plus Programs bars for sample.

Attached to this post are two pdf documents. The "multi tables" document "Custom Gantt Guide - multi tables - 04may2020 - v0.8" only describes the differences with the "mono table" document. Please read first the mono table document "Custom Gantt Guide - 25february2020 - v0.7" to understand how it goes.

The mono table code didn't move since 25th February 2020 but it is still valid.

The multi tables still evolves but I didn't have time to update the doc since 4th May. By the way you have some room to play with it before asking for the latest version.

There are two attached update sets.

"ITBM FSC Gantt Dashboard - UPDATE SET - 25february2020 - v0.7.xml" is the update set for the mono table Gantt, the document details how to install it and how to use it. It works on all ServiceNow versions since London.

There are more setups for the multi table Gantt as it comes with custom filters to make up for OOTB missing features. All details in the multi tables doc. They also work on all ServiceNow versions since London.

The update sets for multi table are the files:

  • ITBM Multi-Gantt Configuration 04may2020.xml
  • ITBM Gantt Date Table.xml
  • ITBM PMO Gantt Roadmap.xml

Mono and multi tables update set install all dashboard samples, this is easier to start with all the samples mentioned in the documents.

In addition are two .txt files with the latest code for mono table and multi tables Gantts, only small changes and no bug fix, with files "Mono table - 21april2022.txt" and "Multi tables - 26september2022.txt".

Here after is the change log since December 2020, updated as of 14th October 2022.

"Mono table - 21april2022 - added anchor and hrefs.txt" includes these two updates:

20 April 2022 Add anchortarget layout option, to setup how to open links, default opens in same window, values are _self (default, same window), _blank (opens a new tab)
20 April 2022 Add layout href option to manage URLs when clicking links, this is set with layout "href" option as JSON string with ':' replaced with '#', the sys_id is set in @@ key string. Not compatible with anchorsysid and anchortable.

"Multi tables - 20april2022.txt" includes these updates:

18 December 2020 Add nested data not directly linked to Gantt table, to draw project bars having external links on tasks: new nesteddatatable option
20 December 2020 Add nested data with a stack option, to show stacked nested data on the parent bars, instead to rollup, the number of levels to stack is set in the option, stack and rollup must not be used together
12 January 2021 Add tree bars - Gantt bars apply to tree bars when set on a tree table: set new treebars to map dates, set new ganttbar to get the dates, set new ganttbar to draw the dates
22 January 2021 Add anchortarget layout option, to setup how to open links, default opens in same window, values are _self (default, same window), _blank (opens a new tab)
26 January 2021 Add oGantt.hrefs option to manage URLs when clicking links, this is an object with a key per table to setup, the sys_id is set in @@ key string. Not compatible with anchorsysid and anchortable.
08 February 2021 Add oGantt.treeoptions parameter "dotwalkparentfields: 'true'" to tell to dot walk on tree parent fields, to be able to group by portfolio.portfolio_manager instead of portfolio for sample
17 February 2021 Cleaned code, replaced gs.log() calls by gs.info(), removed getRowCount() call, replaced evaluation method eval() by Function()
20 April 2022 Add column header fields translation from the first table when oGantt.fieldlabels are not set (as it was for mono table Gantt)
20 April 2022 Add calculation of min and max dates in case oGantt.treexxx parameters are not set (flat table)
26 September 2022 Add URL parameters, for instance to get filter from portal page URL, list fields to filter for each table

Screenshots of what can be done (more in the docs):

image

image

image

image

image

View original source

https://www.servicenow.com/community/spm-articles/gantt-dashboard-amp-reporting/ta-p/2298870