Widget settings can be accessed from the More Settings menu of a widget in a dashboard.
| Field | Comments |
|---|---|
| Widget Name |
Unique Name of the widget Eg: "This widget is called {{field_name: x }}" |
| Type | Type of Widget, from various chart types, to grid, etc. |
| Category | Optional, to easily categorize widgets into groups. Category lists are displayed as a dropdown on the widget list |
| Description | Adds a popover description icon on the widget when present |
| Plot Data/Y-Axis | Y-Axis fields, when applicable (Chart types only). Leave empty for multiple series |
| Grouping/ Legend | Grouping for multiple series for chart types, where applicable. Categories show up as separate legend items for each item. |
| X-Axis | X-Axis field name (for chart types) |
| X-Axis Ordering | Specify ordering for X-Axis values |
| X-Axis Type | Enables Date/Time |
| Display Theme | For chart types, there are two theme options available: Light/Dark |
| Data Feed | Live option enables live autoupdated charts. Specify number of seconds to the update the chart |
| Max Records | Maximum number of records to profile for this dataset |
| Footnote | Adds an optional footnote to the bottom of the widget (always visible) |
Chart Settings
Chart settings are only available for the widgets with an XY axis.
| Field | Comments |
| Plot Data/Y-Axis |
Numeric Y-axis field to use. Leave it empty if for multiple Y-axis fields. |
|
Grouping/Legend |
Legend/series field if a column contains the fields. |
| X-Axis |
X-axis field if applicable. |
| X-Axis Ordering | Optional X-axis data ordering if applicable. |
|
X-Axis Type |
Set to date/time for a time series chart. |
| Legend Ordering |
Legend ordering method, if applicable. |
| Y-Axis Max | Optional max Y-axis value. Use it in conjunction with the tick interval to set the Y-axis labels. |
|
Y-Axis Tick Interval |
Optional Y-axis tick interval to set the Y-axis labels. |
| Target Line | Optional value for the target line only applies to the primary Y-axis. It is available for the following widgets: Column, Stacked Column, Bar, Area, Stacked Area, Line, Spline, and Scatter. The bar chart would have a vertical target line. All other charts specified should have a horizontal target line. |
| Stacking - Second X-Axis Group |
Displays a seconds stacking group on the X-axis based on the string field selected. |
| Secondary Y-Axis |
Optional secondary Y-axis on the right-hand side of the chart. |
|
Secondary Chart Type |
Chart type for the secondary chart. |
|
Secondary Chart Send to Back |
If checked, adjusts(z-index) to send the secondary chart behind the first. |
|
Synchronize Y-Axis |
If checked, synchronizes the Y-axis primary and secondary to the same value. |
Display & Formatting
| Field | Comments |
| Title Font Color |
Set the title font color of the widget |
|
Title Font Size |
Set the title font color of the widget. The default title font size is 14px. |
| Font size |
Set the font size of the widget data. The default widget data font size is 10pt. |
|
Font color |
Set the font color of the widget data. The default widget data color is black. |
|
Color of odd rows |
Set the background color of all the odd-numbered rows. The default color of odd rows is white. |
|
Color of even rows |
Set the background color of all the even-numbered rows. The default color of odd rows is white. |
|
Color of Header rows |
Set the background color of header rows. The default color of header rows is dark blue. |
| Header font color | Set the font color of the data in the header row. The default header font color is black. |
|
Header Height |
Set the height of the header. |
| Minimum Column Width |
Apply a minimum grid width to enable horizontal scroll instead of fitting the grid into the viewport in case of a large number of columns. |
| Grid line thickness |
Set the grid line thickness value. |
|
Cells Padding |
Set the padding of cell content. |
|
Row height |
Set the height of each row in the grid. |
| Format |
Set the formatting for one or more fields while providing all the fields in the drop-down list. |
|
Hide Column |
This hides the chosen column from the grid. |
|
Reset Column Width |
Reset each column width to default. |
Data Settings
| Field | Comments |
|
Aggregation |
Apply aggregation for the group on the selected field. It can perform aggregation functions like Min, Max, Total, Avg, Count, and Weighted Avg. |
|
Aggregation on top |
If checked, show the results of the selected aggregation function on top of the widget. |
|
Column Ordering |
Sort the values of the selected column into a descending or ascending order. |
|
Grouping |
Make the different groups according to the values of the selected column. For example, put the rows with a similar value of column cells into the same group. You can also hide the grouping column and collapse the grid to show only the grouping column. |
|
Scroll Limit |
Set the scroll paging limit. The default value is 1000 records. |
| Internal Sparkline Charts |
Allow you to create charts within cells to see trends but the data must be in array form. |
Widget Menu
The options below can be toggled ON/OFF for an individual widget. They are ON by default.
| Option | Description |
| Show Title | Toggle widget title display ON/OFF |
| Analyze | Toggle Analyze (self-service analytics) icon display ON/OFF |
| Alerts | Toggle Alert icon display ON/OFF |
| Filters | Toggle Filters icon display ON/OFF |
| Drilldowns | Toggle Drilldowns option in More Settings ON/OFF |
| Query | Toggle Query Edit option in More Settings ON/OFF |
| Data Diagram | Toggle Data Diagram option in More Settings ON/OFF |
| Refresh | Toggle Refresh widget option in More Settings ON/OFF |
| Remove from Dashboard | Toggle Remove from Dashboard option in More Settings ON/OFF |
More Options
| Option | Description |
| Change Dataset | Change to a different dataset for producing widget data |
| On Click Event Handler |
Define custom javascript behavior when a point is clicked |
Types
We support over 30 types of visualizations and add more regularly. See Visualization Options for more details.