Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

 Grouped Bar Chart,

 Area

 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:

  • Total Count: Counts the total values in the selected fields, including duplicated values

  • Distinct Count: Counts the distinct (unique) values in the selected fields

  • Document Count: Counts the number of documents that contain at least one value of the selected fields

One field:

  • Total Count: Counts the total values in the selected field, including duplicated values

  • Top 5: Shows the top 5 values in field

  • Top 10: Shows the top 10 values in field

  • Distinct Count: Counts the distinct (unique) values in the selected field

  • Document Count: Counts the number of documents that contain at least one value of the selected field

  • Sum: Adds the values of the field together and only available if the field is a numeric value


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:

  • Cool

  • Natural

  • Ocean

  • Vivid

All Widgets except Data Table

Size

Size of widget:

  • Tiny

  • Small

  • Medium

  • Large

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

DocumentCount

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