This guide shows how a user can modify an existing data source to create stacking columns that show the number of open tickets assigned to a technician per ticket status.
The procedure applies to other scenarios where users would like to configure widgets to show the breakdown of data in a column.
Step-by-step guide: Creating a stacking column
- Go to Widgets and find the widget to be modified.
- Click on the ellipsis ... button and select Clone.
- On the Clone Widget window, give the widget a new Name, review the Role(s), and add a Description for the widget.
- When done, click Confirm.
- Next, go back to Widgets, find the cloned widget, and open it.
- When the Widget Builder window appears, click the data source icon, then click the ellipsis ... button and select Edit.
- Add another dimension for status.
- Click the + sign.
- Select Status for Fields.
- Rename the Alias to Status. and click Add.
- Scroll down to the Order By section, click the + sign, and select Technician and Status to arrange by Technician and Status. Clicking the arrows will arrange the data in a descending or ascending order.
- Click Save. You will see a prompt that warns about the widget already in use. Click the Save and Continue button on the prompt.
- Lastly, click the Config icon. Select Status for Dimension Group and StackingColumn for Type.
- Click Apply. Your widget now has stacking columns.
Watch the video tutorial