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.
-
Aggregation/Filters –Add filters to aggregated results. For example, filter for results where the SUM(field) is less than 10. This section appears when two conditions are met:
You have at least one field in the Grouping/Dimensions section
You have applied an aggregate operation on a Field/Metrics field
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.
Using "All" in Fields/Metrics
In the Data Transformation tab, the "All" field lets you bring over every field at once into the Fields/Metrics section. After dragging "All" into Fields/Metrics, click the "All" bubble to view operations options:
Count – Convert "All" into a single metric that returns the number of rows in the result set. If you use Count along with fields in the Grouping/Dimensions section, the result returns a count per group.
Expand – Replace the single "All" bubble with individual bubbles for each field. This makes it easy to delete or modify specific columns without having to drag each field over one by one.
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.