Skip to main content
info
This documentation is for version v2.4 of the product.
For the latest version(v2.7) documentation click here
Version: v2.4 print this page

WindowAnalytics

Type

transform

Fields

NameTitleDescription
partitionByColsPartitionBypartition column names separated by comma(,)
orderByColsOrderByorder by column names separated by comma(,)
windowFunctionWindow FunctionWindow Function Name
analyticsColAnalytics Column

Examples

Input

idpricelotsizebedroomsbathrmsstories
1420005850312
2385004000211
3495003060311
4605006650312
5610006360211
6660004160311
7660003880322

Parameters

NameValue
PartitionBybedrooms , bathrms
OrderBylotsize , price desc
Window FunctionAnalytics Column
first_valueprice

Output

idpricelotsizebedroomsbathrmsstoriesfirst_value
766000388032266000.0
349500306031149500.0
666000416031149500.0
142000585031249500.0
460500665031249500.0
238500400021138500.0
561000636021138500.0