Skip to main content

Widget Types

The WIDGETS tab offers eleven visualization types. Each one is covered below with its own Configure panel.

  1. Table
  2. Pivot
  3. Pie
  4. Bar
  5. Column
  6. Line
  7. Area
  8. Donut
  9. Stat
  10. Heat Map
  11. Sunburst

The CREATE A WIDGET grid in the WIDGETS tab, showing all eleven widget types

Figure 1. The CREATE A WIDGET grid in the WIDGETS tab, showing all eleven types.

Widget Header Actions, Common to All Types​

Once any widget is created, its header grows a small toolbar. Table widgets get five icons. Every other type gets four, because the Download action, export to Excel, only appears on Table widgets. Side by side on Team Dashboard, its Table widget's header carries Download, Refresh, View Query, Duplicate, Delete, while its Cases by Type column chart widget carries only Refresh, View Query, Duplicate, Delete.

IconPresent OnWhat It Does
DownloadTable onlyExports the widget's rows as an .xlsx file.
RefreshAll eleven typesRe-runs the widget's query against current data.
View QueryAll eleven typesOpens a Widget Query dialog showing the widget's underlying query as JSON. On Team Dashboard's own Table widget, for example: {"limit": 10, "measures": ["crmServiceCases.count"], "dimensions": ["crmServiceCases.caseStatus"], "timezone": "Asia/Colombo", "offset": 0}, exactly the measures, dimensions, limit, timezone, and offset fields this dialog is built around.
DuplicateAll eleven typesClones the widget, config and all, within the same dashboard or report.
DeleteAll eleven typesOpens a confirmation dialog, "Delete this widget permanently?", before removing it.

1. Table​

The most general type, and the one used throughout the rest of this documentation. A Table widget lays out any number of fields as plain columns, with no implied chart shape.

  1. Click Table in CREATE A WIDGET.
  2. Set a Title and optional Description.
  3. Drag any number of dimension and measure fields onto Columns. Each column chip carries its own mini toolbar: Fill Missing Gaps, Freeze Column, an edit icon, and a remove icon.
  4. Optionally drag a field onto Filters to scope just this widget. Calculated fields are explicitly not supported here.
  5. Optionally drag a date or time dimension onto Time Configuration.
  6. Optionally drag a field onto Sorting. Calculated fields are not supported here either.
  7. Pick a Row Limit: 50, 100, 200, or Custom, up to 10,000.

A freshly created Table widget with an empty Configure Table panel

Figure 2. A freshly created Table widget with an empty Configure Table panel.

The same widget after dragging Case Status and Count onto Columns, rendering real data

Figure 3. The same widget after dragging Case Status and Count onto Columns. Real data renders immediately.

2. Pivot​

A cross tabulation: dimensions spread across two axes, Rows and Columns, with a measure aggregated into each cell, the same shape as a spreadsheet pivot table.

  1. Click Pivot.
  2. Set Title and Description.
  3. Drag one or more dimensions onto Rows.
  4. Drag one or more dimensions onto Columns.
  5. Drag one or more measures onto Values.
  6. Optionally use Filters, Time Configuration, and Sorting, exactly as in a Table widget, and pick a Row Limit up to 10,000, also exactly as in a Table widget.
  7. Under Display & Summary Options, optionally tick Value Color or Column Color to shade cells, and Summary Column or Summary Row to add a totals column or row.

Configure Pivot Table with separate Rows, Columns, and Values drop zones, plus a Row Limit and Display and Summary Options section

Figure 4. Configure Pivot Table: separate Rows, Columns, and Values drop zones, the same Row Limit control a Table widget has, and a Display & Summary Options section with four checkboxes.

info

A Pivot's Configure panel has the same Row Limit control as a Table widget, capped at 10,000, not the lower 20 row cap the chart types below use. A Pivot also carries its own Display & Summary Options, found on no other widget type: Value Color and Column Color checkboxes for cell shading, and Summary Column and Summary Row checkboxes for totals.

3. Pie​

  1. Click Pie.
  2. Set Title and Description.
  3. Drag one dimension onto Slices (Dimension). Each distinct value becomes one slice.
  4. Drag one measure onto Values (Measure). This sets each slice's size.
  5. Optionally use Filters and Sorting, as in a Table widget.
  6. Pick a Row Limit: 5, 10, 15, 20, or Custom. This caps how many slices are drawn.

Configure Pie Chart with a single Slices drop zone and a single Values drop zone

Figure 5. Configure Pie Chart: a single Slices drop zone and a single Values drop zone.

info

Every chart type from here on, Pie through Sunburst, caps its Row Limit at 20, well below the Table and Pivot widgets' 10,000. A pie, bar, or heat map with more than a handful of categories stops being readable, so the builder keeps the ceiling low on purpose.

4. Bar​

Horizontal bars: categories run down the vertical axis, values extend across the horizontal axis.

  1. Click Bar.
  2. Set Title and Description.
  3. Drag a dimension onto Categories (Y-Axis).
  4. Drag a measure onto Values (X-Axis 1).
  5. Optionally drag a second dimension onto Split By / Stack (Dimension) to break each category's bar into stacked segments.
  6. Set a Row Limit, 5 to 20, or Custom, and, further down the panel, an X-Axis Label Angle to rotate long category labels.

Configure Bar Chart with Categories on the Y-Axis and Values on the X-Axis

Figure 6. Configure Bar Chart: Categories on the Y-Axis, Values on the X-Axis, an optional Split By / Stack dimension.

5. Column​

