Charts

Instructions on how to create and use the Chart Widget

Adding Chart Widgets

1. In the Edit Mode tab of the Dashboards Building Interface, click the “add a widget” button.

2. Choose the type of chart you want to utilize. You can choose between a Pie, Donut, Bar, Line or Scatter chart.

3. In the top left corner , double click on Untitled widget and provide a name for the selected chart widget.

4. Choose a data source: Tables, Case Management Tables or Case Management Reportings and proceed by selecting the specific table column from the data source you would like to use.

5. Next move on to configure the selected Chart Type in the sections discussed below.

Chart Types and Configuration

Pie

Pie Chart Data Configuration

INFO

The data used to configure the pie chart will be taken from a particular table from the tables feature or case management feature.

As a reminder, chart elements can expose raw data that may be sensitive, and therefore should not be used if you have concerns with viewers being able to see that information.

1. Optional- Under the Filters section, using the [condition builder]condition builder, you can set specific records by condition(s) to filter the underlying data.

2. Underneath the Group by section:

   • Next, choose the table column you want to group the pie chart by. If the selected column is a time period, you will see the Bucket by option, allowing you to categorize the time period. This will be shown as a legend on the right side of the pie chart.

3. Underneath the Values section:

   1. If you select Record Count:

   • The Chart widget will show the total number of records available in the chosen source table.

   OR

   2. If you select Field Function (You can only add a Field Function if the selected column is a numeric value).

   • Choose a column: Time from Status Open to Status, Time in Status or Time to Assign
   • Choose the sum operation that will be used to calculate the selected column values: Sum, Maximum, Minimum, Average or Median.
   

Donut

Donut Chart Data Configuration

INFO

The data used to configure the Donut Chart will be taken from a particular table from the tables feature or case management feature.

As a reminder, chart elements can expose raw data that may be sensitive, and therefore should not be used if you have concerns with viewers being able to see that information.

1. Optional- Under the Filters section, using the condition builder, you can set specific records by condition(s) to filter the underlying data.

2. Underneath the Group by section:

   • Next, choose the table column you want to group the donut chart by. If the selected column is a time period, you will be provided with the Bucket by option, allowing you to group the column according the time period. This will be displayed as a legend on the right side of the donut chart.

3. Underneath the Values section:

   1. If you select Record Count:

   • The Chart widget will show the total number of records available in the chosen source table.

   OR

   2. If you select Field Function (You can only add a Field Function if the selected column is a numeric value).

   • Choose a column: Time from Status Open to Status, Time in Status or Time to Assign
   • Choose the sum operation that will be used to calculate the selected column values: Sum, Maximum, Minimum, Average or Median.

Bar

Bar Chart Data Configuration

INFO

The data used to configure the Bar Chart will be taken from a particular table from the tables feature or case management feature.

As a reminder, chart elements can expose raw data that may be sensitive, and therefore should not be used if you have concerns with viewers being able to see that information.

1. Optional- Under the Filters section, using the condition builder, you can set specific records by condition(s) to filter the underlying data.

2. Set the X axis:

   • Next, choose the table column you want displayed on the X axis. If the selected column is a time period, you will be provided with the Bucket by option, allowing you to group the column according the time period.
   

3. Set the Y axis:

   1. If you select Record Count:

   • It will display the number of records available on the selected source table on the Chart widget.

   OR

   2. If you select Field Function (You can only add a Field Function if the selected column is a numeric value).

   • Choose a column: Time from Status Open to Status, Time in Status or Time to Assign
   • Choose the sum operation that will be used to calculate the selected column values: Sum, Maximum, Minimum, Average or Median.
   

Line

Line Chart Data Configuration

INFO

The data used to configure the Line Chart will be taken from a particular table from the tables feature or case management feature.

As a reminder, chart elements can expose raw data that may be sensitive, and therefore should not be used if you have concerns with viewers being able to see that information.

1. Optional- Under the Filters section, using the condition builder, you can set specific records by condition(s) to filter the underlying data.

2. Set the X axis:

   • Next, choose the table column you want displayed on the X axis. If the selected column is a time period, you will be provided with the Bucket by option, allowing you to group the column according the time period.
   

3. Set the Y axis:

   1. If you select Record Count:

   • The Chart widget will show the total number of records available in the chosen source table.

   OR

   2. If you select Field Function (You can only add a Field Function if the selected column is a numeric value).

   • Choose a column: Time from Status Open to Status, Time in Status or Time to Assign.
   • Choose the sum operation that will be used to calculate the selected column values: Sum, Maximum, Minimum, Average or Median.

Scatter

Scatter Chart Data Configuration

INFO

The data used to configure the Scatter Chart will be taken from a particular table from the tables feature or case management feature.

As a reminder, chart elements can expose raw data that may be sensitive, and therefore should not be used if you have concerns with viewers being able to see that information.

1. Optional- Under the Filters section, using the condition builder, you can set specific records by condition(s) to filter the underlying data.

2. Set the X axis:

   • Next, choose the table column you want displayed on the X axis. If the selected column is a time period, you will be provided with the Bucket by option, allowing you to group the column according the time period.

3. Set the Y axis:

   1. If you select Record Count:

   • The Chart widget will show the total number of records available in the chosen source table.

   OR

   2. If you select Field Function (You can only add a Field Function if the selected column is a numeric value).

   • Choose a column: Time from Status Open to Status, Time in Status or Time to Assign
   • Choose the sum operation that will be used to calculate the selected column values: Sum, Maximum, Minimum, Average or Median.

Editing a Chart Widget

1. In the top-right corner of the selected chart widget, click on the pen icon, and then continue to make any desired changes in the left-hand side bar. Any changes you make will automatically be applied to the Chart Widget.

Deleting a Chart Widget

1. In the top-right corner of the selected Number widget, click on the Pen icon, then in the left-hand sidebar, click the icon in the top-right corner and then select the delete button.

2. The Chart Widget will be removed from your your Dashboard Building Interface.