Documentation:OCLOperators groupBy: Difference between revisions

OCLOperators groupBy

Latest revision as of 04:49, 30 June 2024

OCL groupBy expression groups together a collection of all matching objects based on a specified criteria, returning a tuple of the grouping criteria object and a collection of the matching objects in the List property.

groupBy is well suited for aggregation with its ability to utilize tuples, enabling the creation of aggregate expressions for extraction of patterns from model-driven data that can be used for statistical analysis.

Example

To get the product sales made on specific dates:

NOTE: The groupBy expression always returns the grouping criteria object and a collection of matching objects grouped based on the criteria.

To get product sales made on specific dates with the quantity and sales amount:

Tuples can be used to create more aggregations from our data which can then be accessed as parts of the tuple.


Tuple Parts (How to access the data)	Description
Part1	The grouping criteria object accessed with grouping object name `.DateAdded` instead of `.Part1` since it is known and available in groupBy result.
Part2	The total quantity sold accessed as `.Part2` since it is computed and not available in the groupBy result.
Part3	The total sales amount accessed as `.Part3` since it is also computed and not available in the groupBy result.

This page was edited 82 days ago on 06/30/2024. What links here

@@ Line 1: / Line 1: @@
 <message>Write the content here to display this box</message>
-Builds a collection of tuples grouped by some aspect.
-[[Category:OCL Collection Operators]]
-{{Edited|July|12|2024}}OCL groupBy expression groups together a collection of all matching objects based a specified criteria returning a tuple of the grouping criteria object and Collection of the matching objects in the <code>List</code> property.
-groupBy is well suited for aggregation with its ability to utilize tuples enabling the creation of aggregate expressions for extraction of patterns from model-driven data that can be used for statistical analysis..
+OCL groupBy expression groups together a collection of all matching objects based on a specified criteria, returning a tuple of the grouping criteria object and a collection of the matching objects in the <code>List</code> property.
-Example
+groupBy is well suited for aggregation with its ability to utilize tuples, enabling the creation of aggregate expressions for extraction of patterns from model-driven data that can be used for statistical analysis.
+[[Category:OCL Collection Operators]]
-[[File:how-to-use-groupby-ocl-operator.png|alt=How to use ocl group by expression|frameless]]
+===== Example =====
+[[File:how-to-use-groupby-ocl-operator.png|alt=How to use ocl group by expression|frameless|374x374px]]
-To get the product sales made on specific dates
+To get the product sales made on specific dates:
-[[File:ocl-groupby-expression.png|alt=Ocl groupby operator|frameless|791x791px]]
+[[File:ocl-groupby-operator-expression.png|alt=Ocl groupby operator|frameless|878x878px]]
+ '''NOTE:''' The groupBy expression always returns the grouping criteria object and a collection of matching objects grouped based on the criteria.
+To get product sales made on specific dates with the quantity and sales amount:
-To get product sales made on specific dates with the quantity and and sales amount.
+[[File:groupby-ocl-expression.png|alt=groupby aggregation expression|frameless|865x865px]]
-[[File:groupby-aggregation-expression.png|alt=groupby aggregation expression|frameless|854x854px]]
+Tuples can be used to create more aggregations from our data which can then be accessed as parts of the tuple.
 {| class="wikitable"
 |+
 !Tuple Parts
+(How to access the data)
 !Description
 |-
 |Part1
-|The grouping criteria object accessed as object type <code>.DateAdded</code> instead of <code>.Part1</code> since it is known in the tuple
+|The grouping criteria object accessed with grouping object name <code>.DateAdded</code> instead of <code>.Part1</code> since it is known and available in groupBy result.
 |-
 |Part2
-|The total quantity sold accessed as <code>.Part2</code> since it is not known in the tuple
+|The total quantity sold accessed as <code>.Part2</code> since it is computed  and not available in the groupBy result.
 |-
 |Part3
-|The total sales amount accessed as <code>.Part3</code> since it is not known in the tuple
+|The total sales amount accessed as <code>.Part3</code> since it is also computed and not available in the groupBy result.
 |}