# Quickstart: 10 common functions
URL: https://docs.valsight.ai/quickstart-10-common-functions/
Description: This page highlights the functions you’ll use most often when bringing in data, shaping dimensionality, filtering slices, and building time logic.
This page highlights the functions you’ll use most often when **bringing in data, shaping dimensionality, filtering slices, and building time logic**.

Use it as a shortcut to common formula patterns before moving to the full [Function catalog](/function-catalog/).

## Connect & adjust values

| Name                 | What it does                                                                     | Formula                              |
| -------------------- | -------------------------------------------------------------------------------- | ------------------------------------ |
| [DATA](/data/)       | Bring uploaded or source data into a node. Returns the referenced table's shape. | `DATA("Source", "Table", "Measure")` |
| [ADDEACH](/addeach/) | Adjust each value individually, no aggregation. Keeps the input shape.           | `ADDEACH('Node', Amount)`            |

## Time logic & forecasting

| Name                                            | What it does                                                             | Formula                                          |
| ----------------------------------------------- | ------------------------------------------------------------------------ | ------------------------------------------------ |
| [ROLLFORWARD\_ADVANCED](/rollforward-advanced/) | Project values forward with forecasting options. Extends the time range. | `ROLLFORWARD_ADVANCED('Node', ['Drivers'], ...)` |
| [RUNNINGSUM](/runningsum/)                      | Calculate cumulative totals over time. Keeps the input shape.            | `RUNNINGSUM('Node')`                             |

## Filter & apply business rules

| Name               | What it does                                                                 | Formula                               |
| ------------------ | ---------------------------------------------------------------------------- | ------------------------------------- |
| [FILTER](/filter/) | Return a subset of a node, e.g. specific regions. Reduces to matching rows.  | `FILTER('Node', "Level", Value)`      |
| [IF](/if/)         | Apply thresholds, caps, floors, or branching. Follows the condition's shape. | `IF(Condition, ThenValue, ElseValue)` |

## Shape dimensionality

| Name                           | What it does                                                              | Formula                                     |
| ------------------------------ | ------------------------------------------------------------------------- | ------------------------------------------- |
| [EXPAND](/expand/)             | Add dimensional detail. Expands to the cross product of the levels.       | `EXPAND('Node', "Level", ...)`              |
| [EXPANDSINGLE](/expandsingle/) | Expand to specific level values only. Expands only to those values.       | `EXPANDSINGLE('Node', "Level", Value, ...)` |
| [DROPLEVEL](/droplevel/)       | Remove dimensional detail. Drops a level and its finer levels.            | `DROPLEVEL('Node', "Level", ...)`           |
| [ROLLUP](/rollup/)             | Aggregate to a higher level, e.g. Month to Year. Reduces to those levels. | `ROLLUP('Node', "Level", ...)`              |

## Related

* [Formula basics](/formula-basics/): syntax, notation, and evaluation fundamentals
* [Operators](/operators/): arithmetic, comparisons, boolean logic used in formulas
* [Function catalog](/function-catalog/): all functions, from A to Z and by category