I want to use this query to count the number of Top10, but there is a problem with this number

InfluxDB 2
1

Hi guys I want to use this query to count the number of Top10, but there is a problem with this number

from(bucket: “nginx_prod”)
|> range(start: -24h)
|> filter(fn: (r) => r[“_measurement”] == "nginx_log")
|> filter(fn: (r) => exists r["server_name"])
|> group(columns: ["server_name"])
|> count()

This query looks up the value 7727074 for www.test.com:9988 Use this query

from(bucket: “nginx_prod”)
|> range(start: -24h)
|> filter(fn: (r) => r["_measurement"] == "nginx_log")
|> filter(fn: (r) => r["server_name"] == "www.test.com:9988")
|> count()

The query returns a value of 518813
The actual value should be this 518813
What is the problem?

2

Can you add this function distinct(column: "_time") before grouping it in you first query ? Hopefully it should give you an accurate count as it will ensure unique data points by timestamp are calculated.

3

@suyash
Error after adding this query distinct(column: “_time”)

image
image1122×528 36.8 KB

4

I see, can you try the following using unique(). I tried it on mine and it worked:

from(bucket: "nginx_prod")
  |> range(start: -24h)
  |> filter(fn: (r) => r["_measurement"] == "nginx_log")
  |> filter(fn: (r) => r["server_name"] == "www.test.com:9988")
  |> unique(column: "_time")
  |> count()