Calculating metric value rate over time range of dashboard

  • What Grafana version and what operating system are you using?

v8.3.4 ubuntu

  • What are you trying to achieve?
    I’m trying to show the success rate of a github workflow in a grafana panel

  • How are you trying to achieve it?
    I’m collecting cloudwatch metrics for the success rate of a github workflow, it saves success as 1 and fail as 0, i want to be able to show the success rate of the workflow over the period of time that is in the time range of the dashboard.

  • What happened?
    found no easy way to collect the datapoints this way, i had to resord to using a custom interval variable in the period to be able to collect data points across a certein amount of time and use sum and samplecount to figure out how many failed and succeeded. also i can’t set the period of the query to the time range of the dashboard as the grafana global variables don’t seem to work in this field.

  • What did you expect to happen?
    expected to be able to get the count of the value of a certain metric more easily and also be able to count over time range more easily

  • Can you copy/paste the configuration(s) that you are having problems with?
    not really

  • Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.
    no

  • Did you follow any online instructions? If so, what is the URL?
    tried using these Global variables | Grafana documentation to no success