Widget Analyze, Data Transformations:
Analyze option is available on all widgets inside a dashboard from the widget options dropdown beneath settings. This opens up the widget in adhoc mode, displaying a data grid. Adhoc analysis is driven by the data grid, which has two key areas:
-
On the left-hand side of the grid, you’ll see a list of available fields.
-
The grid header section includes:
-
Fields/Metrics – Fields that will be displayed in the grid.
-
Grouping/Dimensions – Field(s) used to segment the data.
-
Filters – Add filters to limit the data shown.
-
Sort – Choose a field to sort the results.
-
Limit – Set the maximum number of rows to return after filters and sorting. Leave blank to return all rows.
-
-
Steps – To use the result of a calculated or created field in another operation, click + Add Step. Each step uses the output of the previous step as its input. Step 1 flows into Step 2, Step 2 into Step 3, and so on. The final step is what feeds into the widget’s visualization. When you add a step, it is inserted directly after the step you are currently viewing.
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.
Query Previews
Adhoc 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.