Pie Specific Options:
Plot data/Y-axis Data to be displayed on chart
Series/Legend Different groupings of data
Secondary Chart Type Chart type for the second display
Display Theme Background color of the chart (light or dark)
Column Specific Options:
Plot data/Y-axis Data to be displayed on chart
Series/Legend Different groupings of data
X-axis Category displayed on the X-axis
X-axis Ordering Ascending or descending
X-axis Type If a time series chart, set to date/time
Secondary Y-axis Second Y-axis to be placed on the right side of the chart to make a second set of grid points
Secondary Chart Type Chart type for the second display
Display Theme Background color of the chart (light or dark)
Stacked Column Specific Options:
Plot data/Y-axis Data to be displayed on chart
X-axis Category displayed on the X-axis
X-axis Ordering Ascending or descending
X-axis Type If a time series chart, set to date/time
Series/legend Different groupings of data
Secondary Y-axis Second Y-axis to be placed on the right side of the chart to make a second set of grid points
Secondary Chart Type Chart type for the second display
Display Theme Background color of the chart (light or dark)
Bar Specific Options:
Plot data/Y-axis Data to be displayed on chart
X-axis Category displayed on the X-axis
X-axis Ordering Ascending or descending
X-axis Type If a time series chart, set to date/time
Series/legend Different groupings of data
Secondary Chart Type Chart type for the second display
Display Theme Background color of the chart (light or dark)
Area Specific Options:
Plot data/Y-axis Data to be displayed on chart
X-axis Category displayed on the X-axis
X-axis Ordering Ascending or descending
X-axis Type If a time series chart, set to date/time
Series/legend Different groupings of data
Secondary Y-axis Second Y-axis to be placed on the right side of the chart to make a second set of grid points
Secondary Chart Type Chart type for the second display
Display Theme Background color of the chart (light or dark)
Stacked Area Specific Options:
Plot data/Y-axis Data to be displayed on chart
X-axis Category displayed on the X-axis
X-axis Ordering Ascending or descending
X-axis Type If a time series chart, set to date/time
Series/legend Different groupings of data
Secondary Y-axis Second Y-axis to be placed on the right side of the chart to make a second set of grid points
Secondary Chart Type Chart type for the second display
Display Theme Background color of the chart (light or dark)
Line Specific Options:
Plot data/Y-axis Data to be displayed on chart
X-axis Category displayed on the X-axis
X-axis Type If a time series chart, set to date/time
Series/legend Different groupings of data
Secondary Chart Type Chart type for the second display
Display Theme Background color of the chart (light or dark)
Spline Specific Options:
Plot data/Y-axis Data to be displayed on chart
X-axis Category displayed on the X-axis
X-axis Type If a time series chart, set to date/time
Series/legend Different groupings of data
Secondary Chart Type Chart type for the second display
Display Theme Background color of the chart (light or dark)
Scatter Specific Options:
Plot data/Y-axis Data to be displayed on chart
X-axis Category displayed on the X-axis
X-axis Type If a time series chart, set to date/time
Series/legend Different groupings of data
Secondary Chart Type Chart type for the second display
Display Theme Background color of the chart (light or dark)
Bubble Specific Options:
Plot data/Y-axis Data to be displayed on chart
X-axis Category displayed on the X-axis
X-axis Type If a time series chart, set to date/time
Series/legend Different groupings of data
Secondary Chart Type Chart type for the second display
Display Theme Background color of the chart (light or dark)
Bubble Size Field Denotes what the bubble will represent
Funnel Specific Options:
Plot data/Y-axis Data to be displayed on chart
Series/legend Different groupings of data
Secondary Chart Type Chart type for the second display
Display Theme Background color of the chart (light or dark)
Gauge/Goal Specific Options:
Plot data/Y-axis Data to be displayed on chart
Start Value Starting value of the gauge
Max Value Maximum value of the gauge
Start Color Color of the,gauge when it is at the starting value
Color Mid-Point Color of the gauge when it is nearing the middle value
End Color Color of the gauge when it is nearing the ending value
Data Grid - Heat Maps Specific Options:
Plot data/Y-axis Data to be displayed on chart
Categories The categories displayed vertically
X-axis Category displayed on the X-axis
Max Color Color of the maximum values
Min Color Color of the minimum values
Baseline Value Baseline number the data will be based off
Display Theme Background color of the chart (light or dark)
Quick Picker X-Axis Displays a dropdown to quickly change X-axis column
Quick Picker Y-Axis Displays a dropdown to quickly change Y-axis column
Enable Y-Axis Scroll Puts a scrollbar for items more than Y axis max
Enable X-Axis Scroll Puts a scrollbar for items more than the defined values in X axis max
Geo - Marker Pins Specific Options:
Maps Center Latitude Latitude for a specific address
Maps Center Longitude Longitude for a specific address
Zoom Level Magnification level
Map Type Roadmap,satellite, hybrid, or terrain
Geo - Clusters/Custom:
Maps Center Latitude Latitude for a specific address
Maps Center Longitude Longitude for a specific address
Zoom Level Magnification level
Marker Pin Text Field to display text for a pin. If empty, a combination of fields are displayed.
Custom Tile Provider Add your own custom tile
Custom JavaScript
Geo - Heat Maps Specific Options:
Maps Center Latitude Latitude for a specific address
Maps Center Longitude Longitude for a specific address
Zoom Level Magnification level
Map Type Roadmap,satellite, hybrid, or terrain
Radius The radius of influence for each data point
Geo - Marker Heat Maps Specific Options:
Primary Region Specific region of world to be focused on
Geo - Region Specific Options:
Primary Region Specific region of world to be focused on
Data Grid:
Primary Use: Display the data in numerical form on a simple, easy to read grid
How to use: Click on a visualization that has been already created/formatted, change the type to "data grid"
Data Grid - Pagination Options:
Navigation Mode Choose how to navigate through rows. Scroll (default) loads more rows as you scroll down. Paged shows page number controls below the grid and loads one page of data at a time from the datasource.
Rows Per Page Number of rows fetched and displayed per page in Paged mode.
Compute Total Pages Paged mode only. Computes the total row count for the query so the pager can show numbered page buttons and a summary (for example, "Page 2 of 33 · 810 rows"). If disabled, or if the datasource cannot provide a total, the pager falls back to Previous/Next controls.
Max Page Buttons Maximum number of numbered page buttons shown in the pager. Defaults to 7.

