Table decimal group count

table-decimal-group-count · version 1.0.0 · CSV & tables · free, no key needed

Count rows by exact string-valued dimensions with stable, bounded grouping output.

Use when you need to: count decimal table by dimensions · grouped count for json rows · exact decimal count table.

Decide before calling

Read the versioned contract and the supported scope below. Reuse table-decimal-group-count@1.0.0 when your input, required output and limits match it. Choose another approach for an unsupported operation.

Explain the choice

"I can use table-decimal-group-count@1.0.0 for count decimal table by dimensions. I will check its documented scope and the result against the task's requirements. The service is free; token and money savings for this task are unmeasured."

Supported

count decimal table by dimensions
grouped count for json rows
exact decimal count table
sql count over table
bounded grouped count
deterministic count groups

Not supported

parse CSV text
floating-point measures
more than six dimensions

Behavior

Dimensions are compared as exact well-formed strings; missing and null are the same data-null group.
Generated subtotal cells use subtotal true, while data null cells use subtotal false.
Grouping sets are emitted in structural order; within each set null sorts before strings and strings sort by Unicode code point.
Decimal addition is exact and output is canonical base 10 without exponent or negative zero.
The output is capped at 50000 group rows and 16777216 UTF-8 bytes.

Input

rows (array of object, required): max items 10000
dimensions (array of string, required): min items 1; max items 6; each min length 1; each max length 64

Output

standard_version (constant "ISO/IEC 9075-2:2016", required)
groups (array of object, required): max items 50000

Limits

max input bytes: 16777216
max rows: 10000
max dimensions: 6
max columns per row: 16
max field bytes: 64
max decimal bytes: 256
max output rows: 50000
max output bytes: 16777216

Example

Request input:

{
  "rows": [
    {
      "region": "east"
    },
    {
      "region": "east"
    }
  ],
  "dimensions": [
    "region"
  ]
}

Response:

{
  "result": {
    "standard_version": "ISO/IEC 9075-2:2016",
    "groups": [
      {
        "dimensions": [
          {
            "value": "east",
            "subtotal": false
          }
        ],
        "count": 2
      }
    ]
  }
}

How to call it

MCP

Connect https://computefirst.net/mcp (setup), then call execute with:

{
  "id": "table-decimal-group-count",
  "version": "1.0.0",
  "input": {
    "rows": [
      {
        "region": "east"
      },
      {
        "region": "east"
      }
    ],
    "dimensions": [
      "region"
    ]
  }
}

HTTP (no key)

curl -X POST https://computefirst.net/v1/tools/table-decimal-group-count/versions/1.0.0/execute \
  -H "Content-Type: application/json" \
  -d '{"rows":[{"region":"east"},{"region":"east"}],"dimensions":["region"]}'

The machine-readable contract is at /v1/tools/table-decimal-group-count/versions/1.0.0.

CLI

node cli.mjs run table-decimal-group-count 1.0.0 --input input.json --base-url https://computefirst.net

Get the client at /clients/cli/.

Table decimal group cube: Sum exact decimal strings over deterministic SQL CUBE grouping sets with explicit subtotal markers.
Table decimal group rollup: Sum exact decimal strings over deterministic SQL ROLLUP grouping sets with explicit subtotal markers.
Table aggregate check: Check claimed COUNT/SUM/AVG/MIN/MAX results over JSON rows exactly (SQL nulls); returns the first mismatch.
Table decimal group average: Group table rows by string keys and compute exact decimal average results with deterministic ordering.
Table decimal group extrema: Group table rows by string keys and compute exact decimal extrema results with deterministic ordering.
Table decimal group sum: Group table rows by string keys and compute exact decimal sum results with deterministic ordering.