Preserve “Color by Status” formatting when exporting SPW Roadmap

[vandanasaluja]

We have configured the Strategic Portfolio Workspace Roadmap to use the “Color by Status” option. On the roadmap screen, each planning item is displayed in a different color according to its Status value.

However, when the roadmap is exported, the status-based colors displayed in the workspace are not retained correctly in the exported file.

Current behavior:

The “Color by Status” configuration is correctly reflected in the interactive SPW Roadmap. However, the exported output does not preserve the same colors, or it uses default colors instead of the Status colors displayed on the screen.

Expected behavior:

The exported roadmap should retain the exact “Color by Status” formatting displayed in Strategic Portfolio Workspace.

For example:

• Planning items with Green status should appear in green.
• Planning items with Orange status should appear in orange.
• Planning items with Red status should appear in red.
• The exported roadmap legend should show the same Status-to-color mapping, if the legend is included.

The export should represent the current roadmap visualization, including the selected “Color by” preference.

[sandeepdutt]

Hi @vandanasaluja ,

As per ServiceNow Documentations , i don't see anything which tells me that it will preserve the active Color by visualization. The export is intended to capture the roadmap data, but not all interactive display preferences.

[lanyang]

Hi  Vandanasaluja,

When roadmaps are colored by status, here are the OOB (out-of-box) color mappings:

Green (positive): RGB(126, 177, 101, 255)
Red (critical): RGB(238, 118, 131, 255)
Yellow (warning): RGB(246, 236, 96, 255)
No status (gray): RGB(163, 171, 172, 255)

For roadmap display configuration:
Check the Script Include ItemMetadataAPI → override the getColorMap() method

For PPT export configuration:
Check the Script Include PPTRoadmapPlotConfig → configure the getItemFieldColorMaps() method

I've verified both on an OOB instance and they use the same color values.

Could you clarify if you've made any customizations to these Script Includes or related components? Are there any Theme override on your instance? PPT export may also have different color handling depending on your PPT configuration.

Thanks,

Lan

[vandanasaluja]

Yes I have modified the theme and Script includes to incorporate the color coding as per my clients request.

[lanyang]

If you keep the colorMap in both script the same, the color in PPT should match with Roadmap.  

Please make sure you includes all status options.

As for theme, we don't support customizes theme color for Export to PPT.