Self Service Analytics

Knowi offers powerful Self Service Analytics capabilities, such as the following:

  • 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.



Self Service Analytics 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