Count by 1 minute interval in table format

Hi ,

My input is in below format

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

I want Ip count by 1 minute window in table format mentioned below.
2018-05-03 04:45 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



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.


1 Like

Hi @mefraimsson

Thanks for your reply .Now its working as expected.