[Grafana][Elastic Search] :: Plot IPs hitting website with their Distinct Count

[thejusjose-mindcurv (Thejus Jose)]

Hi all,

Requirement

Get the Top hitting IPs and their count and visualize in Grafana

We had this implemented already in Kibana visualization where we have metrics and buckets to filter out the required fields.

We are trying to populate the distinct IP (dynamic values) and their count in Grafana (version 7.5.11).

We were able to populate the logs from ES into Grafana, however unable to achieve the requirement (mentioned earlier).

Data Source :: Elasticsearch (version 7.8.0)

Could someone please advise if this is feasible and steps to achieve if any ?

[thejusjose-mindcurv (Thejus Jose)]

Issue solved!

Added the params as in screenshot with the timeframe set to a larger duration say yesterday