Table of Contents

Enum WindowFunctionType

Namespace
Datafication.Core.Data
Assembly
Datafication.Core.dll

Enumeration of supported window function types for DataBlock operations. Window functions compute values over a set of table rows that are related to the current row.

public enum WindowFunctionType
Extension Methods

Fields

CumulativeAverage = 8

Cumulative average from start of partition/dataset

CumulativeMax = 10

Cumulative maximum from start of partition/dataset

CumulativeMin = 9

Cumulative minimum from start of partition/dataset

CumulativeSum = 7

Cumulative sum from start of partition/dataset

DenseRank = 15

Rank without gaps for ties

ExponentialMovingAverage = 19

Exponential moving average over specified window size

FirstValue = 16

First value in window/partition

Lag = 11

Value from previous row (requires offset parameter)

LastValue = 17

Last value in window/partition

Lead = 12

Value from following row (requires offset parameter)

MovingAverage = 0

Moving average over specified window size

MovingCount = 6

Moving count (non-null values) over specified window size

MovingMax = 3

Moving maximum over specified window size

MovingMedian = 20

Moving median over specified window size

MovingMin = 2

Moving minimum over specified window size

MovingPercentile = 21

Moving percentile over specified window size (requires percentile parameter)

MovingStandardDeviation = 4

Moving standard deviation over specified window size

MovingSum = 1

Moving sum over specified window size

MovingVariance = 5

Moving variance over specified window size

NthValue = 18

Nth value in window/partition (requires offset parameter)

Rank = 14

Rank with gaps for ties

RowNumber = 13

Sequential row number within partition