Create alerting-on-numeric-data

Grafana Configuration
1
  • What Grafana version and what operating system are you using?
    8.4.3 enterprise
  • What are you trying to achieve?
    set up an alert
  • How are you trying to achieve it?
    follow official guide and create table in mysql
  • What happened?
    error with “Failed to evaluate queries and expressions: failed to execute conditions: can only reduce type series, got type numberSet”
  • What did you expect to happen?
    show the table and let me set up conditions to trigger alert
  • Can you copy/paste the configuration(s) that you are having problems with?
    sql copy from the doc
    SELECT Host, Disk,
    CASE WHEN percentFree < 5.0 THEN percentFree ELSE 0 END FROM (
    SELECT Host,
    Disk,
    Avg(percentFree) as percentFree
    FROM alert_test2
    where $__timeFilter(updateTime)
    Group By Host,
    Disk
    ) as t
  • Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.
    “Failed to evaluate queries and expressions: failed to execute conditions: can only reduce type series, got type numberSet”
  • Did you follow any online instructions? If so, what is the URL?
    Alerting on numeric data | Grafana Labs
2

welcome to the :grafana: community @soldiershen123!

Thank you for all of the information you shared, it really helps the community to understand your question better. Because the error mentions type series I wonder if you’ve chosen format > table in the alert, the default is time series

Screen Shot 2022-03-25 at 4.35.20 PM