Available widgets
- Bar Chart: Displays the count of each data field in a bar graph
- Grouped Bar Chart: Displays the count of a selected data type (Y-Axis) grouped by another data type (X-Axis) as a bar graph
- Area/Line Chart: Displays the count of a selected data type (Y-Axis) against another date type (X-Axis) as line graph
- Pie Chart: Displays the count of each data field in a pie chart
- Tree map: Displays the count of each data field in a tree map
- Data Table: Displays the report snapshot data in a table
- Summary: Displays the count of each data field in a list
- Number Card: Displays the count of each data field in a card box
General settings for Widgets
General Settings
| Field | Description | Availability |
|---|---|---|
| Title (required) | User defined title of widget | All Widgets |
| Select Multiple Fields | Allows you to select several fields in Select Data Field | Bar Chart, Pie Chart, Tree Map, Summary |
| Select Data Field | Select one or more data fields (dependent on choice above). The list of fields is pulled from the output fields of the report associated with the dashboard. If the Select Multiple Fields checkbox is not available for the given widget, Select Data Field will behave as if Select Multiple Fields was checked. | All Widgets (not: Grouped Bar Chart, Area/Line) |
| Operation | Content varies based on widget and the Select Multiple Fields checkbox. If the Select Multiple Fields field is not available for the given widget, the Operation field will behave as if Select Multiple Fields was checked and only allow the Total Count, Distinct Count and Document Count operations. See Multiple select:
One field:
For Grouped Bar Chart and Area/ Line Chart there are unique operators for the X and Y axis depending on the field type. If the Y-axis field is a date-fields the operators Day, Month, Year will be available for the user to summarize per unit of time. | All Widgets except Data Table |
| Color Scheme | Four different color schemes are available:
| All Widgets except Data Table |
| Size | Size of widget:
| All Widgets |
| Show Empty Data Points | Shows data points that are empty or null. Default: Off | Bar Chart Grouped Bar Chart Area/Line Chart |
| Doughnut | Display in doughnut format | Pie Chart |
| Advanced | Advanced view with doughnut and values in percent | Pie Chart |
| Show Labels | Shows the field labels on the pie chart | Pie Chart |
| Show Legend | Check box if you want to show the legend | Bar Chart Grouped Bar Chart Area/Line Chart Pie Chart |
| Show X-axis | Check box if you want to show the X-axis | Bar Chart Grouped Bar Chart Area/Line Chart |
| Show Y-axis | Check box if you want to show the Y-axis | Bar Chart Grouped Bar Chart Area/Line Chart |
| Show X-axis Label | Write a descriptive text for the X-axis | Bar Chart Grouped Bar Chart Area/Line Chart |
| Show Y-axis Label | Write a descriptive text for the Y-axis | Bar Chart Grouped Bar Chart Area/Line Chart |
| Area chart | Check the box if you want to view the data as an area chart. Line chart is the default (unchecked) option | Area/Line Chart |
| Select field for X-axis | Select field for the X-axis | Grouped Bar Chart Area/Line Chart |
| Select field for Y-axis | Select field for the Y-axis | Grouped Bar Chart Area/Line Chart |
Compatibility Matrix
| Select multiple fields | Total count | Distinct Count | Distinct Count | top 5 | top 10 | Show empty data points | Show legend | Show labels | Show x axis | Show y axis | Show x axis label | Show y axis label | Area chart | Doughnut | Advanced | Compatibility with Live Data | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Bar Chart | yes | yes | yes | yes | yes | yes | yes | yes | yes | yes | Only for "Total Count" & multiple fields selected | ||||||
| Grouped Bar Chart | yes | yes | yes | yes | yes | yes | yes | yes | yes | yes | yes | NO | |||||
| Area/Line Chart | yes | yes | yes | yes | yes | yes | yes | yes | yes | yes | yes | yes | NO | ||||
| Pie Chart | yes | yes | yes | yes | yes | yes | yes | yes | Only for "Total Count" & multiple fields selected | ||||||||
| Treemap | yes | yes | yes | yes | Only for "Total Count" & multiple fields selected | ||||||||||||
| Data Table | NO | ||||||||||||||||
| Summary | yes | yes | yes | yes | Only for "Total Count" & multiple fields selected | ||||||||||||
| Number Card | yes | yes | yes | Only for "Total Count" |
Dashboard Count operations example
This paragraph illustrates the Total Count, Distinct Count and Document Count operations.
Below is an example index that contains 7 documents with Phone and Credit Card fields.
| Document ID | Phone | Credit Card |
|---|---|---|
| 1 | phone1 | |
| 2 | phone2 | creditcard1 |
| 3 | phone1,phone3 | |
| 4 | phone3 | |
| 5 | creditcard2 | |
| 6 | phone4 | |
| 7 | creditcard1,creditcard2,creditcard3 |
The count operations will output the following counts with Multiple Fields selected:
| Operations | Phone | Credit Card |
|---|---|---|
| Total Count | 6 | 5 |
| Distinct Count | 4 | 3 |
| Document Count | 5 | 3 |
With Single Field, phone for instance, we get the same numbers only for phone:
| Operations | Phone |
|---|---|
| Total Count | 6 |
| Distinct Count | 4 |
| Document Count | 5 |