I have a question, I think the anwser is simple but It blocks me for some days.
I need to know if it is possible to count different ID with the field A and field B in different JSONS.
For exemple I have 3 jsons :
field A : A
field B : B
fieldID : 2
field A: A
How can I made a "count distinct" from ID where there are field A =A AND field B = B ? (for example, in this case, i must have 1 because ID 2 haven't json with field B :B )
I have already try with filter but AND and OR fonctions work only on one JSON. And i have seen nothing about that on website or forum.
If you need more information, don't hesitate
Thank you !