## Available data functions

Data functions tell Plecto how to calculate your data. Here's an overview:

| Sums the values from a particular field. Use it to calculate the won/lost deal values, order values, story points, etc. |

| Counts the number of registrations in a data source. Use it to calculate the number of new leads, the number of completed orders, or how many agents are currently available. |

| Counts the number of unique registrations in a data source. Say you have 30 registrations because you managed to sell 30 units so far, but you only offer 5 different products. The |

| Returns the very first, earliest field value of a data source. |

| Returns the most recent field value of a data source. This function is frequently used to display text. For example, to see the latest agent status, latest sign-up, etc. |

| Returns the lowest field value of a data source. |

| Returns the greatest field value of a data source. |

| Calculates the average field value of a data source. Use it to get the average deal value, average spending, etc. |

## Adding filters in formulas

Add filters to calculate specific values from your data source. For example, the value of sales deals with status "won," the number of completed tasks, or count the number of registrations where a certain field value is not empty.