I’m on Grafana 9.4.7 on Windows I am trying to display test results from test runs. I have data that includes a test name, a test result, and a timestamp rounded down to the start of the day. Results are given once a day, so I only need to be as granular as once a day Right now I am using in…

Welcome @jmorg to the Grafana forum. [image] jmorg: SELECT “time”, “result”, “test_name” FROM tests…“test_results” LIMIT 20 Can you paste the above query into Grafana with the following settings to see if anything shows up? [image]

I definitely am getting results: [test_results] Just now sure how to get the values I am getting to display properly in the status history.

And when you change the visualization from Table to Status history what do you see?

This is all I’m getting: [Screenshot 2023-04-25 100642] And what I’m hoping for is something like this: https://play.grafana.org/d/qD-rVv6Mz/6-state-timeline-and-status-history?orgId=1&from=1682419089427&to=1682440689427&viewPanel=68

Hi @jmorg Let’s go back to the query. It looks like one single data point (“0” at 2023-04-20 17:00:00.000). There is also a drop down selector at the bottom visible (test_results_result). What other options are in that selection box? [image] [image]

The other option in the dropdown is test_name: [image]

Are there any values (0, 1, 2) in the far right? Your screenshot is cropped. In any event, the timestamp is always the same, so any sort of time series visualization in Grafana (such as Status History) will not display anything useful. Do you know why the timestamp is always the same? Do you hav…

The time stamp is the same because this is just a single batch of information. I want the results to be daily results, with one result per day for each of the tests on the list. The screenshot is cropped because I do not want to show the names of the tests, but that is all there is. A column of tim…

I’m hoping to get something like this: [test_result_history] I have all the data for it. I just don’t know how to properly store that data in influx to make it show up in grafana. But I have a list of test names, the dates that they ran on, and the results they had.

OK, I added more data and I got things working with a query for a single test: [image] But once I add another query with another test name I get an unexpected error [image] Also, I have thousands of tests I could potentially list, and I would rather make this so it can dynamically create a dif…

Need help getting status history set up for test results

Grafana Dashboards

grant2 April 26, 2023, 5:42pm 11

Can you try splitting your query up into multiple queries, where each returns the values for an individual system?

Example with dummy CSV values:

Topic		Replies	Views
Grafana & InfluxDB InfluxDB	2	1192	November 1, 2017
Openhab, Grafana & InfluxDB2 - State Timeline & Status History for Simple motion sensors InfluxDB flux	4	354	October 21, 2024
How does the Status History panel work? Time Series Panel mssql	8	20747	January 31, 2024
Status History Date only format Dashboards override	1	600	February 27, 2025
Informations from 2 databases in one status panel InfluxDB	0	522	June 8, 2020

Need help getting status history set up for test results

Related topics