Lightup offers a full range of metric types. View Create and edit metrics for details on how to create each type.
|Metric type||Operates On||Description||Examples|
|Aggregation||Column||Calculates an aggregate function on a set of rows within an aggregation interval. Many different metrics can be created just by choosing the data asset and an aggregation function.||- Sum of sales, hourly|
|Conformity||Column||Calculates the percent of rows that conform to a specific condition, within an aggregation interval. You can create many different metrics by building a condition, and can even combine multiple conditions to create complex expressions that operate on one or more columns.||- Sales < 100000, hourly|
|Distribution||Column||A distribution metric measures the distribution of either numeric or categorical data.|
|Table||Table||Table metrics measure characteristics of the table.||- Data delay: measures the time since the most recent data arrived|
- Data volume: measure the number of rows loaded into a table
|Comparison||These metrics perform complex comparisons without requiring any code.||- Compare Aggregate: compares pairs of metrics|
- Row by Row: compare one or more column values across two tables.
|SQL||A SQL metric lets you write your metric query directly using SQL.|
Updated about 1 month ago