I am new to elastic and really enjoying it so far.
Currently I'm struggling to achieve one thing.
Let's say I have entries like:
and so on. I want to count these entries by Key1 and Key2, but I have multiple rows with the same key values. On some visualizations, I want to count only distinct rows. On other visualizations I'm performing a sum on some other field (non-key one) and I want, for example, to take only the first one of the duplicate entry (field values are the same).
Could anyone help me on how to achieve this?
Thank you in advance.