Could you let me know how to make a regular interval on the left axis?

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

  • What are you trying to achieve?
    I am trying to make a regular interval (For example 10min 20min 30min 40min …) on the left axis rather than an irregular interval as shown below.

  • How are you trying to achieve it?

  • What happened?
    The left axis shows an irregular interval like 16.7min, 33.3min, 50min, 1.11 hour, 1.39 hour

  • What did you expect to happen?
    I am trying to make a regular interval (For example 10min 20min 30min 40min …) on the left axis

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

{
  "aliasColors": {},
  "bars": true,
  "dashLength": 10,
  "fieldConfig": {
    "defaults": {
      "unit": "s"
    },
    "overrides": []
  },
  "fill": 1,
  "gridPos": {
    "h": 8,
    "w": 12,
    "x": 12,
    "y": 1
  },
  "id": 23763571993,
  "legend": {
    "alignAsTable": false,
    "avg": false,
    "current": false,
    "hideEmpty": false,
    "hideZero": false,
    "max": false,
    "min": false,
    "rightSide": false,
    "show": true,
    "total": false,
    "values": false
  },
  "linewidth": 1,
  "nullPointMode": "null",
  "options": {
    "alertThreshold": true
  },
  "pluginVersion": "7.5.7",
  "pointradius": 5,
  "renderer": "flot",
  "seriesOverrides": [],
  "spaceLength": 10,
  "stack": true,
  "targets": [
    {
      "format": "time_series",
      "group": [],
      "hide": false,
      "metricColumn": "none",
      "rawQuery": false,
      "rawSql": "SELECT\n  datetime AS \"time\",\n  backup_duration AS \"Backup\"\nFROM storage_cohesity_backups\nWHERE\n  datacenter = 'dc12' AND\n  protection_group_name = 'DC12-FlashBlade-prodstore-Replication-AWS'\nORDER BY datetime",
      "refId": "A",
      "select": [
        [
          {
            "params": [
              "backup_duration"
            ],
            "type": "column"
          },
          {
            "params": [
              "Backup"
            ],
            "type": "alias"
          }
        ]
      ],
      "table": "storage_cohesity_backups",
      "timeColumn": "datetime",
      "timeColumnType": "datetime",
      "where": [
        {
          "datatype": "varchar",
          "name": "",
          "params": [
            "datacenter",
            "=",
            "'dc12'"
          ],
          "type": "expression"
        },
        {
          "datatype": "varchar",
          "name": "",
          "params": [
            "protection_group_name",
            "=",
            "'DC12-FlashBlade-prodstore-Replication-AWS'"
          ],
          "type": "expression"
        }
      ]
    },
    {
      "format": "time_series",
      "group": [],
      "hide": false,
      "metricColumn": "none",
      "rawQuery": false,
      "rawSql": "SELECT\n  datetime AS \"time\",\n  copy_duration AS \"Replication\"\nFROM storage_cohesity_backups\nWHERE\n  datacenter = 'dc12' AND\n  protection_group_name = 'DC12-FlashBlade-prodstore-Replication-AWS'\nORDER BY datetime",
      "refId": "B",
      "select": [
        [
          {
            "params": [
              "copy_duration"
            ],
            "type": "column"
          },
          {
            "params": [
              "Replication"
            ],
            "type": "alias"
          }
        ]
      ],
      "table": "storage_cohesity_backups",
      "timeColumn": "datetime",
      "timeColumnType": "datetime",
      "where": [
        {
          "datatype": "varchar",
          "name": "",
          "params": [
            "datacenter",
            "=",
            "'dc12'"
          ],
          "type": "expression"
        },
        {
          "datatype": "varchar",
          "name": "",
          "params": [
            "protection_group_name",
            "=",
            "'DC12-FlashBlade-prodstore-Replication-AWS'"
          ],
          "type": "expression"
        }
      ]
    }
  ],
  "thresholds": [],
  "timeRegions": [],
  "title": "DC12-FlashBlade-prodstore-Replication-AWS",
  "tooltip": {
    "shared": true,
    "sort": 0,
    "value_type": "individual"
  },
  "type": "graph",
  "xaxis": {
    "buckets": null,
    "mode": "time",
    "name": null,
    "show": true,
    "values": []
  },
  "yaxes": [
    {
      "$$hashKey": "object:76",
      "decimals": null,
      "format": "s",
      "label": "",
      "logBase": 1,
      "max": null,
      "min": null,
      "show": true
    },
    {
      "$$hashKey": "object:77",
      "format": "short",
      "label": null,
      "logBase": 1,
      "max": null,
      "min": null,
      "show": true
    }
  ],
  "yaxis": {
    "align": false,
    "alignLevel": null
  },
  "dashes": false,
  "fillGradient": 0,
  "hiddenSeries": false,
  "lines": false,
  "percentage": false,
  "points": false,
  "steppedLine": false,
  "timeFrom": null,
  "timeShift": null,
  "datasource": null
}
  • 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?

Hi @bryanheo,

Have you explored setting a min and max value or soft min/soft max for the y axis in the panel editor?

Hi @mattabrams
Thank you for your update.
Yes, I set the Y-min and Y-max but it does not show a regular interval (For example 10min 20min 30min 40min …)