How can I query this? (Kibana / Elasticsearch)

Hi,

I'm not sure if this is more a Kibana or Elasticsearch question, sorry if this is in the wrong topic.

Assuming I have two fields:

URL
UserID

There are two possible URLs (URL1, URL2). And n possible users (User0001, User0002, ...)

How would I query for:

  • list of users that have visited both URLs?
  • list of users that visited URL1 (but not URL2)
  • list of users that did not visit URL1 (somehow the opposite of the previous)

From my understanding the results should go into a data table on Visualize, but maybe I am wrong.
Thanks for lighting me up! :slight_smile:

You can probably write something like:

  • list of users that have visited both URLs?
+url:url1 +url:url2
  • list of users that visited URL1 (but not URL2)
+url:url1 -url:url2
  • list of users that did not visit URL1 (somehow the opposite of the previous)
-url:url1
1 Like

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