Querylight TS Demo

Value Count Aggregation

Count how many numeric or date values are indexed, optionally within the current result set.

Back to docs search

Reference Entry

Value Count Aggregation

Discovery · advanced · order 21

Count how many numeric or date values are indexed, optionally within the current result set.

Value Count Aggregation

valueCount() returns the number of indexed values in a numeric or date field.

Use it when you want to know how many values contributed to a summary or chart.

Basic usage

const priceIndex = index.getFieldIndex("price") as NumericFieldIndex;
const count = priceIndex.valueCount();

If one document stores multiple values, all of them are counted.

How it works

valueCount() counts values, not documents.

That means:

  • one document with one value contributes 1
  • one document with three values contributes 3
  • invalid values that were skipped during indexing do not contribute

You can also scope it to a subset:

const subsetIds = new Set(["a", "b"]);
const count = priceIndex.valueCount(subsetIds);

When to use it

  • show how many timestamps were indexed
  • explain the denominator behind avg()
  • sanity-check sparse numeric/date fields

Tradeoffs

  • This is not a unique-document count.
  • This is not cardinality.