Count and visualize field cardinality greater than a given number

Hi there!

Here's my question:

let's say I have some documents with two fields FIELD_1 and FIELD_2. It might occur that for a certain FIELD_1, there are more than one FIELD_2 associated,
so that some entries might be like:

FIELD_1: XYZ e FIELD_2: 123
FIELD_1: XYZ e FIELD_2: 456

Now, I'd like to have (and visualize) the cardinality of those entries which have more than one FIELD_2 associated.
It means that for a list like:

FIELD_1: XYZ e FIELD_2: 123
FIELD_1: XYZ e FIELD_2: 456
FIELD_1: ABC e FIELD_2: 629
FIELD_1: DEF e FIELD_2: 789
FIELD_1: DEF e FIELD_2: 341

The visualization should return 2, because only the docs whose FIELD_1 is either XYZ or DEF have more than one FIELD_2 associated.

Can you help me?

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