Count by 1 minute interval in table format

Grafana Elasticsearch
1

Hi ,

My input is in below format

timestamp IP
2018-05-03 04:45:00 5.35.247.24
2018-05-03 04:45:01 5.35.247.24
2018-05-03 04:45:02 5.35.247.24

I want Ip count by 1 minute window in table format mentioned below.
2018-05-03 04:45 5.35.247.24 3

Because of second i cant get(groupby timestamp) expected result . How i can ignore second in grafana to get above result? Need your help to resolve . My data source is Elasticsearch

Thanks,
K.Jayakumar

2

Hi,

Please include what type of elasticsearch queries you’ve tried. Screenshots are always appreciated.

In my head a date histogram with interval 1 minute and a count metric (or unique count) should work.

Marcus

1 Like
3

Hi @mefraimsson

Thanks for your reply .Now its working as expected.