The vertical counterpart to Bar: categories run across the horizontal axis, values rise up the vertical axis.

  1. Click Column.
  2. Drag a dimension onto Categories (X-Axis).
  3. Drag a measure onto Values (Y-Axis 1).
  4. Optionally drag a dimension onto Split By / Stack (Dimension) for stacked columns.

Configure Column Chart, the mirror image of Bar with axes swapped

Figure 7. Configure Column Chart: the mirror image of Bar, with axes swapped. Team Dashboard's own Cases by Type widget, Case Type on Categories and Count on Values, uses exactly this layout.

tip

If you are not sure whether a comparison reads better as Bar or Column, pick Column by default. Reserve Bar for when category labels are long enough that they would overlap on a horizontal axis.

6. Line​

Built for trends over an ordered dimension, almost always a date or time field.

  1. Click Line.
  2. Drag an ordered dimension, typically a date, onto Categories (X-Axis).
  3. Drag a measure onto Values (Y-Axis 1).
  4. Optionally drag a dimension onto Split By / Group (Dimension) to draw one line per distinct value, instead of stacking them.

Configure Line Chart with a Split By slash Group dimension drop zone instead of Stack

Figure 8. Configure Line Chart. Note the third drop zone reads "Split By / Group," not "Stack," since separate lines are drawn side by side rather than layered.

7. Area​

A filled version of Line, sharing Column's exact field layout.

  1. Click Area.
  2. Drag a dimension onto Categories (X-Axis).
  3. Drag a measure onto Values (Y-Axis 1).
  4. Optionally drag a dimension onto Split By / Stack (Dimension) to layer multiple series as stacked, filled bands.

Configure Area Chart, using the Stack label in contrast to Line's Group label

Figure 9. Configure Area Chart, using the Stack label, in contrast to Line's Group label.

8. Donut​

Functionally identical to Pie, a ring in place of a full circle.

  1. Click Donut.
  2. Drag a dimension onto Slices (Dimension).
  3. Drag a measure onto Values (Measure).
  4. Set a Row Limit, 5 to 20, or Custom.

Configure Donut Chart with the same two drop zones as Pie

Figure 10. Configure Donut Chart: the same two drop zones as Pie.

9. Stat​

A single headline number, built for a screen someone glances at rather than reads in detail.

  1. Click the Stat button, labeled with a field-number icon.
  2. Drag a measure onto Values.
  3. Optionally drag a second measure onto Secondary Measure (optional), commonly used for a comparison figure shown alongside the primary number.
  4. Optionally use Filters, as in a Table widget.
  5. Choose a Value Type to control how the number is formatted.

Configure Stat Box with Values, an optional Secondary Measure, and a Value Type selector

Figure 11. Configure Stat Box: Values, an optional Secondary Measure, a Filters drop zone, and a Value Type selector. No Row Limit and no Sorting control appear anywhere in this panel.

Value Type OptionUse For
NumberA plain count or sum, the default.
Percentage (%)A ratio already expressed as a fraction, rendered with a percent sign.
String / TextA measure whose result is a label rather than a quantity.
Time Duration (s → h m s)A duration stored in seconds, rendered as hours, minutes, and seconds.
Time Duration (HH:MM:SS)The same kind of duration, rendered as a clock style string instead.
Live Ticker ((hh:)mm:ss)A duration that keeps counting up in the browser between refreshes, for an in progress timer.
info

Unlike every other widget type, Stat has no Row Limit and no Sorting control in its Configure panel. It only ever shows one value, plus one optional secondary value, so neither setting applies.

10. Heat Map​

A grid of two dimensions, with a measure setting each cell's color intensity.

  1. Click the Heat Map button, labeled with an appstore icon.
  2. Drag a dimension onto X Axis (Dimension).
  3. Drag a second dimension onto Y Axis (Dimension).
  4. Drag a measure onto Values (Measure).
  5. Optionally use Filters and Sorting, as in a Table widget.
  6. Set a Row Limit, 5 to 20, or Custom.

Configure Heat Map with two separate dimension axes plus one measure for cell intensity

Figure 12. Configure Heat Map: two separate dimension axes plus one measure for cell intensity.

tip

Good candidates for the two axes are a time bucket, hour of day or day of week, on one axis and a categorical field, agent, service line, or queue, on the other, with Count or a duration measure driving color.

11. Sunburst​

A nested, ring within ring breakdown, the only type built explicitly for hierarchical data.

  1. Click Sunburst.
  2. Drag two or more dimensions onto Hierarchy, in the order you want the rings to nest, outermost first.
  3. Drag a measure onto Values. This sets each segment's size.
  4. Optionally use Filters and Sorting, as in a Table widget.
  5. Set a Row Limit, 5 to 20, or Custom.

Configure Sunburst Chart with a single Hierarchy drop zone that accepts multiple dimensions

Figure 13. Configure Sunburst Chart: a single Hierarchy drop zone that accepts multiple dimensions.

info

Hierarchy is the only drop zone across all eleven widget types that is explicitly designed to take more than one dimension and treat their order as meaningful. In every other type, dropping a second dimension onto a single field zone replaces the first one instead of nesting it.

Choosing a Type for the Job​

QuestionLean Toward
Need exact, row-level detail someone can scan or exportTable
Need a spreadsheet style cross tabulation of two dimensions, with totalsPivot
Comparing a handful of categories' share of a wholePie or Donut
Comparing categories by magnitude, with long labelsBar
Comparing categories by magnitude, with short labelsColumn
Showing a trend over time, one or more series side by sideLine
Showing a trend over time as a filled, stacked bandArea
One headline number for a screen someone glances atStat
Density across two categorical axes at onceHeat Map
A nested category breakdown, such as service line into case typeSunburst