Widget settings can be accessed from the options menu of a widget in a dashboard.
Settings
| Field | Interpretation |
|---|---|
| Visualization Type | Visualization Type |
| Visualization title | Name for this Widget |
| Category | List of categories to associate the widget to. Categories list dropdown can be found within the widget listing menu. To add a new category, type it in. To add multiple, hit enter after each. |
| Ignore Fields | Ignore one or more fields from the visualization |
| Max Records | Maximum Number of records to run the analysis on. Leave it empty to profile all data for this dataset |
| Live Data | Check the box and specify a frequency for in-dashboard widget auto update (when displayed on a TV screen for example) |
| Description | If set, display a Popover description via an info icon on the widget |
| Footnote | A footnote to display at the bottom of the widget |
| Select Widgets | Select up to 3 widgets (Available only in InstantSights Visualization) |
Chart Configuration
| Field | Interpretation |
|---|---|
| Field containing Size/Count | Size mapping of the text field |
| Field containing text | Select the field that contains the text to analyze |
| Minimal angle | Control the text angle display |
| Max angle | Control the text angle display |
| Plot Data/Y-Axis | Numeric Y-axis field to use. Leave it empty if for multiple Y-axis fields. |
| Y-Axis Categories | Categories displayed vertically for a grid heatmap |
| Sub Categories | Sub Categories for each parent category |
| Minimum color | Color name range minimum |
| Middle Color | Mid range color |
| Max Color | Color name range maximum |
| Quick Picker X-Axis | Quickly change value of X-axis from widget top |
| Quick Picker Y-Axis | Quickly change value of Y-axis from widget top |
| Max Y-Axis Items | Max number of items to display on Y-axis |
| Max X-Axis Items | Max number of items to display on X-axis |
| Enable Y-Axis Scroll | To avoid overcrowding |
| Enable X-axis Scroll | To avoid overcrowding |
| Baseline Value | Custom baseline value |
| Median | Median of the box |
| Lower quartile | Lower quartile |
| Upper quartile | Upper quartile |
| Low whisker | Low whisker |
| High whisker | High whisker |
| Theoretical mean | Theoretical mean |
| Invert Axes | To invert the axes |
| 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. |
| Show Total | When checked, the total sum across the entire series will be displayed at the end |
| Bubble Size Field | Denotes the size of the bubble |
| Intermediate sum | When this property is set, the points act as a summary column for the values added or subtracted since the last intermediate sum |
| 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. |
| Historical/Current Value | Set the field with historical/current values |
| Y-Axis Min | Set the Y-axis minimum values |
| Projections | Set the field with projected values |
| Lower boundary | Lower boundary field name |
| Upper boundary | Higher boundary field name |
| X-Axis Sub Groups (Beta) | To create multiple X-axis sub groups |
| Y-Axis Logarithmic Scale Axis | For log scale, enter logarithmic |
| Y-Axis Values in Reverse Order | Check to reverse the axis so that the highest number is closest to the origin |
| Enable Stacking | Enable stacking for bar chart |
| Anomaly Algorithm | Anomaly forecasting algorithm |
| Anomaly Deviation | Mean absolute percentage threshold setting |
| Max Value | Goal value |
| Min Value | Start value |
| Start Color | Enter color name or code |
| Color - Mid Point | Enter color for the mid point of the gauge |
| End Color | Color stop at the end of the scale |
| First Range Value | Numeric stop value for the first range |
| Second Range Value | Numeric stop value for the second range |
| Third Range Value | Numeric stop value for the last range |
| First Range Color | Color stop value for the first range |
| Second Range Color | Color stop value for the second range |
| Third Range Color | Color stop value for the third range |
| Center Latitude | Map center latitude |
| Center Longitude | Map center longitude |
| Zoom Level | Map zoom level |
| Marker Pin Text | To display the text on the marker when clicked |
| Map Type | Type of map |
| Tile Provider | Geo tile provider for look and feel options |
| Point Styles | Display points as cluster groups, simple pins, or heatmap |
| Count Field | If you have lat/long points with a weighted number field |
| Marker Color Field | Customize marker color, where the field selected contains the marker color to display |
| Radius | The radius of influence for each data point |
| Max Opacity | Ranges from 0 to 1 to control the look and feel of the heatmap |
| Min Opacity | Ranges from 0 to 1 to control the look and feel of the heatmap |
| Blur Factor | To control the gradient |
| Primary Region | Set a region displaying on the map |
| Tooltip | Tooltip display mode |
| Border Resolution | The resolution of borders |
| Metric to Track | Field to show |
| Previous Value | Last value to compare to |
| Percent Change | Percentage change calculation |
| Original Value | Show/hide original value |
| Threshold Value | Enter threshold value to check against |
| Color - Below/Equals Threshold | Defaults to red |
| Color - Above Threshold | Defaults to green |
| Metric Field | Field to set threshold against |
| From | Choose the field that represents from |
| To | Choose the field that represents to |
| Counts/Values | Choose the field that represents the counts |
| Ordering of nodes | To set nodes |
| Step change angle | Control the angle display step |
| Font | To specify the font |
| Font size | To specify the font size |
| Days on Screen | Set the days on screen |
| Start Time | Set the start time |
| End Time | Set the end time |
| Group Field | Group field |
| Event Type | Label on the left hand side to group by items |
| Text code | Enter text or HTML code |
| Web page link | Enter webpages URL link |
| Image URL | Add image URL |
| X coordinate | Represents X coordinate |
| Y coordinate | Represents Y coordinate |
| Point Size | Defaults to 1 |
| Point Color | Defaults to red |
| Bottom Left Zero Position | Defaults to top left |
| Scale Coordinates | Can be integer or decimal |
| Group By | Select a field to group points by |
| Hover Fields | Fields to show when hovering on points |
| Edges type | Select which edges type to display |
| Integration type | Determines how forces are applied on the particles |
Display & Formatting
| Field | Interpretation |
|---|---|
| Title Font Color | Set the title font color of the widget |
| Title Font Size | The default title font size is 14px. |
| Font size | To set the size of the font |
| Font color | To set the color of the font |
| Label font size | To set the label font size |
| Label font color | To set the label font color |
| Vertical | Change orientation to vertical |
| Align content horizontally | Align content horizontally |
| Align content vertically | Align content vertically |
| Hide field names | Do not display field names |
| Strong field names | Use bold fonts for field names |
| Up caret color | Defaults to green |
| Down caret color | Defaults to red |
| Grid line thickness | Grid line thickness value |
| Cell Padding | Padding of cell content |
| Data Format | Formatting for one or more fields |
| Display Theme | Select a theme for chart types |
| Colors | Set color for chart |
| Legend Alias | Change legend display text |
| Background Color | Change background of widget |
| Legend Ordering | Legend ordering method, if applicable. |
| Percent Stack Type | To display stacking as a percent |
| Display "Total" | To show total |
| Legend Show/Hide | Display legend when enabled |
| Legend font size | Font size of the legend |
| Reverse Legends | To reverse the order of the legend items |
| Fit To Widget Width | To make columns shrink to fit widget width to eliminate horizontal scroll |
| Footer Font Size | To set the font size of the footer |
| Footer Row Height | To set the row height of the footer |
| Text Wrap | Allow cells text to break on multiple lines |
| Single Row Representation | collapse all nested rows to single row |
| Y-Axis Grid Line width | Defaults to 1; set to 0 to hide grid lines |
| Enable Reverse Stacking | To reverse stacking |
| Data labels around marker | Allow data labels to follow marker's shape |
| Vertices radius | Default to 10 |
| Edges width | Set edges line width |
| Vertices color | Set color name for vertices color |
| Edges color | Set color name for edges color |
| Data Labels Position | Set data labels position relatively to vertices |
| Column (bar) width | Set the width for columns or bars in pixels |
Column and Header Settings
| Field | Interpretation |
|---|---|
| Header Background Color | Set the header background color; default to dark blue |
| Header Font Color | Set the header font color; default to black |
| Header Font Size | Set the header font size |
| Header Height | To adjust the height of the header |
| Minimum Column Width | To set the minimum grid width |
| Column Ordering | column ordering |
| Column Sort Order | Sorting order of column headers |
| Hide Last Header Row | To hide the last header row |
| Total Column | Additional column with summary for each row |
| Hide Column | To hide the column from the grid |
| Reset Column Width | Reset each column width to default |
Row Settings
| Field | Interpretation |
|---|---|
| Color of Odd Rows | Default to white |
| Rows Font Color | Set the font color of rows |
| Rows Font Size | Set the font size of rows |
| Rows Background Color | Default to white |
| Total Row | Footer row with summary for each column |
| Auto Collapse Rows | Shows all rows initially collapsed |
| Color of Even Rows | Default to white |
| Row Height | The height of each row in the grid |
Aggregation and Grouping
| Field | Interpretation |
|---|---|
| Aggregation | Aggregation for group |
| Grouping | Grouping by some parameters |
| Aggregation on top | Check to show aggregation on top |
Widget Labels
| Field | Interpretation |
|---|---|
| Label - Display as Percent | Convert display label values to percentage |
| Label - Display value | Display the series name and associated values |
| Display Y-Axis Title | Display Y-axis title; enabled by default |
| Y-Axis Label Display | Hide/show Y-axis labels |
| Y-Axis Title Text | Title for Y-axis |
| X-Axis Title | Title for X-axis |
| X-Axis Label Display | Hide/show X-axis labels |
| X-Axis Label Rotation | Degrees of rotation of X-axis labels; useful for long labels |
| X-Axis Date Formatter | Override the default X axis date format. Only applicable for chart types with Date/time X axis. See formats here |
| X-Axis labels format as data units | Bytes, KB, MB, GB, etc. |
| Stack Label Display | Set false to turn off column total data label |
| Stack Label Font Size | Stack label font size |
| Data Label Display | Check to display value labels. Default is false |
| Data Label Font Size | Enter font size, if the display label is set to true. Example: 15px. Defaults to 9px. |
| Data Label Formatter | For formatting help |
| Y-Axis Labels Formatter | For formatting help |
| Data Label Decimal Places | Number of decimal places in data label |
| Symbol After Data Label | Symbol to display after data label |
| Data Label Padding | Set padding around data labels |
| Data Label Allow Overlap | To allow data labels to overlap |
| Data Labels X Offset | The X position offset of the label relative to the point in pixels |
| Hover Label Format | For formatting help |
| Data Labels Y Offset | The Y position offset of the label relative to the point in pixels |
| Hover Decimal Places | Number of decimal places to show on tooltip |
Secondary Chart Configuration
| Field | Interpretation |
|---|---|
| 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 grouping | Display a second stacking groups on the X-axis based on the string field selected |
| Synchronize Y-axis Ticks | Align primary and secondary chart axis tick marks |
| Secondary Chart Send to Back | Adjusts (z-index) to send the secondary chart behind the first. |
| Synchronize Y-Axis values | Synchronizes the Y-axis primary and secondary to the same values. |
| Secondary Y-Axis Max | Set the Y-axis max values for the secondary Y-axis. x-axis fields |
| Secondary Y-Axis Logarithmic Axis | For log scale, enter logarithmic |
| Secondary Y-Axis Min | Set the Y-axis min values for the secondary Y-axis |
Secondary Chart Display
| Field | Interpretation |
|---|---|
| Secondary Y-Axis Title Display | Display secondary Y-axis; enabled by default |
| Secondary Data Label Display | Display secondary value labels; default is false |
| Secondary Y-Axis Title Text | Title for secondary Y-axis |
| Secondary Data Label Formatter | For formatting; click [here](https://staging.knowi.com:9443/docs/labelformatting.html) |
| Secondary Y-Axis Labels Formatter | For formatting; click [here](https://staging.knowi.com:9443/docs/labelformatting.html) |
| Secondary Y-Axis Symbol Before Data Label | Symbol to display before data label for secondary Y-axis |
| Secondary Y-Axis Symbol After Data Label | Symbol to display after data label for secondary Y-axis |
| Secondary Data Label Decimal Places | Number of decimal places in data label for secondary Y-axis |
| Secondary Data Labels X Offset | The X position offset of the label relative to the point in pixels |
| Secondary Y-Axis Value in Reverse Order | Click to reverse the axis so that the highest number is closest to the origin |
| Secondary Data Labels Y Offset | The Y position offset of the label relative to the point in pixels |
Widget Menu
| Field | Interpretation |
|---|---|
| Show Title | Show Title on Widget |
| Analyze | Show Analyze menu |
| Alerts | Show Alert icon |
| Filters | Show Filter icon |
| Drilldowns | Show Drilldowns menu |
| Query | Show Query menu |
| Data/Export | Show Data/Export menu |
| Data Diagram | Show Data Diagram |
| Share | Show Share menu |
| Refresh | Show Refresh menu |
| Maximize | Show Maximize menu |
|
Remove from Dashboard |
Show Remove from Dashboard menu |
|
InstantSights |
Show InstantSights |
Advanced Configuration
| Field | Interpretation |
|---|---|
| Animation | Animation of chart, ON by default |
| Time Series Navigator | Enable/Disable time series navigator at the bottom of a time series chart; enabled by default |
| Polar | To transform cartesian charts like line, spline, area and column into the polar coordinate system |
| Use UTC for Time Series Charts | Disable auto browser conversion of Timezone for the time series charts and show UTC timestamps |
| X-Axis Ordinal | Points are equally spaced in the chart regardless of the actual time or x distance between them |
| Use GPU Translations in Boost Mode | When in boost mode, GPU translations are faster than regular JS translations |
| Scroll Limit | Scroll paging; default is 1000 records |
| Internal Sparkline Charts | Allows you to create charts within cells to see trends |
| Enable Pivot Configuration | Displays the configure button for pivot tables for non-viewer roles |
| Reset Pivot Structure | Clear all rows, columns, values, and filters |
| Change Dataset | Change to a different dataset |
| On Click Event Handler | Define custom javascript behavior when a point is clicked |
Other
| Field | Interpretation |
|---|---|
| Custom Tile Provider | Custom tile provider URL |
| Custom WMS | Custom layers URL |
| Custom Map Layers | Layers names |
| GeoJSON URL | Optional GeoJSON for additional layering |
| GeoJSON Code | Optional GeoJSON for additional layering |
| Custom Javascript Handler | Optional Javascript for additional handling |