ayfie Widgets

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

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: 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	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

	Select multiple fields	Total 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

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

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

Operations	Phone
Total Count	6
Distinct Count	4
Document Count	5