Skip to content

Explore

Explore lets you query your data using kdb+/q or sql. The dropdown shows the available assemblies along with any gateway processes. Freeform queries can be run against these and output will be shown in the table or chart below.

Screenshot

Data can also be accessed from the list of assemblies in the entity tree. Historic data is available directly under the assembly while Intraday and Realtime data are nested.

Screenshot

The central divider is a drag bar which can be resized to better view the query or outputted results.

Set up

  1. import data to create a running pipeline or select a table from an available assembly. Check the Overview tab for a list of pipelines and their status.

    Pipelines

  2. The Explore editor will return selectable datasets as you type. Datasets can also be queried using either sql or kdb+/q.

    select * from cars
    html5evalcongroup

    select * from trace LIMIT 5
    idb

  3. Save and/or Run

  4. View the data as a Table or Visual.

Sandbox

Explore offers a sandbox environment for querying read-only data from a list of available assemblies. Assemblies are listed in the dropdown next to the Save icon. Data can be queried using sql or kdb+/q.

Options

Save

Save the query to local browser storage. Data can be accessed between browser sessions.

Run

Executes the query. Results will be outputted in the lower Table or Visual panel.

CTRL+ Enter

Queries can be run using the keyboard shortcut of CTRL+ Enter.

Query

A text-based kdb+/q editor. A smart autofill will list available data tables on running pipelines.

Screenshot

History

A log of executed queries and their status. To rerun a query, click the play icon on the left.

Screenshot

Additional options available when check-selected are:

Export

Export the query

Clear

Remove from the log history

Search the log history

Sort

Sort history by Query, Time/Date of Query, User, Execution Time, Query Success, Editor Language. A toggle switches the order from ascending to descending.

Table

Tabulated results from the query; results are paged.

Screenshot

First
Display results from the start of the data source (page 1).
Last
Display results from the end of the data source (last page).
Random
Select a random point in the data set to display results.
10
100
1000
10000
Filter paged results by 10, 100, 1,000, or 10,000 results per page.

Column Filter

Data columns can be sorted in ascending and descending order on a header click.

Support for data filtering with AND/OR statements available as a dropdown menu option in the header; select between contains, not contains, equals, not equal, starts with, or ends with.

Screenshot

Visual

A chart of the result data; double click on an item to edit.

Screenshot

Chart Type

Select from Bubble, Line or Bar.

Define the data source variables to chart from the x- and y-axis drop-downs. Defaults to wildcard, *, for y-axis.

Display

Click the area above the chart to open menu.

Bubble

Screenshot

Radius Data
Choose between a data source variable or Fixed sized bubbles.
Radius Scaling
Sets the scaling of bubble size.
Opacity
Define the opacity of the bubble. Range 0 (transparent) to 100 (opaque).
Scale on Zoom
When enabled, bubbles will scale on zoom; increase in size on zoom in, decrease in size on zoom out.
Enabled
Plotted bubble data will display on chart when enabled.
Legend Enabled
Legend of plotted data will appear above chart when enabled.

Line

Screenshot

Opacity
Define the opacity of the line. Range 0 (transparent) to 100 (opaque).
Fill
Fill Color
Fill Opacity
Fade to Transparent
Enable to fill the area of the line to the x-axis. Define Hex color, opacity of the fill area and optional transparency fade.
Enabled
Plotted line data will display on chart when enabled.
Legend Enabled
Legend of plotted data will appear above chart when enabled.

Bar

Screenshot

Opacity
Define the opacity of the bar. Range 0 (transparent) to 100 (opaque).
Bar Percentage
Set auto-size percentage width of bars
Bar Fixed Width
Set bar width in pixels.
Bar Width Type
Toggle between Percentage or Fixed Width for bar width.
Enabled
Plotted bar data will display on chart when enabled.
Legend Enabled
Legend of plotted data will appear above chart when enabled.

Color Palette

Screenshot

Define Hex color for each layer; plotted in order.

Animation

Screenshot

Animation Duration
Animation Easing
Define zoom animation events and length of time in milliseconds to complete. Select from swingFromTo, swingFrom, swingTo, easeFromTo, easeFrom, easeTo, easeInQuad, easeOutQuad, easeInOutQuad, easeInCubic, easeOutCubic, easeInOutCubic, easeInQuart, easeOutQuart, easeInOutQuart, easeInQuint, easeOutQuint, easeInSine, easeOutSine, easeInOutSine, easeInExpo, easeOutExpo, easeInOutExpo, easeInCirc, easeOutCirc, easeInOutCirc, easeOutBounce, easeInBack, easeOutBack, easeInOutBack, bounce, bouncePast, elastic.

Overlay

Show Crosshairs
Adds a crosshair to the chart.
Show Coordinates
Displays axis values for cursor position in chart.
Snap Crosshair to Data
Crosshair position locks to y-axis value relative to x-axis postion.
Show all data points
Crosshair displays all values in tooltip at x-axis position.
Group tooltip by layer
Group display of chart values in the tooltip by data layers.

X- and Y-Axis

Number of Ticks
Define number of tick labels to display in the y-axis.

Range

Use min max
Min
Max
Use minimum and maximum values of data range to define y-axis range.

Gridlines

Offset Gridlines
When enabled, sets gridlines between tick values.
Gridlines Opacity
Defines the opacity of gridlines from 0 (transparent) to 100 (opaque).

Format

Display
When enabled, displays tick values.
Begin at Zero
When enabled, plotted values will start at 0 for the y-axis.
Numeric Format
Select between Number, Smart Number and Formatted Number.
Decimal Places
Define precision of y-axis labels.
Font size
Define font-size of tick labels.
Prefix
Suffix
Add a text component before or after y-axis tick label.
Hide Trailing Zeroes
When enabled, hides trailing zeroes from axis label.
10
100
1000
10000
Filter paged results by 10, 100, 1,000, or 10,000 results per page.