Test Case Results Over Time

  • What Grafana version and what operating system are you using? v11.6.1 Windows

  • What are you trying to achieve? I’m trying to create a matrix-style visualization in Grafana where X axis represents the days and Y axis test case names and the cells represent the result of the test case during a specific time interval, with Green box for pass and Red for Fail
    I am using prometheus as the datasource and the format of the data is below

test_case{name=“SSMPA-9000”,id=“3a157d8b-463a-9c82-e923-d1962d9b4ab4”,result=“fail”} 167.2132199 1742320541
test_case{name=“SSMPA-9003”,id=“3a157d8b-463a-9c82-e923-d1962d9b4ab4”,result=“pass”} 96.6563481 1742317479

Ideally i’m new to Grafana and i’m looking for ways to get this done. Which visualization to use and such.

  • How are you trying to achieve it?

  • What happened?

  • What did you expect to happen?

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

  • Did you follow any online instructions? If so, what is the URL?

follow this document.

What is the datasource for the sample data you posted?