atoti.agg.prod()#
- atoti.agg.prod(operand: VariableColumnConvertibleOrLevel, /) MeasureDescription #
- atoti.agg.prod(operand: VariableMeasureConvertible, /, *, scope: CumulativeScope | SiblingsScope | OriginScope) MeasureDescription
Return a measure equal to the product of the passed measure across the specified scope.
- Parameters:
operand – The measure or table column to aggregate.
scope – The
aggregation scope
.
Example
>>> df = pd.DataFrame( ... columns=["id", "Quantity", "Price", "Other"], ... data=[ ... ("a1", 100, 12.5, 1), ... ("a2", 10, 43, 2), ... ("a3", 1000, 25.9, 2), ... ], ... ) >>> table = session.read_pandas( ... df, ... table_name="Product", ... keys=["id"], ... ) >>> table.head().sort_index() Quantity Price Other id a1 100 12.5 1 a2 10 43.0 2 a3 1000 25.9 2 >>> cube = session.create_cube(table) >>> m = cube.measures >>> m["Other.PROD"] = tt.agg.prod(table["Other"]) >>> cube.query(m["Other.PROD"]) Other.PROD 0 4