Adding limit to query end value

Grafana InfluxDB
1

Hello,
i got a dashboard that displays a Value that comes out of a query to influx and i want to add a limit to it in the end of all. Any ideas? Thx.

2

Welcome @ducktales77 to the Grafana forum.

Depending on which query language you are using with InfluxDB, you can use one of the following to limit the number of rows returned.

3

Hello, thank you for the welcome and hello to all!
I am in flux and would like to limit the end result that is displayed in the dashboard coming by a query… Thank you!

4

What is your Flux query?

5

“query”: “from(bucket: "mda-ds")\r\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\r\n |> filter(fn: (r) => r["_measurement"] == "oee")\r\n |> filter(fn: (r) => r["_field"] == "OEE")\r\n |> aggregateWindow(\r\n fn: mean,\r\n column: "_value",\r\n every: if int(v: v.windowPeriod) > int(v: 5m) then v.windowPeriod else 5m,\r\n createEmpty: false,\r\n )\r\n |> mean()\r\n |> group()\r\n |> pivot(rowKey: ["_measurement"], columnKey: ["_field"], valueColumn: "_value")\r\n |> yield(name: "All durations")”,

6

Please use the Preformatted Text option when posting code (you can go back and edit your post above to make it more legible).

In what you posted, I do not see any limit function being used.

8 
“query”: “from(bucket: "mda-ds") |>range(start: v.timeRangeStart, stop: v.timeRangeStop)
 |> filter(fn: (r) => r["_measurement"] == "oee")
|> filter(fn: (r) => r["_field"] == "OEE")
 |> aggregateWindow(\r\n fn: mean,\r\n column: "_value",\r\n every: if int(v: v.windowPeriod) > int(v: 5m) then v.windowPeriod else 5m,\r\n createEmpty: false,\r\n )\r\n |> mean()\r\n |> group()\r\n |> pivot(rowKey: ["_measurement"], columnKey: ["_field"], valueColumn: "_value")\r\n |> yield(name: "All durations")”,
9

sorry, im not sure how to limit the value that is in the dashboard in the end…

10

Hi, the dashboard shows just a number and the question is how to add a linit in the end…

11

Did you read / try this?

12

thx but i found out that it limits the rows… – i want to limit the end - value that is displayed in dashboard…

13

@ducktales77

Do you mean truncate the number of digits being displayed to the right of the decimal?

image
image1088×290 32.7 KB

vs

image
image1088×290 32.5 KB

14

no i mean if the value 9 is bigger than 10 then show 10 , not more…

15

I am thoroughly confused :confused:. Maybe someone else can help.

16

Please show what you exactly mean by providing some csv sample data or some picture

17

In the picture above the 9°C or 9.40°C – limit this value so that ist not shown bigger than x e.g. 10°C. If bigger than 10°C then show 10°C. thx .

18

Still waiting for you to provide examples using data not fotos.

In the picture above its 9 so it shows 9
But if the value was bigger than 10 then show still 10

So

9.4 → 9.4
10 → 10
10.3 → 10
999.99-> 10

19

the code is in row 5 obove. yes, just give it a limit in the end… thx

20

There are only 4 rows above. Totally confusing

21 
“query”: “from(bucket: "mda-ds")\r\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\r\n |> filter(fn: (r) => r["_measurement"] == "oee")\r\n |> filter(fn: (r) => r["_field"] == "OEE")\r\n |> aggregateWindow(\r\n fn: mean,\r\n column: "_value",\r\n every: if int(v: v.windowPeriod) > int(v: 5m) then v.windowPeriod else 5m,\r\n createEmpty: false,\r\n )\r\n |> mean()\r\n |> group()\r\n |> pivot(rowKey: ["_measurement"], columnKey: ["_field"], valueColumn: "_value")\r\n |> yield(name: "All durations")”,

i meant row no. 5 starting on top