Configure Breakdown

[Brian Lancaster]

How can I configure a Breakdown that will give me the assignment groups in my time series widget. But instead of having to choose individual groups they can choose cost center which is associated with that groups? 

[Riya Verma]

Hi @Brian Lancaster ,

Hope you are doing great.

technical solution to implement the Breakdown functionality:

1. Create a new field in the Assignment Group table to store the cost center information.

2. Establish a relationship between the Assignment Group and the Cost Center tables.

3. Modify the time series widget to include the Breakdown functionality.

4. Configure the widget to display assignment groups based on the selected cost center(s).

sample code snippet for the Breakdown configuration:

// Create a new field "cost_center" in the Assignment Group table
// This field will store the cost center information for each group

// Establish a relationship between the Assignment Group and Cost Center tables
// Use reference fields to link Assignment Group records with their respective cost centers

// Modify the time series widget to include the Breakdown functionality
// Add a dropdown or input field to allow users to select cost center(s)

// Use GlideAjax or other ServiceNow APIs to filter the Assignment Group records based on the selected cost center(s)

// Update the time series widget query to display assignment groups associated with the chosen cost center(s)
// The updated query should retrieve Assignment Group records that match the selected cost center(s)

// Display the results in the time series widget, showcasing assignment groups based on the chosen cost center(s)

// Ensure that the widget interface is intuitive and user-friendly, enabling users to easily select cost centers and view the relevant assignment groups.

[Brian Lancaster]

There is already a field on the group called cost center. It is a reference back to the cost center table. I already have breakdown for cost center that is connected to the group.cost_center. However when someone chooses the cost center it just combines all the group in that cost center instead of displaying each individual group that are a member of the cost center.

[jeffrubinoff]

This is a low tech suggestion, but are you really using a time series widget? A time series widget shows only one element of a breakdown. To show a time series of multiple breakdown elements, you have to use a breakdown widget with a line visualization or a columns and total visualization.