Keypup

Syntax: <code>COUNT_IF(condition)</code>

Description: Count the number of records matching the provided condition, in each group (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>COUNT</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 commits versus the number of commits related to a fix (the commit message contains the “fix” keyword).

To do so, you can create a Line Chart using the Commits dataset with one dimension (e.g. <code>created_at</code>) and the following two metrics: A plain <code>COUNT</code> metric, which counts the number of commits A custom formula <code>COUNT_IF(message ~ “fix”)</code>, which counts the number of commits having the “fix” keyword in their commit message

<code>COUNT_IF(state=="CLOSED" || state=="MERGED")</code> counts the number of records that are either closed or merged.

<code>COUNT_IF(author_username ~ "doe$")</code> counts the number of records where the author’s name ends with "doe".

<code>(COUNT_IF(CONTAINS(label_names, ["bug", "fix"]))/COUNT())*100</code> returns the percentage of records labeled as "bug or "fix" amongst all records.

- <code>COUNT_IF(state=="CLOSED" || state=="MERGED")</code> counts the number of records that are either closed or merged.
- <code>COUNT_IF(author_username ~ "doe$")</code> counts the number of records where the author’s name ends with "doe".
- <code>(COUNT_IF(CONTAINS(label_names, ["bug", "fix"]))/COUNT())*100</code> returns the percentage of records labeled as "bug or "fix" amongst all records.