User Guide
Aggregation metrics
After you finish Step 1 (Metric Info), Step 2 (Select Data Asset) appears in the main form:
  1. 1.
    Under Select data asset, select a datasource, schema, table, and a column.
  2. 2.
    Under Aggregation, choose a function to apply to the column's values.
  3. 3.
    Optionally, to create a WHERE clause select Add +. New fields appear under Where-Clause that you can use to specify the necessary condition. To delete a WHERE clause, use the waste bin icon beside it to the right.
Delete a where-clause by selecting this icon
4. Under Configure metric, some fields may be inheriting values from the table. You'll need to enter values for any that are empty. To use your own values for these fields, select Override Settings to unlock the fields for editing. Note that if the table you chose has partitions, Lightup detects them and displays relevant settings for them just below the heritable settings. If you decide instead that the metric should use the table's settings, select Inherit Settings to use the current table settings.
For help deciding what values to use, see the list under Manage Table Settings.
5. Optionally, select a column to use for slices. This can significantly improve your metric's query performance. Use the gear icon to set how the slice affects the metric's query.
6. After you finish configuring your new metric, select Next at the top right corner to proceed to Step 3 (Preview).

Step 3 (Preview)

  1. 1.
    Select View query history to see what the query returns using historical data. When you're done, select Stop Viewing.
  2. 2.
    Select View sample data to see a sample set of 100 rows from the data asset. When you're done, select Stop Viewing.
  3. 3.
    Adjust the date range for previews.
  4. 4.
    Select Preview to generate a chart of the metric over that date range.
To adjust the metric configuration after previewing, select the pencil icon next to Data Asset in the left nav pane.
After you're satisfied with the preview, select Create at the top right corner. The Explorer tab opens and displays your new metric in the Explorer tree.
Copy link