No result in the chart!

[omalisson]

Hello friends!

I am trying to create a panel to view data in bars or even in series the data per day.
I already have the queries ready with the desired output, but when I try to create the graphics it doesn’t work!
Here is more information about what I am and how I am doing:

SELECT DATE(data) as nDATA,COUNT(wa_valid) FROM msgs_send where wa_valid = 1 GROUP BY nDATA;

This query executed directly in the bank brings me the expected result:

However, when executed in Grafana in table format, it does not display the data in the graph:

I’ve tried to adjust the ‘X’ axis options for histogram and series and even then it didn’t work.

My need is to join these 3 queries in a single graph:
SELECT DATE(data) as nDATA,COUNT(1) FROM msgs_send GROUP BY nDATA;
SELECT DATE(data) as nDATA,COUNT(wa_valid) FROM msgs_send where wa_valid = 1 GROUP BY nDATA;
SELECT DATE(data) as nDATA,COUNT(wa_entry) FROM msgs_send where wa_entry != 0 GROUP BY nDATA;

Please, if anyone knows how to solve this I am immensely grateful !!!

[fadjar340]

Tru to change the nDATA as time

SELECT 
  DATE(date) as "time",
  COUNT(1) as "count"
FROM
  msgs_send
Group by date

[omalisson]

Thank you friend!!!

For now it has helped me demonstrate what I need!
Now I will continue to see a way to demonstrate the same information in bars to have a separate view of the indicators.