Ad hoc Analysis

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

  • Drag & Drop interface: Interact with your data using to easily derive and publish insights from your data.
  • Nested Objects and Arrays: Drill into nested objects and arrays visually, with the ability to extract and perform analysis on it.
  • Visualizations: Create visualizations & dashboards easily from your analysis.
  • Analysis can be applied on any widget on a dashboard, as well as during report/query creation.



Analyze option is available on all widgets inside a dashboard from the settings menu. This opens up the widget in ad hoc mode, with a data grid at the bottom, the widget on the top right and (visualization) settings on the left. Ad hoc analysis is driven by the bottom grid, which has two key areas:

  • List of fields on the left hand side of the grid
  • The grid header section includes:

    i. Fields/Metrics : Fields that will be displayed on the grid.

    ii. Grouping/Dimensions : Field(s) to segmentation the data by.

    iii. Filters : To add a filter into thStep logic is cumulative thereby enabling successive refinement on the results of each query step. Deleting Steps may affect the overall query results.e section.

    iv. Sort : Field Sorting


Drag and Drop a field into one of the header sections. A drop down menu will be shown upon the drop that you can use to optionally use to rename and apply any functions/aggregations on the data applicable.

To save an analysis, use the save menu save to the same widget, or clone to a new widget, which will create a new visualization based on analysis.

Query Previews

Ad hoc analytics can be applied during the data plumbing/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.


Simple field selection

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

Ad Hoc Grid1

Aggregations & Filters

i. Drag & Drop fields into the Grouping/Dimensions area that you want to segment by (This will auto-add the field into the Fields/Metrics area).

ii. Add the field to aggregate on into the Fields/Metrics section.

iii. From the pop-up, select the aggregate option.

iv. Add any optional filters as needed. v. Optionally, change the widget type/settings to modify the visualization settings.

Ad Hoc Grid2

Date based aggregations

Set the date bucket (hour/date/month/year) in the pop up on the grouping/dimension and metrics sections to analyze aggregations by date buckets.

Ad Hoc Grid3

Nested Objects & Arrays

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

Ad Hoc Grid4

Query Analysis

Ad hoc analysis can be applied during query setup. Preview the query, apply any analysis. Any analysis is saved to that query.

Ad Hoc Grid5

Derived Fields

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


Query Steps

After creating your query and previewing the data returned in the ad-hoc grid, the ability now exists to add multiple filtering steps to the same data query workflow. This leverages the power of our Cloud9QL structured query language, but in an easy to use, drag and drop manner. Step logic is cumulative thereby enabling successive refinement on the results of each query step. Deleting Steps may affect the overall query results. Click here to view recording

Ad Hoc Grid4