Row by row metrics

Row by row metrics let you measure data value differences between a source table and a target table.

To create one, begin at Create a metric, and choose Row by row at Step 1 (Metric Info).

Step 2 (Configure Metric)

After you finish Step 1 (Metric Info), Step 2 (Configure Metric) appears in the main form:

  1. Under Source, select a datasource, a schema, and a table. Do the same under Target. These are the tables the metric will compare.
  2. Optionally, add a WHERE clause below one or both tables
  3. Choose the Key columns to compare.
    • Choose one or more pairs of key columns.
    • When the metric is computed, the key columns in the source will be compared to the key columns in the target and the Match % will be displayed.
      • Single pair example: For example, if you choose Customer Name as the key column in the source and Cust Name as the key column in the target, the percentage or rows where Customer Name equals Cust Name will be displayed.
      • Two pair example: For example, if for the first pair you choose Customer Name (source) and Cust Name (target), and the second pair you choose Order ID (source) and Sale Id (target), the percentage of rows where Customer Name and Order ID (source) match Cust Name and Sale Id (target) will be displayed.
    • If you select attribute columns, the key columns also identify the rows that will participate in the attribute column compare. For each row where the key columns match, Lightup will compare all attribute columns and display the Match %, which is the percentage of rows where the attribute columns match
  4. Optionally choose Attribute columns to compare.
  5. Under Configure metric, make selections for the various inputs. These selections mirror the selections you need to make during Table configuration, where you can find details on how to fill in these fields.
  6. Optionally Add a slice column for your source and target tables.
  7. When you're ready, select Next at the top right corner to proceed to Step 3 to preview your metric.

Step 3 (Preview)

Once you have configured your metric you can preview it to view its behavior over some time period. Review its behavior, modify the configuration if necessary, and then save it.