Table Visualization Record

Grafana Dashboards
,
1

  • 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

Screenshot 2022-11-30 233419
Screenshot 2022-11-30 2334191423×649 32.3 KB

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

2

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.