Query with Array values

Elastic Stack Elasticsearch
1

Dear All,

I have document with value as string array like
{
...
Tags:{"a","b","c","d"}
...
}
Note: Tags is not_analyzed.

Query: Get me total documents that has tag a and b, trend on it for a week. It translates to
day, Tag, Count where Tag can take values only a and b

day1, a,3
day2, a,4
day1,b,2
day2,b,6.....

But when I do aggregation and also do filters on agg, it is list all a-d. I just need only a, b in output and not all.

Any help is appreciated.

2

Hey,

the terms agg supports filtering values - would that help here?

--Alex