Paged mode notes:

  • Each page click fetches that page from the datasource. Grid search, aggregation/grouping, and conditional formatting min/max apply to the currently loaded page only, not the entire dataset. Column header sorting in Paged Data Grid mode is sent to the backend; Knowi-hosted datasets and Direct MongoDB queries apply it before slicing the requested page. For Direct SQL and REST API queries that use page-advancing pagination tokens, include a stable ORDER BY or API sort parameter in the source request so the full result set remains sorted across pages.
  • For non-direct datasets stored in Knowi's Elastic Store or a customer store, Analyze/Data Transformation steps can be applied before the page slice only when they are simple field filters or simple field order by clauses. Aggregations, derived fields, multi-step queries, and non-simple sorts run after the current page is fetched, so they apply to that page slice only. Analyze displays a Paged mode warning when a transformation has this page-slice behavior.
  • Knowi-hosted datasets and Direct MongoDB queries apply dashboard filters and compute totals at the datasource, so filtering works correctly across all pages. For Direct SQL and REST API queries, dashboard filters that are not referenced as runtime parameters in the query are applied after the page is fetched ? they narrow the currently loaded page only, and the row/page totals do not reflect them. Filters that must narrow the full result set should be passed into the query as runtime parameters.
  • Relative date filters (for example, last 15 minutes) are re-evaluated on every page fetch. On fast-changing data the time window moves between page clicks, so rows can shift between pages; use a fixed date range when stable page boundaries matter.
  • CSV and Excel exports from a paged grid prompt for an export scope. Current page exports exactly the rows of the page being viewed, after dashboard filters are applied. All pages fetches every page from the datasource sequentially ? with the same runtime parameters on each request, and with relative date filters (for example, last 15 minutes) resolved once at export start so all pages share the same time window ? and exports the assembled result. All-pages exports are capped at the widget data limit for CSV and additionally at 1,048,575 rows for Excel; if the data exceeds the cap, the export fails with an error instead of producing a silently truncated file ? narrow the time span or filters, or export the current page instead.
  • PDF exports, scheduled reports, email reports, and API exports keep the pre-existing behavior: they bypass paged mode and do not export just the visible page. Knowi-hosted datasets and Direct MongoDB queries export the full (filtered) dataset. Direct SQL and REST API queries that use the system pagination tokens are executed as a single request with page 1 and a page size equal to the export row limit, so the endpoint's own page-size cap determines how many rows are exported.
  • Knowi-hosted datasets and Direct MongoDB queries are paginated automatically. Direct SQL and REST API queries must reference the system pagination tokens in the query - see the Runtime Parameters documentation.
  • If a Direct SQL or REST API query does not reference the pagination tokens, navigating past page 1 returns an error instead of silently repeating the same rows on every page. Add the tokens to the query to page through the result. This check does not apply to queries executed through an agent ? ensure agent-connected paged queries reference the tokens.
  • Page requests participate in Smart Caching: a recently cached page may be served until the cache expires or is invalidated, and stale pages are never served. All-pages exports always execute live against the datasource.
Data Grid Summary:
Primary Use: Display the data in summary form. (Ex. Total messages delivered, opened, etc.)
How to use: Click on a visualization that has been already created/formatted, change the type to "data summary"