Type: Aggregator
Function: COUNT_IF_TOTAL
Syntax: COUNT_IF_TOTAL(condition)
Description: Count the number of records matching the provided condition across all groupings (i.e. all records retrieved across the union of all 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 COUNT in combination with standard filters, this will accelerate your report and make the configuration easier to maintain.
The COUNT_TOTAL aggregator may be used in custom formulas to create relative ratios and ponderate the result of other aggregators such as COUNT_IF or COUNT_CUMULATIVE.
Sample usage:
COUNT_IF_TOTAL(state=="CLOSED" || state=="MERGED")counts the total number of records that are either closed or merged.COUNT_IF_TOTAL(author_username ~ "doe$")counts the total number of records where the author's name ends with "doe".(COUNT_IF_TOTAL(CONTAINS(label_names, ["bug", "fix"]))/COUNT_TOTAL())*100returns the percentage of records labeled as "bug or "fix" amongst all records.