Grouping ES log data on monthly basis


I am a new user and trying to setup Grafana with ES. While doing the dashboard, I came across an issue of grouping data on monthly/yearly basis over a timestamp field. ES and Grafana are both version 7.

  • What Grafana version and what operating system are you using?

  • What are you trying to achieve?
    Group ES log data in table view on monthly/yearly basis over a timestamp field values.

  • How are you trying to achieve it?
    Through query metric panel

  • What happened?
    The time portion within the timestamp values is breaking the group.

  • What did you expect to happen?
    There must be a date format so as to group on YYYY or MM basis only.

  • Can you copy/paste the configuration(s) that you are having problems with?

  • Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.
    not exactly.

  • Did you follow any online instructions? If so, what is the URL?
    just the normal docs available online.

Any help/guidance will be highly appreciated.


This topic was automatically closed after 365 days. New replies are no longer allowed.