This directory contains documentation for all functions available in the Fable ExpressionParser service.
Basic math operations with arbitrary precision:
- sqrt - Square root
- abs - Absolute value
- floor - Floor value
- ceil - Ceiling value
- round - Round to decimal places
- tofixed - Format to fixed decimal places
- percent - Compute percentage
- compare - Compare two values
- sum - Sum of values
- avg / mean - Average/Mean
- median - Median value
- mode - Mode (most frequent)
- min - Minimum value
- max - Maximum value
- count / countset - Count elements
- var / vara - Sample variance
- varp - Population variance
- stdev / stdeva - Sample standard deviation
- stdevp - Population standard deviation
- sortset - Sort a set
- bucketset - Bucket values
- sorthistogram - Sort histogram
- sorthistogrambykeys - Sort histogram by keys
- entryinset - Get entry from set by index
- smallestinset - Get smallest entry
- largestinset - Get largest entry
- setconcatenate - Concatenate sets
- cumulativesummation - Cumulative sum
- subtractingsummation - Subtracting sum
- iterativeseries - Iterative series operations
- aggregationhistogram - Aggregate by exact value
- aggregationhistogrambyobject - Aggregate from object
- distributionhistogram - Distribution histogram
- distributionhistogrambyobject - Distribution from object
- objectkeystoarray - Get object keys as array
- objectvaluestoarray - Get object values as array
- createarrayfromabsolutevalues - Create array from values
- flatten - Flatten nested arrays
- slice - Slice array
- arrayconcat - Concatenate arrays
- getvalue - Get value from application state
- setvalue - Set value to application state
- getvaluearray - Get array of values
- getvalueobject - Get value object
- createvalueobjectbyhashes - Create object from hashes
- cleanvaluearray - Clean value array
- cleanvalueobject - Clean value object
- findfirstvaluebyexactmatch - Find by exact match
- findfirstvaluebystringincludes - Find by string includes
- match - MATCH function (like spreadsheets)
- concat - Concatenate strings
- concatraw - Concatenate raw values
- join - Join strings with separator
- joinraw - Join raw values
- resolvehtmlentities - Resolve HTML entities
- stringcountsegments - Count string segments
- stringgetsegments - Get string segments
- if - Conditional comparison
- when - Truthy check
- ternary - Numeric-aware ternary selection (
? ::operator)
- datefromparts - Create date from parts
- datemilliseconddifference - Millisecond difference
- dateseconddifference - Second difference
- dateminutedifference - Minute difference
- datehourdifference - Hour difference
- datedaydifference - Day difference
- dateweekdifference - Week difference
- datemonthdifference - Month difference
- dateyeardifference - Year difference
- datemathadd - Generic date math
- dateaddmilliseconds - Add milliseconds
- dateaddseconds - Add seconds
- dateaddminutes - Add minutes
- dateaddhours - Add hours
- dateadddays - Add days
- dateaddweeks - Add weeks
- dateaddmonths - Add months
- dateaddyears - Add years
- randominteger - Random integer
- randomintegerbetween - Random integer in range
- randomintegerupto - Random integer up to max
- randomfloat - Random float
- randomfloatbetween - Random float in range
- randomfloatupto - Random float up to max
- slope - Slope of linear regression line
- intercept - Y-intercept of linear regression line
- polynomialregression - Polynomial regression
- leastsquares / linest - Least squares regression
- predict - Predict from regression model
- matrixtranspose - Transpose matrix
- matrixmultiply - Multiply matrices
- matrixvectormultiply - Multiply matrix by vector
- matrixinverse - Inverse matrix
- gaussianelimination - Gaussian elimination
- bezierpoint - Evaluate point on cubic Bezier curve
- beziercurvefit - Fit cubic Bezier curve to data points
- generateguid - Generate a unique GUID string
- generatearrayofobjectsfromsets - Generate objects from sets
- objectvaluessortbyexternalobjectarray - Sort by external array
Functions are called using parentheses:
Result = functionname(arg1, arg2, ...)
Variables are referenced by name:
Result = X * Y + sqrt(Z)
Quoted strings are supported:
Result = concat("Hello ", Name)