List of functions

The primary purpose of functions is to extend the capabilities of Envision whenever the basic language syntax would not be sufficient. Below, we list the functions supported by Envision.

Mathematics: abs arground ceiling exp floor log max min percent pow ratio round sqrt tanh

Text: concat contains endsWith field field.r indexOf lowercase padLeft parseDate parseNumber parseTime printTime replace sliceSearchUrl startsWith strlen substr text tryParseDate tryParseNumber uppercase

Calendar: chineseYear chineseYearEnd chineseYearStart date daynum isoYear monday month monthEnd monthnum monthStart today weeknum year yearEnd yearStart

Ranking: argFirst argLast assoc.quantity cumsub cumsub.fallback cumsum fifo priopack rank rankd smudge

Graph: canonical connected nonCanonical

Ranvar: crps dirac exponential fillrate forest.regress int loglogistic mean mixture negativeBinomial poisson quantile ranvar ranvar.periodicr ranvar.segment ranvar.uniform reflect smooth spark support.min support.max transform truncate variance

Zedfunc: constant dirac.z int linear pricebrk.f pricebrk.m stockrwd.c stockrwd.m stockrwd.s uniform uniform.left uniform.right valueAt zoz

Table: extend.billOfMaterials extend.distinct extend.range extend.ranvar

Special: forex forex.last hash isCurrency mkuid solve.moq