---
title: "Most used Functions"
slug: "most-used-functions"
description: "Discover the top-used Pigment functions and how to apply them effectively in your models for better planning and analysis."
updated: 2025-04-15T14:06:02Z
published: 2025-08-22T12:00:18Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://kb.pigment.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Most used Functions

Here is a list of the top 12 functions used in Pigment - check them out and visit our [Functions by Category](/v1/docs/functions-by-category) page!

| ### **1. IF** | Tests one or multiple conditions and returns one value if condition is met, another if it isn't. | See: [IF function](/v1/docs/if-function) |
| --- | --- | --- |
| ### **2. AND** | Returns TRUE if all of its arguments are TRUE. | See: [AND](/v1/docs/and-function) |
| ### **3. OR** | Returns TRUE if any argument is TRUE. | See: [OR](/v1/docs/or-function) |
| ### **4. BY** | Aggregates or allocates data based on mapping Properties or Metrics. | See: [BY](/v1/docs/aggregating-data-in-formulas) modifier |
| ### **5. FILTER** | Filters data based on a value or items of Dimensions. | See: [FILTER](/v1/docs/filter-modifier) modifier |
| ### **6. ADD** | Adds a Dimension to a source Metric and performs an allocation. See: ADD modifier | See: [ADD](/v1/docs/add-modifier) modifier |
| ### **7. REMOVE** | Removes a Dimension of a Metric and performs an aggregation. | See: [REMOVE](/v1/docs/remove-modifier) modifier |
| ### **8. SELECT** | Applies a filter and remove in the same operation. | See: [SELECT](/v1/docs/select-modifier) modifier |
| ### **9. ITEM** | Finds a list item by matching a text string on any unique Property of the list. | See: [ITEM function](/v1/docs/item-function) |
| ### **10. DATE** | Returns a date from 3 separate values: year, month, and day. | See: [DATE function](/v1/docs/date-function) |
| ### **11. ISBLANK** | Returns TRUE if the given parameter refers to an empty value, FALSE otherwise. | See [ISBLANK function](/v1/docs/isblank-function) |
| ### **12. TIMEDIM** | Matches a date with an item from the time Dimension. | See: [TIMEDIM function](/v1/docs/timedim-function) |