====Count====

Counts the number of records, rows or times where a condition is true.

===Parameters===

^Name^Default^Meaning^
|name||The name of the value to be written to the frame|
|where||A [[substitution|Substitutable]] condition - the count increases by 1 for every row that matches the rule.|
|when||A [[substitution|Substitutable]] condition - the count increases by 1 for every the the rule becomes 'true'|

===Description===

This function performs a **count**, either of...

1) The number of rows that match a condition, or \\
2) The number of times a condition became true

To count each individual row, use the **where** parameter. This will count each row individually - if we where each value is //yes// in the table below...

^Row #^Value^
|1|Yes|
|2|No|
|3|Yes|
|4|Yes|
|5|Yes|
|6|No|

...the answer will be **4**, since there are four rows where the value is 'yes'.

Alternatively if we used **when** instead of **where**, the answer would be '2', because the value only //changed// to 'Yes' twice.

===Example===

If the frame contains the following attributes...

^Row #^Value^
|1|Yes|
|2|No|
|3|Yes|
|4|Yes|
|5|Yes|
|6|No|

<code javascript>
{
   "type": "count",
   "when": "{Value}='Yes'",
   "name": "Yesses"
}
</code>

The final results will include a "Yesses" attribute with a value of 2.