Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.activeviam.com/llms.txt

Use this file to discover all available pages before exploring further.

​
atoti.agg.short(operand: LevelOrVariableColumnConvertible, /) → MeasureDefinition

​
atoti.agg.short(operand: VariableMeasureConvertible, /, *, scope: CumulativeScope | SiblingsScope | OriginScope) → MeasureDefinition

Return a measure equal to the sum of the negative values 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,
...     keys=["id"],
...     table_name="Product",
... )
>>> 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["Quantity.SHORT"] = tt.agg.short(table["Quantity"])
>>> cube.query(m["Quantity.SHORT"])
  Quantity.SHORT
0              0