๐๏ธ List.Accumulate
Accumulates a summary value from the items in the list.
๐๏ธ List.AllTrue
Returns true if all expressions are true.
๐๏ธ List.Alternate
Returns a list comprised of all the odd numbered offset elements in a list.
๐๏ธ List.AnyTrue
Returns true if any expression is true.
๐๏ธ List.Average
Returns the average of the values. Works with number, date, datetime, datetimezone and duration values.
๐๏ธ List.Buffer
Buffers a list.
๐๏ธ List.Combine
Returns a single list by combining multiple lists.
๐๏ธ List.ConformToPageReader
This function is intended for internal use only.
๐๏ธ List.Contains
Indicates whether the list contains the value.
๐๏ธ List.ContainsAll
Indicates where a list includes all the values in another list.
๐๏ธ List.ContainsAny
Indicates where a list includes any of the values in another list.
๐๏ธ List.Count
Returns the number of items in the list.
๐๏ธ List.Covariance
Returns the covariance between the two lists of numbers.
๐๏ธ List.Dates
Generates a list of date values given an initial value, count, and incremental duration value.
๐๏ธ List.DateTimes
Generates a list of datetime values given an initial value, count, and incremental duration value.
๐๏ธ List.DateTimeZones
Generates a list of datetimezone values given an initial value, count, and incremental duration value.
๐๏ธ List.Difference
Returns the difference of the two given lists.
๐๏ธ List.Distinct
Returns a list of values with duplicates removed.
๐๏ธ List.Durations
Generates a list of duration values given an initial value, count, and incremental duration value.
๐๏ธ List.FindText
Returns a list of values (including record fields) that contain the specified text.
๐๏ธ List.First
Returns the first value of the list or the specified default if empty.
๐๏ธ List.FirstN
Returns the first set of items in the list by specifying how many items to return or a qualifying condition.
๐๏ธ List.Generate
Generates a list of values.
๐๏ธ List.InsertRange
Inserts values into a list at the given index.
๐๏ธ List.Intersect
Returns the intersection of the list values found in the input.
๐๏ธ List.IsDistinct
Indicates whether there are duplicates in the list.
๐๏ธ List.IsEmpty
Returns true if the list is empty.
๐๏ธ List.Last
Returns the last value of the list or the specified default if empty.
๐๏ธ List.LastN
Returns the last value in the list. Can optionally specify how many values to return or a qualifying condition.
๐๏ธ List.MatchesAll
Returns true if the condition function is satisfied by all values in the list.
๐๏ธ List.MatchesAny
Returns true if the condition function is satisfied by any value.
๐๏ธ List.Max
Returns the maximum value or the default value for an empty list.
๐๏ธ List.MaxN
Returns the maximum value(s) in the list. The number of values to return or a filtering condition must be specified.
๐๏ธ List.Median
Returns the median value in the list.
๐๏ธ List.Min
Returns the minimum value or the default value for an empty list.
๐๏ธ List.MinN
Returns the minimum value(s) in the list. The number of values to return or a filtering condition may be specified.
๐๏ธ List.Mode
Returns the most frequent value in the list.
๐๏ธ List.Modes
Returns a list of the most frequent values in the list.
๐๏ธ List.NonNullCount
Returns the number of non-null items in the list.
๐๏ธ List.Numbers
Returns a list of numbers given an initial value, count, and optional increment value.
๐๏ธ List.Percentile
Returns one or more sample percentiles corresponding to the given probabilities.
๐๏ธ List.PositionOf
Returns the offset(s) of a value in a list.
๐๏ธ List.PositionOfAny
Returns the first offset of a value in a list.
๐๏ธ List.Positions
Returns a list of offsets for the input.
๐๏ธ List.Product
Returns the product of the numbers in the list.
๐๏ธ List.Random
Returns a list of random numbers.
๐๏ธ List.Range
Returns a subset of the list beginning at an offset.
๐๏ธ List.RemoveFirstN
Returns a list that skips the specified number of elements at the beginning of the list.
๐๏ธ List.RemoveItems
Removes items from list1 that are present in list.
๐๏ธ List.RemoveLastN
Returns a list that removes the specified number of elements from the end of the list.
๐๏ธ List.RemoveMatchingItems
Removes all occurrences of the input values.
๐๏ธ List.RemoveNulls
Removes all "null" values from the specified list.
๐๏ธ List.RemoveRange
Removes count number of values starting at the specified position.
๐๏ธ List.Repeat
Returns a list that is count repetitions of the original list.
๐๏ธ List.ReplaceMatchingItems
Applies each replacement of \{ old, new }.
๐๏ธ List.ReplaceRange
Replaces count number of values starting at position with the replacement values.
๐๏ธ List.ReplaceValue
Searches a list for the specified value and replaces it.
๐๏ธ List.Reverse
Reverses the order of values in the list.
๐๏ธ List.Select
Returns a list of values that match the condition.
๐๏ธ List.Single
Returns the one list item for a list of length one, otherwise throws an exception.
๐๏ธ List.SingleOrDefault
Returns the one list item for a list of length one and the default value for an empty list.
๐๏ธ List.Skip
Returns a list that skips the specified number of elements at the beginning of the list.
๐๏ธ List.Sort
Sorts a list of data according to the criteria specified.
๐๏ธ List.Split
Splits the specified list into a list of lists using the specified page size.
๐๏ธ List.StandardDeviation
Returns a sample based estimate of the standard deviation.
๐๏ธ List.Sum
Returns the sum of the items in the list.
๐๏ธ List.Times
Generates a list of time values given an initial value, count, and incremental duration value.
๐๏ธ List.Transform
Returns a new list of values computed from this list.
๐๏ธ List.TransformMany
Returns a list whose elements are transformed from the input list using specified functions.
๐๏ธ List.Union
Returns the union of the list values found in the input.
๐๏ธ List.Zip
Returns a list of lists by combining items at the same position in multiple lists.