Ad hoc Analysis

Knowi offers powerful drag and drop ad hoc capabilities on your structured and multi-structured data.

Highlights:


Usage

Dashboards

The Analyze option is available on all widgets inside a dashboard from the settings menu. This opens the widget in ad hoc mode with:

Ad hoc analysis is driven by the bottom grid, which has two key areas:

Grid

Drag and drop a field into one of the header sections. A dropdown menu will be shown where you can rename and apply functions or aggregations on the data.

To save an analysis, use the save menu to save to the same widget, or clone to a new widget. Cloning creates a new visualization based on the analysis.

Query Previews

Ad hoc analytics can be applied during the data plumbing or query phase. Upon a query preview, use the ad hoc grid to drive the analysis, including nested elements. This will be saved as part of the query. See the example below.


Examples

Simple Field Selection

Drag and drop fields into the Fields/Metrics area to only show those fields.

Ad Hoc Grid1


Aggregations and Filters

  1. Drag and drop fields into the Grouping/Dimensions area to segment by. This will auto-add the field into the Fields/Metrics area.
  2. Add the field to aggregate on into the Fields/Metrics section.
  3. From the pop-up, select the aggregate option.
  4. Add any optional filters as needed.
  5. Optionally, change the widget type or settings to modify the visualization.

Ad Hoc Grid2


Date Based Aggregations

Set the date bucket (hour, date, month, year) in the pop-up on the grouping or metrics sections to analyze by date buckets.

Ad Hoc Grid3


Nested Objects and Arrays

Nested objects and arrays are denoted by a + icon next to the field. Nested fields and array elements are auto-detected. Click the + sign to drill into nested objects and arrays and select fields for analysis.

Ad Hoc Grid4


Query Analysis

Ad hoc analysis can be applied during query setup. Preview the query, apply any analysis, and it will be saved with that query.

Ad Hoc Grid5


Derived Fields

Derived fields can be used to apply functions and calculations. See Cloud9QL for available functions.

Examples:
- sent/1000
- (opened/sent)*100


Query Steps

After creating your query and previewing the data returned in the ad hoc grid, you can add multiple filtering steps to the same workflow. This leverages the power of Cloud9QL, but in a drag and drop manner.

Step logic is cumulative, enabling successive refinement on results. Deleting steps may affect the overall query.