Skip to content

Designing views

Views offers a range of user interactive dashboards in kdb Insights Enterprise built using KX Dashboards technology. Dashboards are a visualization tool that enables you to query, transform, and present live data. You can build visualizations using drag-and-drop and point-and-click operations in an easy to use editor.

Get started

  1. Create a new view or select a view from the entity tree or Overview page. Views are accessible from the Document bar.

    Create a view from the entity tree by clicking [+].
    Create a view from the entity tree by clicking [+]

    Open a view from the Views menu by clicking the icon.
    Open a view from the Views menu by clicking the icon.

  2. Click Design to edit a view; click-and-drag components into the central workspace and assign data sources from pipeline data. Save changes and Preview to interact with the updated view.

  3. Views can be saved to your profile.

    Click the save icon to retain your view in kdb Insights Enterprise.
    Click the save icon to retain your view in kdb Insights Enterprise.

    Saved Views

    Saved views persist across sessions, but any required update will reset all changes.

View properties

Components within a report can be replaced and new data sets assigned. The report can be styled in a light or dark theme, and the arrangement of components changed.

Basics

Workspace basics

Style

Style

Popups

Popups

Shortcuts

Shortcuts

Notifications

Notifications

Screens

Screens

Components

Click-and-drag a component from the left-hand menu into the workspace. When dragging a component into a workspace, be careful not to drop it on top of another as this will replace the underlying component; any such change (or others) can be undone by clicking the undo action in the report menu bar next to the save icon.

Data sources

Each View comes with its own set of data sources. Data sources are managed in the Data Dialog under getData. The assembly database table name is referenced in the table property. The label property can be used to isolate data from shared name variables in different tables.

Set up

  1. Open the data dialog by selecting Data Source in a component's Basics Properties; for Charts, the Data Source is available under Layers - Basics.

    Click on the data source property, or "Click to populate Data Source" of the component to get data into the component.Click on the data source property, or "Click to populate Data Source" of the component to get data into the component.

  2. Create a new data query. Define a table from those available in the assembly databases and set the required filter properties. Properties can be assigned to view state parameters.

    Define returned data from the table; required is the table name as generated by the pipeline and the start and end time, which must be a timestamp.
    Define returned data from the table; required is the table name as generated by the pipeline and the start and end time, which must be a timestamp.

    parameters description
    table* table name as referenced in the database (from the pipeline)
    startTS* Start time of returned data. If a preset date range is required for a View, set temporality property to slice and define the slice property for start time.
    endTS* End time of returned data; defaults to today's date. If a preset date range is required for a View, set temporality property to slice and define the slice property for end time.
    filter define by (function;columnname;parameter), for example >;valuecolumn;100 to filter "valuecolumn" to values above 100. Selected functions include >, = or < and can include text values; for example =;name;Jim will return rows of data where the "name" column contains 'Jim'.
    groupBy Select data column(s) for grouping data.
    agg Define columns to select: `price`size, an aggregation `col1`avg`price, or a dict(ionary) aggregation `col1`avg`price;`col2`sum`size.
    sortCols Sort results by selected column.
    slice Sets the time range for startTS and endTs when slice is set for temporality.
    fill How to handle nulls in the data. Select between zero to treat nulls as zeroes, or forward to carry forward a previous, non-null value.
    temporaility Set to slice if data returned is between a defined startTS and endTs; use the slice property to set the date range. Set to snapshot for a continous range of data.
    labels Where data columns are shared across different tables an (optional) label can be applied to restrict returned data. For example, table1 has a region property for 'north america' and table2 has a region property for 'europe', then a label of region:europe will return data from table2 only. Data can be returned from tables in different assemblies/databases.

    *required

View State Parameters
Get Data API

  1. Click Execute to preview, success will populate the Results table or return an error message.

    Execute to run the query and populate the Results tab with data.
    Execute to run the query and populate the Results tab with data.

  2. Click Apply and Select to assign the data to the component.

    Apply and Select to post returned data into the component.
    Apply and Select to post returned data into the component.

Subscription

Static

Default setting. Single request for data

Polling

A client-side poll of the database; this is a direct client request to the database. Server paging can be enabled to limit the amount of data returned to the View.

option effect
Interval Time between client poll request
Key Select which data source column to define Subscription handling; e.g. to have continual or static update
Force Reset By default, for updating data sources, merges updates from the server with its existing dataset, unless a parameter is changed in which case the existing dataset is cleared. Enabling Force Reset will clear the existing dataset each time it receives an update, regardless of whether a parameter has changed or not.

Auto-execute

True by default. When auto-execute is true, the data source will automatically execute whenever an input parameter is changed or on load if mapping is used.

When auto-execute is false, subsequent parameter changes won't execute the query. However, it will still execute normally if associated to a component, e.g., a data grid on load, or as an action tied to a button.

Mapping

Mapping maps results from a data source to View States. Results should include a column that contains keys and a column that contains values.

Mapping configuation is accessible from the Mapping tab in the Results panel.

Key and value columns should be defined in the Key and Value dropdowns.

Mappings can be added using the [+] button. Within each mapping you can define the Key and the View State that the Value should be mapped to.

Keys in the current results can be added using the dropdowns. Other keys can be added by typing them into the dropdown input field and pressing enter.

The Reset button will populate the list of mappings with all available keys.

View states

View States store values accessible to all components of the View. Use them to pass values like user selections or preferences between components and into queries.

View States can be edited from the View State dialog.

View states are used to store dynamic values which can be used by components and queries.
Select View State dialog showing a selected View State and its properties

This dialog can be summoned by clicking inside any input box showing the eye icon The view state menu can be accessed by clicking the eye icon.

Hidden eyes

Some inputs offer View States, but the icon is hidden. If a View State is available, a rollover of the input will display the eye icon.

Screenshot

Selected values

Selected Values

View state routing

View State Routing

Component linking

Component linking

Actions

Action is a common property set used to configure a view state, run a query or open an URL.

Actions

Highlight rules

Highlight rules are a common property utilizing color and/or icon markers to notify users of value changes. Highlight rules are best used with real-time streaming, or polling data.

Highlight Rules

Additional information

For more on Dashboards.