Hey there, let's break down exactly how to build that SingleStat panel using your InfluxDB log data. I'll walk you through each step clearly:

1. Confirm Your InfluxDB Data Source is Connected #

First, make sure Grafana is already linked to your InfluxDB instance. If you haven't set this up yet:

• Go to Configuration > Data Sources in Grafana
• Click Add data source and select InfluxDB
• Fill in your InfluxDB connection details (URL, database name, credentials if required)
• Test the connection to verify it works properly

2. Create a New SingleStat Panel #

• Navigate to your existing dashboard (or create a new one from scratch)
• Click Add panel > Add new panel
• From the panel type dropdown menu, select SingleStat

3. Configure the InfluxDB Query #

Your sample filter is select * from log where time < now() - 2h and value1<100, but for a SingleStat panel we need to aggregate this data into a single meaningful value. Here are a few practical query options based on what you want to display:

Option 1: Count of matching records #

If you want to show how many entries meet the value1 < 100 criteria from the last 2 hours:

SELECT count(*) FROM "log" WHERE time > now() - 2h AND "value1" < 100

Option 2: Average value of value1 for matching records #

If you want the average value1 of those qualifying entries:

SELECT mean("value1") FROM "log" WHERE time > now() - 2h AND "value1" < 100

Option 3: Filter by a specific tag (e.g., name = 'h1') #

To narrow results to a specific tag value, add it to the WHERE clause:

SELECT max("value2") FROM "log" WHERE time > now() - 2h AND "value1" < 100 AND "name" = 'h1'

To set this up in Grafana:

• In the panel's Query tab, select your configured InfluxDB data source
• Paste your chosen SQL query into the query editor
• The query already uses now() - 2h, but you can also adjust the dashboard's global time range if needed

4. Customize the SingleStat Display #

Now let's tweak how the panel looks and behaves:

• Go to the Options tab
  • Stat: Choose what value to display (e.g., Current for the latest aggregated number, Mean for the average over the time range)
  • Value & Thresholds: Set thresholds to change the panel's color based on the value. For example: green if average value1 <70, yellow 70-90, red >90
  • Prefix/Suffix: Add context to the number, like Count: or Avg. Value1: before it, or % if working with percentages
  • Color Mode: Pick between Value (color the number itself) or Background (color the entire panel background)
• Head to the Visualization tab if you want to adjust font sizes, alignment, or add small icons for extra clarity

5. Save Your Panel #

Once you're satisfied with the setup, click Apply to save the panel to your dashboard.

内容的提问来源于stack exchange，提问作者shijie xu