Getting dashboard to show month-to-month data instead of year-to-date data and also to show monthly interval instead of a few days

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

  • What are you trying to achieve?
    I’m trying to create a dashboard (a bar graph or perhaps a table) that will show the x-axis as month and the y-axis as message count. The goal is to have the dashboard show total number of messages sent in a given month. So far, I only get a five-day time interval and the data represented shows the overall total and not the total for just the month, which is what I’m looking for. (ie if 50 messages went out in January and 75 messages in April, I want to see that represented in the graph instead of seeing 125). Data source is prometheus.

  • How are you trying to achieve it?
    I’ve tried to use time series to resolve this but it doesn’t seem to be achieving the end goal

  • What happened?
    It only shows the total to date in five day intervals. (ie sum of all the data from previous years)

  • What did you expect to happen?

  • 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.

  • Did you follow any online instructions? If so, what is the URL?