Field Picker or Data Browser
In the Data Browser; you can select fields to add to your widget.
- An icon appears to the left of each field to indicate its data type (date-time; text or alphanumeric; and numeric):
As you type into the Data Browser; the list is dynamically filtered to only show the fields that contain the text you typed.
Additionally; you can hover over a field in the Data Browser and click More to display additional aggregation (quick functions) and filtering options.
The Default and More option depends on the purpose and the type of the field.
- Categories & Break By can only be shown as a list or filtered list
- Values have a wider range of options. Furthermore; after adding a field you can further click the formula button
to define formulas.
Below is a summary of what to expect depending on the field type. Default aggregations are in bold.
Field Type | Categories / Break By | Values |
Alphanumeric | All Items Filter | Count Unique Count All |
Numeric | All Items Filter | Sum Count Unique Count All Min Max Average Media Variance Standard Deviation |
Date-Time | All Items Year Filter | # Of Years (Months; Quarters; Weeks; Days) |