Count Distinct field query

Elastic Stack Elasticsearch
1

Hi
I would like to find out how I can do a count distinct on a field where some other field match the condition.
In SQL I do run the below code and I do get the result I want.

SELECT COUNT(Distinct RevisionNumber)
FROM table 1
WHERE Week = 1711

2

What you want is the cardinality aggregation. See this page in our definitive guide for another example