Expression Functions
Flare has a extensive list of expression functions making it easy to build both simple and complex expressions. Below is a partial list:
Date Time Functions Aggregate Functions Math Functions Filter Functions
DateFormat Avg Abs ClearAll
DateOnly Count Ceiling Where
Day Min Floor WhereBetween
DayOfWeek Max MaxValue WhereEQ
DaysInMonth Sum MinValue WhereGT
Hour Rank Round WhereGE
Hour24 SubQuery Fmod WhereLT
MakeDate Hash256 WhereLE
MilliSeconds String Functions Hash512 WhereLike
Minute IndexOf Random WhereNotLike
MonthLongName LastIndexOf SelectAll
MonthNumber Left Chart Only Functions SelectCurrent
MonthShortName Len GetColumn SelectNone
Now LowerCase GetColumnPrevious AndFilter
ParseDate Replace Rank MinusFilter
ParseDateExact SubString GetDimensionCount NotFilter
QuarterNumber Trim OrFilter
Seconds Trim OrFilter
Today TrimStart Color Functions
TotalDays TrimEnd ARGB
TotalMinutes UpperCase RGB Type Conversion Functions
TotalMinutes GetGradientColor ToDateTime
TotalSeconds General Functions HSL ToDouble
WeekOfYear AppName HSLA ToInteger
WorkDaysInMonth Chr ToString
Year IsNull Load Script Only Functions
AddDays Null WriteLine
AddHours ReloadDate RowID
AddMinutes Sleep NotExists
AddMonths User Exists
AddSeconds IsNum
AddYears IsText
AMPM IsSingleValue
© 2023 - 2024 Flare BI LLC 8 The Green Suite 12605 Dover, DE 19901
Tel: 302-268-8969 Email: