Is it possible to create a stacked time-series visualization (Department vs Software Model) in Perfo

[shubham007]

Hi everyone,

I am currently working on a Performance Analytics dashboard in ServiceNow using par_dashboard (Platform Analytics Workspace dashboards) and have encountered a limitation while trying to design a specific visualization.

Requirement

The objective is to create a time-series visualization that:

• Shows a trend over time
• Is grouped by Department (derived from the assigned user)
• Is further split by Software Model

In essence, for each time period, I would like to display total allocations per department, with a breakdown of software models within each department (i.e., a stacked representation).

Data Context

• Source table: alm_entitlement
• Cost data resides on: alm_license
• Entitlement data is currently being used as a proxy for allocation

Challenge

Based on my analysis:

• Performance Analytics supports time-series visualizations such as line and bar charts
• Breakdowns can be applied (e.g., Department)
• I am building this using PAR dashboards in Platform Analytics Workspace

However, I have not been able to achieve a visualization that combines:

• Time-series trend
• Grouping by Department
• Stacking by Software Model

Questions

1. Is it possible to create a stacked bar or column chart for time-series data in Performance Analytics (specifically within PAR dashboards)?
2. Can multiple breakdowns (e.g., Department and Software Model) be combined in a single time-series visualization?
3. Are there any recommended approaches or workarounds to achieve this type of visualization in Platform Analytics Workspace?

Goal

The goal is to represent allocation trends by department while also showing how different software models contribute within each department over time.

I would appreciate any guidance or best practices from those who have worked on similar requirements.

Thank you.