Lightup offers a full range of metric types. View Create and edit metrics for details on how to create each type.
Calculate an aggregate function on a column's values for a set of rows
|Avg||Returns the sum of values divided by number of rows.||Numeric|
|Count||Returns the count of values.||Any (not recommended for ID columns)|
|Count Unique||Returns the count of distinct values.||Any (not recommended for ID columns)|
|Max||Returns the largest value.||Numeric|
|Median||Returns a number for which half of the values are smaller and half are larger.||Numeric|
|Min||Returns the smallest value.||Numeric|
|Percentile||Returns the value at or below which the specified fraction of values in its frequency distribution falls.||Numeric|
|St.Dev||Returns the standard deviation.||Numeric|
|Sum||Returns the sum of values.||Numeric|
Calculate the percent of rows that conform to a condition
|Contains/Does not contain string||Compares selected column's values with input string.||String|
|Equal/Not equal||Compares selected column's values with input.||Any|
|Greater than||Compares selected column's values with input number and matches if the column's value is greater.||Numeric|
|Greater than or equal to||Compares selected column's values with input number and matches if the column's value is greater.||Numeric|
|In/Not in||Compared selected column's values with an input set of values.||Any|
|In column/Not in column||Compares selected column's values with a second column's values.||Any|
|Is decreasing||Checks that column values are always decreasing. Returns 100% when current value is less than the previous value, and 0% when it is greater than or equal to the previous value.||Numeric|
|Is increasing||Checks that column values are always increasing. Returns 100% when current value is greater than the previous value, and 0% when it is less than or equal to the previous value.||Numeric|
|Is unique||Checks for unique values.||Any|
|Length equal to||Compares selected column's values with input number and matches if the length is equal.||String|
|Length greater than||Compares selected column's values with input number and matches if the length of the column value is greater.||String|
|Length greater than or equal to||Compares selected column's values with input number and matches if the length of the column value is equal or greater.||String|
|Length less than||Compares selected column's values with input number and matches if the length of the column value is smaller.||String|
|Length less than or equal to||Compares selected column's values with input number and matches if the length of the column value is equal or smaller.||String|
|Less than or equal to||Compares selected column's values with input number and matches if the column's value is greater.||Numeric|
|Match pattern/Does not match pattern||Compares selected column's values with input pattern.||String|
|Match regex/Does not match regex||Compares selected column's values with input regular expression.||Any|
|Null/Not null||Checks selected column's values for nulls.||Any|
Calculate the distribution of a column's values
|Distribution||Measures the distribution of distinct values.|
Calculate how much two similar objects match
|Compare aggregate||Measures the degree to which two aggregate metrics match.|
|Row by Row||Measures the percentage of rows in two tables where the key columns match, and the values of attribute columns in those matching rows.|
Measure characteristics of a table or its behavior
|Data delay||Measures the time elapsed since the most recent data arrived.|
|Data volume||Measures the number of rows loaded.|
Metadata metrics are a kind of table metric that can't be edited or customized
|Metadata metric||What it measures||Supported datasources|
|Column activity||Columns added, altered (data type change), or dropped.||All|
|Update Delay||Time since the last data write.||BigQuery, Databricks, Incorta, MS-SQL, Redshift, Snowflake|
|Byte Count||The total number of bytes.||Databricks|
SQL metrics support any valid SQL.
The Metrics list is an easy way to work with all the metrics in a workspace. To open it, select Metrics in the top bar.
Tiles across the top of the list display counts of metrics in the workspace:
- Total (all metrics)
- Monitored (metrics with at least one monitor attached)
- Ongoing incidents (metrics currently generating an incident)
- Live (metrics currently active)
- Paused (metrics currently paused for any reason)
- Error (metrics stopped by an exception, or after three query timeouts due to query governance settings)
Just above the list items, controls let you work with the list:
- Search for a metric across columns by name or by attribute.
- Create a new metric with Create Metric +.
- Select the number of rows to display per page by selecting Show <n>.
- Choose which columns to display by clicking on the gear icon.
- Navigation arrows and page numbers let you jump around in the list.
- The left column lets you select items to perform bulk operations on them.
In the list header, you have more options for working with list items:
- Select the check box to select all items on the page.
- Select a column heading to sort the list using the column's values in ascending order. Select it again to reverse the sort order. Select it a third time to stop sorting using that column.
- Click a value in the Name column to open a context menu that lets you do a variety of operations on that metric.
Updated 8 minutes ago