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

# General functions

| [`at`](./atoti.function.at#atoti.at)                                     | Return a measure equal to the passed measure at some other coordinates of the cube.                                                                                                 |
| ------------------------------------------------------------------------ | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| [`date_diff`](./atoti.function.date_diff#atoti.date_diff)                | Return a measure equal to the difference between two dates.                                                                                                                         |
| [`date_shift`](./atoti.function.date_shift#atoti.date_shift)             | Return a measure equal to the passed measure shifted to another date.                                                                                                               |
| [`filter`](./atoti.function.filter#atoti.filter)                         | Return a measure equal to *measure* where *filter* evaluates to `True` and equal to `None` elsewhere.                                                                               |
| [`first`](./atoti.function.first#atoti.first)                            | Return a measure equal to the first value of the passed measure on the given level.                                                                                                 |
| [`last`](./atoti.function.last#atoti.last)                               | Return a measure equal to the last value of the passed measure on the given level.                                                                                                  |
| [`lookup`](./atoti.function.lookup#atoti.lookup)                         | Return a measure equal to a get-by-key query on the given table column.                                                                                                             |
| [`parent_value`](./atoti.function.parent_value#atoti.parent_value)       | Return a measure which values are equal to the values of the given *measure*, at a member that is located at a higher level on each of the specified hierarchy.                     |
| [`plugin_measure`](./atoti.function.plugin_measure#atoti.plugin_measure) | Return a measure computed by a plugin registered by an [Atoti Server extension](https://docs.activeviam.com/products/atoti/server/6.2/docs/starters/how-to/create-custom-measures). |
| [`rank`](./atoti.function.rank#atoti.rank)                               | Return a measure equal to the rank of a hierarchy's members according to a reference measure.                                                                                       |
| [`shift`](./atoti.function.shift#atoti.shift)                            | Return a measure equal to the passed measure shifted to another member of the hierarchy.                                                                                            |
| [`switch`](./atoti.function.switch#atoti.switch)                         | Return a measure equal to the value of the first case for which *subject* is equal to the case's key.                                                                               |
| [`total`](./atoti.function.total#atoti.total)                            | Return a measure equal to the passed measure at the top level member on each given hierarchy.                                                                                       |
| [`where`](./atoti.function.where#atoti.where)                            | Return a conditional measure.                                                                                                                                                       |