-
What Grafana version and what operating system are you using?
Grafana v10.4.10 (8afe311009) -
What are you trying to achieve?
We store health checks in Splunk and I’m trying to create any sort of visualization that depicts the number of health checks per day. There will be one or more, depending on the time span selected. -
How are you trying to achieve it?
I am using this Splunk query to retrieve the health checks:
index::security_os_zos C2P1605 | sort by date_month, date_mday | bucket _time span=day |stats count by _time
- What happened?
When I use the query inspector, I get
_time count
2025-02-23 644
2025-02-24 2927
Which is exactly what I want to plot, say on a bar chart, one bar per day. However, when I get out of query inspector and look at the table view of the returned data, I only get:
_time
2025-02-23
2025-02-24
Note the counts are missing.
- What did you expect to happen?
I expected to get date and count for each day on the visualization. As it is, I get a message that the data is missing a number field message.
-
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.
No errors.
- Did you follow any online instructions? If so, what is the URL?
No. I did do a lot of searching to get this far, but many forums were searched, no one post has all the information.
Any help is appreciated.
Thanks,
Greg