Examples
Examples
Try the starting example
- JSON Observed records [group key,numeric measure]
- [["A",2],["A",3],["B",4]]
- Minimum records per group (count)
- 2
- Group counts and totals
- [["A",2,5],["B",1,4]]
- Groups below supplied minimum
- ["B"]
- Distinct group count
- 2
Try another scenario
- JSON Observed records [group key,numeric measure]
- [["A",2],["A",3],["B",4],["B",5]]
- Minimum records per group (count)
- 2
- Group counts and totals
- [["A",2,5],["B",2,9]]
- Groups below supplied minimum
- []
- Distinct group count
- 2
Calculation method
Calculation method
Group counts and totals
Group by exact key; return key,count,sum(measure).
Groups below supplied minimum
List groups with count below the entered threshold.
Distinct group count
Number of observed exact groups.
Symbols and units
- a
- JSON Observed records [group key,numeric measure]
- b
- Minimum records per group (count)
Use the units shown. A list keeps the order in which you enter its values. The symbol ^ means “raised to the power of”.
Calculation steps and notation
sum(list) adds all entries in the list.
Assumptions & limits
Assumptions & limits
- Equivalence-group-size audit: exact group keys encode selected quasi-identifier tuples; numeric measure can be one per row. Flags observed group sizes below user k. No anonymity or privacy guarantee and no suppression executed. Supported limits: At most 1000 records. Grouping and any threshold meanings are supplied by the user.
Are these inputs private?
These calculations run in your browser. A shared link contains the values you choose to share. Only questions submitted to the separate AI finder are sent to OpenAI.