Integrate Software AG Products Using Digital Event Services 10.4 | Integrate Software AG Products Using Digital Event Services | MashZone NextGen Help | Appendix | Legacy Presto components | MashZone NextGen Analytics | RAQL Queries | Analytic Functions for Partitions and Windows
 
Analytic Functions for Partitions and Windows
Analytic functions are used in Select clauses to perform analysis for partitions or windows defined in Over clauses. You can use either aggregate analytic or window analytic functions. See Built-In Analytic Functions: Aggregate and Window for a list of the MashZone NextGen built-in analytic functions available to you. User-defined analytic functions may also be available.
For examples of analytic functions used in partitions or windows see:
Aggregate Analytic Functions
Plain Analytic Functions
Group and Analyze Rows with Row Detail for an example using the correlation statistical function.
Row_number, Rank and Dense_rank Example using all three of the built-in analytic functions that assign ranks or numbers to rows within a partition
Windows as Relative Subsets Within Partitions for an example calculating a moving average.
Windows to Show Selected Sibling Values to retrieve specific values relative to the current row.

Copyright © 2019 | Software AG, Darmstadt, Germany and/or Software AG USA, Inc., Reston, VA, USA, and/or its subsidiaries and/or its affiliates and/or their licensors.
Innovation Release