Use multiple fields in a calculation

1. Filter by fields required in your calculation

Use filter() to return only the fields necessary for your calculation. Use the to filter by multiple fields.

The following example queries two fields, and B:

Use pivot() to align multiple fields by time.

To correctly pivot on , points for each field must have identical timestamps. If timestamps are irregular or do not align perfectly, see .

Use map() to perform the mathematic operation using column values as operands.

The following example uses values in the and B columns to calculate a new column: