Keypup

Syntax: <code>SUM_IF(condition, number)</code>

Description: Sum a field or expression matching the provided condition, for each grouping (set of dimensions).

This aggregator is useful when comparing multiple metrics side by side, such as when creating a chart with multiple series. If your insight only contains one metric then use a <code>SUM</code> in combination with standard filters, this will accelerate your report and make the configuration easier to maintain.

Example use case: You want to compare the total number of lines of code changed for all pull requests versus those that are currently open.

To do so, you can create a Line Chart with one dimension (e.g. <code>created_at</code>) and the following two metrics: A plain <code>SUM</code> on <code>lines_changed</code> metric, which sums all lines of code changed A custom formula <code>SUM_IF(state == “OPEN”, lines_changed)</code>, which sums the lines of code from open pull requests only.

<code>SUM_IF(state == "MERGED", additions)</code> returns the sum of the <code>additions</code> field value for all merged pull requests.

<code>SUM_IF(CONTAINS(requested_reviewer_usernames,"johndoe"), required_approval_remaining_count)</code> returns the sum of the <code>required_approval_remaining_count</code> field value for all pull requests pending review from “johndoe”.

- <code>SUM_IF(state == "MERGED", additions)</code> returns the sum of the <code>additions</code> field value for all merged pull requests.
- <code>SUM_IF(CONTAINS(requested_reviewer_usernames,"johndoe"), required_approval_remaining_count)</code> returns the sum of the <code>required_approval_remaining_count</code> field value for all pull requests pending review from “johndoe”.