Table Visualization Record

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

  • What are you trying to achieve? **

> Single row record per month

**

  • How are you trying to achieve it?

Aggregation or Override properties

** What happened?

Give multiple record row for per month

  • What did you expect to happen?

I want to get count of record in one row /month, but currently it gives me multiple row per month. I do not find any resolution or community post. Hence, i am reaching out here on priority.

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

SELECT DISTINCT

MONTH(HPD:Help Desk.Submit Date) AS C1,

COUNT(HPD:Help Desk.Submit Date) AS Submit_Date,

COUNT(HPD:Help Desk.Closed Date) AS Closed_Date

FROM

HPD:Help Desk

GROUP BY

HPD:Help Desk.Submit Date

LIMIT 100

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

Hi Team, If you do not mind could you please share your input. How can i use single row per month in table visualization. When as i use Month integer with case statement i get result single row per month. Any suggestion will be appreciable.