How can I set a hard time for when the metric is queried?

  • What Grafana version and what operating system are you using?
    v11.0.0, MacOS Sonoma

  • What are you trying to achieve?
    Make it so that the Lambda metric interval start time is at a consistent time in the hour. e.g. For a 15min interval, the tooltip should show at [15:00, 15:15, 15:30, 15:45, 16:00] not [15:02, 15:17, 15:32, 15:47, 16:02] like in the image.
    Screenshot 2024-07-15 at 4.41.49 PM

  • How are you trying to achieve it?
    Play around with query options. I’m not sure what these mean.

  • What happened?
    When I load the relevant dashboard, it shows the values at the current time with an interval of 15min historically. I.e. If I view the dashboard at 9:24, the values I get in the panel in the tooltips are 9:24, 9:09, 8:54 …

  • What did you expect to happen?
    I expect the earliest metric I can see to be 9:15, going back to 9:00, 8:45 …

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

{
  "datasource": {
    "type": "cloudwatch",
    "uid": "------------"
  },
  "fieldConfig": {
    "defaults": {
      "custom": {
        "drawStyle": "line",
        "lineInterpolation": "linear",
        "barAlignment": 0,
        "lineWidth": 1,
        "fillOpacity": 0,
        "gradientMode": "none",
        "spanNulls": false,
        "insertNulls": false,
        "showPoints": "auto",
        "pointSize": 5,
        "stacking": {
          "mode": "none",
          "group": "A"
        },
        "axisPlacement": "auto",
        "axisLabel": "",
        "axisColorMode": "text",
        "axisBorderShow": false,
        "scaleDistribution": {
          "type": "linear"
        },
        "axisCenteredZero": false,
        "hideFrom": {
          "tooltip": false,
          "viz": false,
          "legend": false
        },
        "thresholdsStyle": {
          "mode": "off"
        }
      },
      "color": {
        "mode": "palette-classic"
      },
      "mappings": [],
      "thresholds": {
        "mode": "absolute",
        "steps": [
          {
            "color": "green",
            "value": null
          },
          {
            "color": "red",
            "value": 80
          }
        ]
      }
    },
    "overrides": [
      {
        "matcher": {
          "id": "byName",
          "options": "Duration"
        },
        "properties": [
          {
            "id": "custom.axisPlacement",
            "value": "right"
          },
          {
            "id": "unit",
            "value": "ms"
          }
        ]
      }
    ]
  },
  "gridPos": {
    "h": 8,
    "w": 8,
    "x": 16,
    "y": 8
  },
  "id": 6,
  "options": {
    "tooltip": {
      "mode": "multi",
      "sort": "none",
      "maxHeight": 600
    },
    "legend": {
      "showLegend": true,
      "displayMode": "list",
      "placement": "bottom",
      "calcs": []
    },
    "timezone": [
      "browser"
    ]
  },
  "targets": [
    {
      "datasource": {
        "type": "cloudwatch",
        "uid": "----------"
      },
      "dimensions": {
        "FunctionName": "---------"
      },
      "expression": "",
      "hide": false,
      "id": "i",
      "label": "Invocations",
      "logGroups": [],
      "matchExact": true,
      "metricEditorMode": 0,
      "metricName": "Invocations",
      "metricQueryType": 0,
      "namespace": "AWS/Lambda",
      "period": "900",
      "queryMode": "Metrics",
      "refId": "A",
      "region": "---------",
      "sqlExpression": "",
      "statistic": "Sum"
    },
    {
      "datasource": {
        "type": "cloudwatch",
        "uid": "----------"
      },
      "dimensions": {
        "FunctionName": "-------"
      },
      "expression": "",
      "hide": false,
      "id": "d",
      "label": "Duration",
      "logGroups": [],
      "matchExact": true,
      "metricEditorMode": 0,
      "metricName": "Duration",
      "metricQueryType": 0,
      "namespace": "AWS/Lambda",
      "period": "900",
      "queryMode": "Metrics",
      "refId": "B",
      "region": "------",
      "sqlExpression": "",
      "statistic": "Maximum"
    }
  ],
  "title": "Load Control Requests",
  "type": "timeseries"
}