Here is a list of the top 12 functions used in Pigment - check them out and visit our 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 |
2. AND | Returns TRUE if all of its arguments are TRUE. | See: AND |
3. OR | Returns TRUE if any argument is TRUE. | See: OR |
4. BY | Aggregates or allocates data based on mapping Properties or Metrics. | See: BY modifier |
5. FILTER | Filters data based on a value or items of Dimensions. | See: FILTER modifier |
6. ADD | Adds a Dimension to a source Metric and performs an allocation. See: ADD modifier | See: ADD modifier |
7. REMOVE | Removes a Dimension of a Metric and performs an aggregation. | See: REMOVE modifier |
8. SELECT | Applies a filter and remove in the same operation. | See: SELECT modifier |
9. ITEM | Finds a list item by matching a text string on any unique Property of the list. | See: ITEM function |
10. DATE | Returns a date from 3 separate values: year, month, and day. | See: DATE function |
11. ISBLANK | Returns TRUE if the given parameter refers to an empty value, FALSE otherwise. | See ISBLANK function |
12. TIMEDIM | Matches a date with an item from the time Dimension. | See: TIMEDIM function |