Cardinality problem

Elastic Stack Elasticsearch
1

Hi,

I'm not sure if this can be done, but it's worth asking :slight_smile:
I would like to see a specific metric, but it'd need a lot of conditions and cardinality.
Let's say I have an index where I have documents from a forum like this:

{
... (default fields),
topic_id: XXX,
subtopic_id: YYY,
thread_id: ZZZ,
commenter_id: WWW,
category: QQQ,
etc, ...
}

Naturally, each document has all the IDs and all other data/metadata from each comment.

I'd like to know how many topics have only one subtopic AND less than 500 unique commenters.

Apart from that problem, I was thinking that it'd be nice to know the ranges of subtopics (e.g., 1-4, 5-9, over 10), and if there's a possibility to add the category as a main identifier (split the result per category).

Thank you!

2

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.