Data Discovery enables Discovery Users to create visualizations on datasets through a drag-and-drop interface that does not require SQL.
Note: Data Discovery is available on select plans. Site administrators can contact their Customer Success Manager for additional information.
For how to create a dataset for use in discover mode, see our documentation here
To create a visualization using the Data Discovery feature, SQL and Discovery Users can click on the "Add chart" button on the top right corner of a dashboard they have access to.
In the editor, users can select their dataset of choice in the left-hand selector. The dataset description will also appear upon hovering over the dataset name.
In this editor, users can select from a variety of parameters to tailor visualizations:
The toolbar at the top of the editor lists the different chart types that Discovery Users are able to create. The current chart types supported are Tables, Line Charts, Bar Charts, Number Overlays, Pie Charts, Area Charts, Cohort Grids, Maps, Sparklines, Scatter Plots, and Bubble Charts.
Fields from the dataset appear on the left-hand side of the editor and can be dragged into their respective fields. When relevant, drop down arrows expose additional options to aggregate dates, perform calculations, and set date ranges.
Once the appropriate fields have been selected, visualizations can be further tailored in the Format Chart menu on the right-hand side of the editor.
Building Graph-like Charts
Graph-like charts include line charts, bar charts, area charts, sparklines, bubble charts, and scatter plots.
The X and Y axis fields determine which values correspond to each axis. The Series field determines how the data is segmented, automatically assigning a different color to each series. The Filters field designates any filtering criteria to apply on the final visualization. Sort fields determine how the data is ordered in an ascending or descending manner, and allow users to enter any limits to display only a specified number of values. By default, charts created through Data Discovery show up to 20000 rows. This limit can be adjusted in the Sort field, provided the final dataset is under 4.7 MB.
Note: Filter requirements are additive - a data point must satisfy all filtering criteria in order to be displayed in the final graph.
Building Table-like Charts
Table-like Charts include Tables and Cohort Grids. Both chart types contain fields for users to enter any desired Columns, Filters, and Sort specifications. The Columns field determines which fields will be displayed as the columns of the table. The Filters field designates any criteria that the data points must meet in order to be displayed in the final chart. Sort allows the final visualization to be arranged by a specific column's values. By default, charts created through Data Discovery show up to 20000 rows. This limit can be adjusted in the Sort field, provided the final dataset is under 4.7 MB.
In addition to the above, Cohort grids allow users to designate Rows, Values, and Details. Rows designate the field(s) along the vertical axis of the chart. Values determines the summary metric being displayed in each pivot cell. Fields dragged in "Details" will be added as columns with additional information on the left-hand side of the cohort grid.