search

influxdata / influxdb

Scalable datastore for metrics, events, and real-time analytics
https://influxdata.com
Apache License 2.0
28.65k stars 3.54k forks source link

Some graph types dont make sense with some types of queries #15602

Open desa opened 4 years ago

desa commented 4 years ago

At the moment, what we display as a visualization does not necessarily accurately represent the data we have queried. In many cases, we make a best effort guess, but in some we display what I would consider to be nonsense.

  1. String data displays a constant line

The query

import "influxdata/influxdb/v1"
from(bucket: "_tasks")
  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
  |> filter(fn: (r) => r._measurement == "runs")
  |> filter(fn: (r) => r._field == "logs")
  |> v1.fieldsAsCols()

Displays Screenshot 2019-10-28 10 55 19

for this data

#group,false,false,true,true,false,true,true,true,false
#datatype,string,long,dateTime:RFC3339,dateTime:RFC3339,dateTime:RFC3339,string,string,string,string
#default,_result,,,,,,,,
,result,table,_start,_stop,_time,_measurement,status,taskID,logs
,,0,2019-10-28T14:41:20.725202Z,2019-10-28T14:56:20.725202Z,2019-10-28T14:41:30.115889Z,runs,success,04aa3f8119a48000,"[{""runID"":""04b0b37e75dac000"",""time"":""2019-10-28T10:41:30.094358-04:00"",""message"":""Started task from script: \""package main\\nimport \\\""influxdata/influxdb/monitor\\\""\\nimport \\\""influxdata/influxdb/v1\\\""\\n\\ndata = from(bucket: \\\""telegraf\\\"")\\n\\t|\u003e range(start: -15s)\\n\\t|\u003e filter(fn: (r) =\u003e\\n\\t\\t(r._measurement == \\\""cpu\\\""))\\n\\t|\u003e filter(fn: (r) =\u003e\\n\\t\\t(r._field == \\\""usage_user\\\""))\\n\\t|\u003e filter(fn: (r) =\u003e\\n\\t\\t(r.cpu == \\\""cpu-total\\\""))\\n\\t|\u003e aggregateWindow(every: 15s, fn: mean, createEmpty: false)\\n\\noption task = {name: \\\""checker\\\"", every: 15s, offset: 0s}\\n\\ncheck = {\\n\\t_check_id: \\\""04aa3f8108248000\\\"",\\n\\t_check_name: \\\""checker\\\"",\\n\\t_type: \\\""threshold\\\"",\\n\\ttags: {},\\n}\\nwarn = (r) =\u003e\\n\\t(r.usage_user \u003e 4.32)\\nmessageFn = (r) =\u003e\\n\\t(\\\""Check: ${ r._check_name } is: ${ r._level }\\\"")\\n\\ndata\\n\\t|\u003e v1.fieldsAsCols()\\n\\t|\u003e monitor.check(data: check, messageFn: messageFn, warn: warn)\""""},{""runID"":""04b0b37e75dac000"",""time"":""2019-10-28T10:41:30.258872-04:00"",""message"":""{\""total_duration\"":121478176,\""compile_duration\"":3212,\""queue_duration\"":12360,\""plan_duration\"":0,\""requeue_duration\"":0,\""execute_duration\"":121449089,\""concurrency\"":0,\""max_allocated\"":2744,\""total_allocated\"":0,\""runtime_errors\"":[],\""metadata\"":{\""influxdb/scanned-bytes\"":[8],\""influxdb/scanned-values\"":[1]}}""},{""runID"":""04b0b37e75dac000"",""time"":""2019-10-28T10:41:30.278909-04:00"",""message"":""Completed successfully""}]"
,,0,2019-10-28T14:41:20.725202Z,2019-10-28T14:56:20.725202Z,2019-10-28T14:41:45.108777Z,runs,success,04aa3f8119a48000,"[{""runID"":""04b0b38d1a9ac000"",""time"":""2019-10-28T10:41:45.087815-04:00"",""message"":""Started task from script: \""package main\\nimport \\\""influxdata/influxdb/monitor\\\""\\nimport \\\""influxdata/influxdb/v1\\\""\\n\\ndata = from(bucket: \\\""telegraf\\\"")\\n\\t|\u003e range(start: -15s)\\n\\t|\u003e filter(fn: (r) =\u003e\\n\\t\\t(r._measurement == \\\""cpu\\\""))\\n\\t|\u003e filter(fn: (r) =\u003e\\n\\t\\t(r._field == \\\""usage_user\\\""))\\n\\t|\u003e filter(fn: (r) =\u003e\\n\\t\\t(r.cpu == \\\""cpu-total\\\""))\\n\\t|\u003e aggregateWindow(every: 15s, fn: mean, createEmpty: false)\\n\\noption task = {name: \\\""checker\\\"", every: 15s, offset: 0s}\\n\\ncheck = {\\n\\t_check_id: \\\""04aa3f8108248000\\\"",\\n\\t_check_name: \\\""checker\\\"",\\n\\t_type: \\\""threshold\\\"",\\n\\ttags: {},\\n}\\nwarn = (r) =\u003e\\n\\t(r.usage_user \u003e 4.32)\\nmessageFn = (r) =\u003e\\n\\t(\\\""Check: ${ r._check_name } is: ${ r._level }\\\"")\\n\\ndata\\n\\t|\u003e v1.fieldsAsCols()\\n\\t|\u003e monitor.check(data: check, messageFn: messageFn, warn: warn)\""""},{""runID"":""04b0b38d1a9ac000"",""time"":""2019-10-28T10:41:45.184855-04:00"",""message"":""{\""total_duration\"":55777559,\""compile_duration\"":1919,\""queue_duration\"":6667,\""plan_duration\"":0,\""requeue_duration\"":0,\""execute_duration\"":55761336,\""concurrency\"":0,\""max_allocated\"":0,\""total_allocated\"":0,\""runtime_errors\"":[],\""metadata\"":{\""influxdb/scanned-bytes\"":[0],\""influxdb/scanned-values\"":[0]}}""},{""runID"":""04b0b38d1a9ac000"",""time"":""2019-10-28T10:41:45.206607-04:00"",""message"":""Completed successfully""}]"
,,0,2019-10-28T14:41:20.725202Z,2019-10-28T14:56:20.725202Z,2019-10-28T14:42:00.112063Z,runs,success,04aa3f8119a48000,"[{""runID"":""04b0b39bc11ac000"",""time"":""2019-10-28T10:42:00.090625-04:00"",""message"":""Started task from script: \""package main\\nimport \\\""influxdata/influxdb/monitor\\\""\\nimport \\\""influxdata/influxdb/v1\\\""\\n\\ndata = from(bucket: \\\""telegraf\\\"")\\n\\t|\u003e range(start: -15s)\\n\\t|\u003e filter(fn: (r) =\u003e\\n\\t\\t(r._measurement == \\\""cpu\\\""))\\n\\t|\u003e filter(fn: (r) =\u003e\\n\\t\\t(r._field == \\\""usage_user\\\""))\\n\\t|\u003e filter(fn: (r) =\u003e\\n\\t\\t(r.cpu == \\\""cpu-total\\\""))\\n\\t|\u003e aggregateWindow(every: 15s, fn: mean, createEmpty: false)\\n\\noption task = {name: \\\""checker\\\"", every: 15s, offset: 0s}\\n\\ncheck = {\\n\\t_check_id: \\\""04aa3f8108248000\\\"",\\n\\t_check_name: \\\""checker\\\"",\\n\\t_type: \\\""threshold\\\"",\\n\\ttags: {},\\n}\\nwarn = (r) =\u003e\\n\\t(r.usage_user \u003e 4.32)\\nmessageFn = (r) =\u003e\\n\\t(\\\""Check: ${ r._check_name } is: ${ r._level }\\\"")\\n\\ndata\\n\\t|\u003e v1.fieldsAsCols()\\n\\t|\u003e monitor.check(data: check, messageFn: messageFn, warn: warn)\""""},{""runID"":""04b0b39bc11ac000"",""time"":""2019-10-28T10:42:00.249148-04:00"",""message"":""{\""total_duration\"":114555828,\""compile_duration\"":2785,\""queue_duration\"":12784,\""plan_duration\"":0,\""requeue_duration\"":0,\""execute_duration\"":114525362,\""concurrency\"":0,\""max_allocated\"":2744,\""total_allocated\"":0,\""runtime_errors\"":[],\""metadata\"":{\""influxdb/scanned-bytes\"":[8],\""influxdb/scanned-values\"":[1]}}""},{""runID"":""04b0b39bc11ac000"",""time"":""2019-10-28T10:42:00.270313-04:00"",""message"":""Completed successfully""}]"
,,0,2019-10-28T14:41:20.725202Z,2019-10-28T14:56:20.725202Z,2019-10-28T14:42:15.113592Z,runs,success,04aa3f8119a48000,"[{""runID"":""04b0b3aa671ac000"",""time"":""2019-10-28T10:42:15.09204-04:00"",""message"":""Started task from script: \""package main\\nimport \\\""influxdata/influxdb/monitor\\\""\\nimport \\\""influxdata/influxdb/v1\\\""\\n\\ndata = from(bucket: \\\""telegraf\\\"")\\n\\t|\u003e range(start: -15s)\\n\\t|\u003e filter(fn: (r) =\u003e\\n\\t\\t(r._measurement == \\\""cpu\\\""))\\n\\t|\u003e filter(fn: (r) =\u003e\\n\\t\\t(r._field == \\\""usage_user\\\""))\\n\\t|\u003e filter(fn: (r) =\u003e\\n\\t\\t(r.cpu == \\\""cpu-total\\\""))\\n\\t|\u003e aggregateWindow(every: 15s, fn: mean, createEmpty: false)\\n\\noption task = {name: \\\""checker\\\"", every: 15s, offset: 0s}\\n\\ncheck = {\\n\\t_check_id: \\\""04aa3f8108248000\\\"",\\n\\t_check_name: \\\""checker\\\"",\\n\\t_type: \\\""threshold\\\"",\\n\\ttags: {},\\n}\\nwarn = (r) =\u003e\\n\\t(r.usage_user \u003e 4.32)\\nmessageFn = (r) =\u003e\\n\\t(\\\""Check: ${ r._check_name } is: ${ r._level }\\\"")\\n\\ndata\\n\\t|\u003e v1.fieldsAsCols()\\n\\t|\u003e monitor.check(data: check, messageFn: messageFn, warn: warn)\""""},{""runID"":""04b0b3aa671ac000"",""time"":""2019-10-28T10:42:15.202405-04:00"",""message"":""{\""total_duration\"":65815017,\""compile_duration\"":4802,\""queue_duration\"":37905,\""plan_duration\"":0,\""requeue_duration\"":0,\""execute_duration\"":65750741,\""concurrency\"":0,\""max_allocated\"":0,\""total_allocated\"":0,\""runtime_errors\"":[],\""metadata\"":{\""influxdb/scanned-bytes\"":[0],\""influxdb/scanned-values\"":[0]}}""},{""runID"":""04b0b3aa671ac000"",""time"":""2019-10-28T10:42:15.229598-04:00"",""message"":""Completed successfully""}]"
,,0,2019-10-28T14:41:20.725202Z,2019-10-28T14:56:20.725202Z,2019-10-28T14:42:30.112045Z,runs,success,04aa3f8119a48000,"[{""runID"":""04b0b3b90d1ac000"",""time"":""2019-10-28T10:42:30.09144-04:00"",""message"":""Started task from script: \""package main\\nimport \\\""influxdata/influxdb/monitor\\\""\\nimport \\\""influxdata/influxdb/v1\\\""\\n\\ndata = from(bucket: \\\""telegraf\\\"")\\n\\t|\u003e range(start: -15s)\\n\\t|\u003e filter(fn: (r) =\u003e\\n\\t\\t(r._measurement == \\\""cpu\\\""))\\n\\t|\u003e filter(fn: (r) =\u003e\\n\\t\\t(r._field == \\\""usage_user\\\""))\\n\\t|\u003e filter(fn: (r) =\u003e\\n\\t\\t(r.cpu == \\\""cpu-total\\\""))\\n\\t|\u003e aggregateWindow(every: 15s, fn: mean, createEmpty: false)\\n\\noption task = {name: \\\""checker\\\"", every: 15s, offset: 0s}\\n\\ncheck = {\\n\\t_check_id: \\\""04aa3f8108248000\\\"",\\n\\t_check_name: \\\""checker\\\"",\\n\\t_type: \\\""threshold\\\"",\\n\\ttags: {},\\n}\\nwarn = (r) =\u003e\\n\\t(r.usage_user \u003e 4.32)\\nmessageFn = (r) =\u003e\\n\\t(\\\""Check: ${ r._check_name } is: ${ r._level }\\\"")\\n\\ndata\\n\\t|\u003e v1.fieldsAsCols()\\n\\t|\u003e monitor.check(data: check, messageFn: messageFn, warn: warn)\""""},{""runID"":""04b0b3b90d1ac000"",""time"":""2019-10-28T10:42:30.248165-04:00"",""message"":""{\""total_duration\"":114207826,\""compile_duration\"":3064,\""queue_duration\"":11668,\""plan_duration\"":0,\""requeue_duration\"":0,\""execute_duration\"":114178794,\""concurrency\"":0,\""max_allocated\"":2744,\""total_allocated\"":0,\""runtime_errors\"":[],\""metadata\"":{\""influxdb/scanned-bytes\"":[16],\""influxdb/scanned-values\"":[2]}}""},{""runID"":""04b0b3b90d1ac000"",""time"":""2019-10-28T10:42:30.268883-04:00"",""message"":""Completed successfully""}]"
,,0,2019-10-28T14:41:20.725202Z,2019-10-28T14:56:20.725202Z,2019-10-28T14:42:45.112193Z,runs,success,04aa3f8119a48000,"[{""runID"":""04b0b3c7b3dac000"",""time"":""2019-10-28T10:42:45.092154-04:00"",""message"":""Started task from script: \""package main\\nimport \\\""influxdata/influxdb/monitor\\\""\\nimport \\\""influxdata/influxdb/v1\\\""\\n\\ndata = from(bucket: \\\""telegraf\\\"")\\n\\t|\u003e range(start: -15s)\\n\\t|\u003e filter(fn: (r) =\u003e\\n\\t\\t(r._measurement == \\\""cpu\\\""))\\n\\t|\u003e filter(fn: (r) =\u003e\\n\\t\\t(r._field == \\\""usage_user\\\""))\\n\\t|\u003e filter(fn: (r) =\u003e\\n\\t\\t(r.cpu == \\\""cpu-total\\\""))\\n\\t|\u003e aggregateWindow(every: 15s, fn: mean, createEmpty: false)\\n\\noption task = {name: \\\""checker\\\"", every: 15s, offset: 0s}\\n\\ncheck = {\\n\\t_check_id: \\\""04aa3f8108248000\\\"",\\n\\t_check_name: \\\""checker\\\"",\\n\\t_type: \\\""threshold\\\"",\\n\\ttags: {},\\n}\\nwarn = (r) =\u003e\\n\\t(r.usage_user \u003e 4.32)\\nmessageFn = (r) =\u003e\\n\\t(\\\""Check: ${ r._check_name } is: ${ r._level }\\\"")\\n\\ndata\\n\\t|\u003e v1.fieldsAsCols()\\n\\t|\u003e monitor.check(data: check, messageFn: messageFn, warn: warn)\""""},{""runID"":""04b0b3c7b3dac000"",""time"":""2019-10-28T10:42:45.255398-04:00"",""message"":""{\""total_duration\"":121852458,\""compile_duration\"":3936,\""queue_duration\"":13022,\""plan_duration\"":0,\""requeue_duration\"":0,\""execute_duration\"":121820560,\""concurrency\"":0,\""max_allocated\"":2744,\""total_allocated\"":0,\""runtime_errors\"":[],\""metadata\"":{\""influxdb/scanned-bytes\"":[8],\""influxdb/scanned-values\"":[1]}}""},{""runID"":""04b0b3c7b3dac000"",""time"":""2019-10-28T10:42:45.276357-04:00"",""message"":""Completed successfully""}]"
,,0,2019-10-28T14:41:20.725202Z,2019-10-28T14:56:20.725202Z,2019-10-28T14:43:00.112835Z,runs,success,04aa3f8119a48000,"[{""runID"":""04b0b3d6591ac000"",""time"":""2019-10-28T10:43:00.091155-04:00"",""message"":""Started task from script: \""package main\\nimport \\\""influxdata/influxdb/monitor\\\""\\nimport \\\""influxdata/influxdb/v1\\\""\\n\\ndata = from(bucket: \\\""telegraf\\\"")\\n\\t|\u003e range(start: -15s)\\n\\t|\u003e filter(fn: (r) =\u003e\\n\\t\\t(r._measurement == \\\""cpu\\\""))\\n\\t|\u003e filter(fn: (r) =\u003e\\n\\t\\t(r._field == \\\""usage_user\\\""))\\n\\t|\u003e filter(fn: (r) =\u003e\\n\\t\\t(r.cpu == \\\""cpu-total\\\""))\\n\\t|\u003e aggregateWindow(every: 15s, fn: mean, createEmpty: false)\\n\\noption task = {name: \\\""checker\\\"", every: 15s, offset: 0s}\\n\\ncheck = {\\n\\t_check_id: \\\""04aa3f8108248000\\\"",\\n\\t_check_name: \\\""checker\\\"",\\n\\t_type: \\\""threshold\\\"",\\n\\ttags: {},\\n}\\nwarn = (r) =\u003e\\n\\t(r.usage_user \u003e 4.32)\\nmessageFn = (r) =\u003e\\n\\t(\\\""Check: ${ r._check_name } is: ${ r._level }\\\"")\\n\\ndata\\n\\t|\u003e v1.fieldsAsCols()\\n\\t|\u003e monitor.check(data: check, messageFn: messageFn, warn: warn)\""""},{""runID"":""04b0b3d6591ac000"",""time"":""2019-10-28T10:43:00.252387-04:00"",""message"":""{\""total_duration\"":117081825,\""compile_duration\"":6610,\""queue_duration\"":14001,\""plan_duration\"":0,\""requeue_duration\"":0,\""execute_duration\"":117046380,\""concurrency\"":0,\""max_allocated\"":2744,\""total_allocated\"":0,\""runtime_errors\"":[],\""metadata\"":{\""influxdb/scanned-bytes\"":[8],\""influxdb/scanned-values\"":[1]}}""},{""runID"":""04b0b3d6591ac000"",""time"":""2019-10-28T10:43:00.273454-04:00"",""message"":""Completed successfully""}]"
,,0,2019-10-28T14:41:20.725202Z,2019-10-28T14:56:20.725202Z,2019-10-28T14:43:15.118251Z,runs,success,04aa3f8119a48000,"[{""runID"":""04b0b3e4ffdac000"",""time"":""2019-10-28T10:43:15.094698-04:00"",""message"":""Started task from script: \""package main\\nimport \\\""influxdata/influxdb/monitor\\\""\\nimport \\\""influxdata/influxdb/v1\\\""\\n\\ndata = from(bucket: \\\""telegraf\\\"")\\n\\t|\u003e range(start: -15s)\\n\\t|\u003e filter(fn: (r) =\u003e\\n\\t\\t(r._measurement == \\\""cpu\\\""))\\n\\t|\u003e filter(fn: (r) =\u003e\\n\\t\\t(r._field == \\\""usage_user\\\""))\\n\\t|\u003e filter(fn: (r) =\u003e\\n\\t\\t(r.cpu == \\\""cpu-total\\\""))\\n\\t|\u003e aggregateWindow(every: 15s, fn: mean, createEmpty: false)\\n\\noption task = {name: \\\""checker\\\"", every: 15s, offset: 0s}\\n\\ncheck = {\\n\\t_check_id: \\\""04aa3f8108248000\\\"",\\n\\t_check_name: \\\""checker\\\"",\\n\\t_type: \\\""threshold\\\"",\\n\\ttags: {},\\n}\\nwarn = (r) =\u003e\\n\\t(r.usage_user \u003e 4.32)\\nmessageFn = (r) =\u003e\\n\\t(\\\""Check: ${ r._check_name } is: ${ r._level }\\\"")\\n\\ndata\\n\\t|\u003e v1.fieldsAsCols()\\n\\t|\u003e monitor.check(data: check, messageFn: messageFn, warn: warn)\""""},{""runID"":""04b0b3e4ffdac000"",""time"":""2019-10-28T10:43:15.272257-04:00"",""message"":""{\""total_duration\"":132833827,\""compile_duration\"":4404,\""queue_duration\"":15115,\""plan_duration\"":0,\""requeue_duration\"":0,\""execute_duration\"":132794887,\""concurrency\"":0,\""max_allocated\"":2744,\""total_allocated\"":0,\""runtime_errors\"":[],\""metadata\"":{\""influxdb/scanned-bytes\"":[8],\""influxdb/scanned-values\"":[1]}}""},{""runID"":""04b0b3e4ffdac000"",""time"":""2019-10-28T10:43:15.292716-04:00"",""message"":""Completed successfully""}]"
,,0,2019-10-28T14:41:20.725202Z,2019-10-28T14:56:20.725202Z,2019-10-28T14:43:30.11437Z,runs,success,04aa3f8119a48000,"[{""runID"":""04b0b3f3a5dac000"",""time"":""2019-10-28T10:43:30.093545-04:00"",""message"":""Started task from script: \""package main\\nimport \\\""influxdata/influxdb/monitor\\\""\\nimport \\\""influxdata/influxdb/v1\\\""\\n\\ndata = from(bucket: \\\""telegraf\\\"")\\n\\t|\u003e range(start: -15s)\\n\\t|\u003e filter(fn: (r) =\u003e\\n\\t\\t(r._measurement == \\\""cpu\\\""))\\n\\t|\u003e filter(fn: (r) =\u003e\\n\\t\\t(r._field == \\\""usage_user\\\""))\\n\\t|\u003e filter(fn: (r) =\u003e\\n\\t\\t(r.cpu == \\\""cpu-total\\\""))\\n\\t|\u003e aggregateWindow(every: 15s, fn: mean, createEmpty: false)\\n\\noption task = {name: \\\""checker\\\"", every: 15s, offset: 0s}\\n\\ncheck = {\\n\\t_check_id: \\\""04aa3f8108248000\\\"",\\n\\t_check_name: \\\""checker\\\"",\\n\\t_type: \\\""threshold\\\"",\\n\\ttags: {},\\n}\\nwarn = (r) =\u003e\\n\\t(r.usage_user \u003e 4.32)\\nmessageFn = (r) =\u003e\\n\\t(\\\""Check: ${ r._check_name } is: ${ r._level }\\\"")\\n\\ndata\\n\\t|\u003e v1.fieldsAsCols()\\n\\t|\u003e monitor.check(data: check, messageFn: messageFn, warn: warn)\""""},{""runID"":""04b0b3f3a5dac000"",""time"":""2019-10-28T10:43:30.258482-04:00"",""message"":""{\""total_duration\"":123543943,\""compile_duration\"":2936,\""queue_duration\"":12408,\""plan_duration\"":0,\""requeue_duration\"":0,\""execute_duration\"":123511224,\""concurrency\"":0,\""max_allocated\"":2744,\""total_allocated\"":0,\""runtime_errors\"":[],\""metadata\"":{\""influxdb/scanned-bytes\"":[16],\""influxdb/scanned-values\"":[2]}}""},{""runID"":""04b0b3f3a5dac000"",""time"":""2019-10-28T10:43:30.278834-04:00"",""message"":""Completed successfully""}]"
,,0,2019-10-28T14:41:20.725202Z,2019-10-28T14:56:20.725202Z,2019-10-28T14:43:45.113044Z,runs,success,04aa3f8119a48000,"[{""runID"":""04b0b4024b5ac000"",""time"":""2019-10-28T10:43:45.091939-04:00"",""message"":""Started task from script: \""package main\\nimport \\\""influxdata/influxdb/monitor\\\""\\nimport \\\""influxdata/influxdb/v1\\\""\\n\\ndata = from(bucket: \\\""telegraf\\\"")\\n\\t|\u003e range(start: -15s)\\n\\t|\u003e filter(fn: (r) =\u003e\\n\\t\\t(r._measurement == \\\""cpu\\\""))\\n\\t|\u003e filter(fn: (r) =\u003e\\n\\t\\t(r._field == \\\""usage_user\\\""))\\n\\t|\u003e filter(fn: (r) =\u003e\\n\\t\\t(r.cpu == \\\""cpu-total\\\""))\\n\\t|\u003e aggregateWindow(every: 15s, fn: mean, createEmpty: false)\\n\\noption task = {name: \\\""checker\\\"", every: 15s, offset: 0s}\\n\\ncheck = {\\n\\t_check_id: \\\""04aa3f8108248000\\\"",\\n\\t_check_name: \\\""checker\\\"",\\n\\t_type: \\\""threshold\\\"",\\n\\ttags: {},\\n}\\nwarn = (r) =\u003e\\n\\t(r.usage_user \u003e 4.32)\\nmessageFn = (r) =\u003e\\n\\t(\\\""Check: ${ r._check_name } is: ${ r._level }\\\"")\\n\\ndata\\n\\t|\u003e v1.fieldsAsCols()\\n\\t|\u003e monitor.check(data: check, messageFn: messageFn, warn: warn)\""""},{""runID"":""04b0b4024b5ac000"",""time"":""2019-10-28T10:43:45.205741-04:00"",""message"":""{\""total_duration\"":70608506,\""compile_duration\"":2829,\""queue_duration\"":12560,\""plan_duration\"":0,\""requeue_duration\"":0,\""execute_duration\"":70582325,\""concurrency\"":0,\""max_allocated\"":0,\""total_allocated\"":0,\""runtime_errors\"":[],\""metadata\"":{\""influxdb/scanned-bytes\"":[0],\""influxdb/scanned-values\"":[0]}}""},{""runID"":""04b0b4024b5ac000"",""time"":""2019-10-28T10:43:45.227544-04:00"",""message"":""Completed successfully""}]"
,,0,2019-10-28T14:41:20.725202Z,2019-10-28T14:56:20.725202Z,2019-10-28T14:44:00.112954Z,runs,success,04aa3f8119a48000,"[{""runID"":""04b0b410f19ac000"",""time"":""2019-10-28T10:44:00.092733-04:00"",""message"":""Started task from script: \""package main\\nimport \\\""influxdata/influxdb/monitor\\\""\\nimport \\\""influxdata/influxdb/v1\\\""\\n\\ndata = from(bucket: \\\""telegraf\\\"")\\n\\t|\u003e range(start: -15s)\\n\\t|\u003e filter(fn: (r) =\u003e\\n\\t\\t(r._measurement == \\\""cpu\\\""))\\n\\t|\u003e filter(fn: (r) =\u003e\\n\\t\\t(r._field == \\\""usage_user\\\""))\\n\\t|\u003e filter(fn: (r) =\u003e\\n\\t\\t(r.cpu == \\\""cpu-total\\\""))\\n\\t|\u003e aggregateWindow(every: 15s, fn: mean, createEmpty: false)\\n\\noption task = {name: \\\""checker\\\"", every: 15s, offset: 0s}\\n\\ncheck = {\\n\\t_check_id: \\\""04aa3f8108248000\\\"",\\n\\t_check_name: \\\""checker\\\"",\\n\\t_type: \\\""threshold\\\"",\\n\\ttags: {},\\n}\\nwarn = (r) =\u003e\\n\\t(r.usage_user \u003e 4.32)\\nmessageFn = (r) =\u003e\\n\\t(\\\""Check: ${ r._check_name } is: ${ r._level }\\\"")\\n\\ndata\\n\\t|\u003e v1.fieldsAsCols()\\n\\t|\u003e monitor.check(data: check, messageFn: messageFn, warn: warn)\""""},{""runID"":""04b0b410f19ac000"",""time"":""2019-10-28T10:44:00.253283-04:00"",""message"":""{\""total_duration\"":117981594,\""compile_duration\"":4320,\""queue_duration\"":14836,\""plan_duration\"":0,\""requeue_duration\"":0,\""execute_duration\"":117943839,\""concurrency\"":0,\""max_allocated\"":2744,\""total_allocated\"":0,\""runtime_errors\"":[],\""metadata\"":{\""influxdb/scanned-bytes\"":[16],\""influxdb/scanned-values\"":[2]}}""},{""runID"":""04b0b410f19ac000"",""time"":""2019-10-28T10:44:00.275298-04:00"",""message"":""Completed successfully""}]"
,,0,2019-10-28T14:41:20.725202Z,2019-10-28T14:56:20.725202Z,2019-10-28T14:44:15.194194Z,runs,success,04aa3f8119a48000,"[{""runID"":""04b0b41f979ac000"",""time"":""2019-10-28T10:44:15.170963-04:00"",""message"":""Started task from script: \""package main\\nimport \\\""influxdata/influxdb/monitor\\\""\\nimport \\\""influxdata/influxdb/v1\\\""\\n\\ndata = from(bucket: \\\""telegraf\\\"")\\n\\t|\u003e range(start: -15s)\\n\\t|\u003e filter(fn: (r) =\u003e\\n\\t\\t(r._measurement == \\\""cpu\\\""))\\n\\t|\u003e filter(fn: (r) =\u003e\\n\\t\\t(r._field == \\\""usage_user\\\""))\\n\\t|\u003e filter(fn: (r) =\u003e\\n\\t\\t(r.cpu == \\\""cpu-total\\\""))\\n\\t|\u003e aggregateWindow(every: 15s, fn: mean, createEmpty: false)\\n\\noption task = {name: \\\""checker\\\"", every: 15s, offset: 0s}\\n\\ncheck = {\\n\\t_check_id: \\\""04aa3f8108248000\\\"",\\n\\t_check_name: \\\""checker\\\"",\\n\\t_type: \\\""threshold\\\"",\\n\\ttags: {},\\n}\\nwarn = (r) =\u003e\\n\\t(r.usage_user \u003e 4.32)\\nmessageFn = (r) =\u003e\\n\\t(\\\""Check: ${ r._check_name } is: ${ r._level }\\\"")\\n\\ndata\\n\\t|\u003e v1.fieldsAsCols()\\n\\t|\u003e monitor.check(data: check, messageFn: messageFn, warn: warn)\""""},{""runID"":""04b0b41f979ac000"",""time"":""2019-10-28T10:44:15.286835-04:00"",""message"":""{\""total_duration\"":69884495,\""compile_duration\"":2932,\""queue_duration\"":12349,\""plan_duration\"":0,\""requeue_duration\"":0,\""execute_duration\"":69857924,\""concurrency\"":0,\""max_allocated\"":0,\""total_allocated\"":0,\""runtime_errors\"":[],\""metadata\"":{\""influxdb/scanned-bytes\"":[0],\""influxdb/scanned-values\"":[0]}}""},{""runID"":""04b0b41f979ac000"",""time"":""2019-10-28T10:44:15.309233-04:00"",""message"":""Completed successfully""}]"
,,0,2019-10-28T14:41:20.725202Z,2019-10-28T14:56:20.725202Z,2019-10-28T14:44:30.116733Z,runs,success,04aa3f8119a48000,"[{""runID"":""04b0b42e3e1ac000"",""time"":""2019-10-28T10:44:30.096002-04:00"",""message"":""Started task from script: \""package main\\nimport \\\""influxdata/influxdb/monitor\\\""\\nimport \\\""influxdata/influxdb/v1\\\""\\n\\ndata = from(bucket: \\\""telegraf\\\"")\\n\\t|\u003e range(start: -15s)\\n\\t|\u003e filter(fn: (r) =\u003e\\n\\t\\t(r._measurement == \\\""cpu\\\""))\\n\\t|\u003e filter(fn: (r) =\u003e\\n\\t\\t(r._field == \\\""usage_user\\\""))\\n\\t|\u003e filter(fn: (r) =\u003e\\n\\t\\t(r.cpu == \\\""cpu-total\\\""))\\n\\t|\u003e aggregateWindow(every: 15s, fn: mean, createEmpty: false)\\n\\noption task = {name: \\\""checker\\\"", every: 15s, offset: 0s}\\n\\ncheck = {\\n\\t_check_id: \\\""04aa3f8108248000\\\"",\\n\\t_check_name: \\\""checker\\\"",\\n\\t_type: \\\""threshold\\\"",\\n\\ttags: {},\\n}\\nwarn = (r) =\u003e\\n\\t(r.usage_user \u003e 4.32)\\nmessageFn = (r) =\u003e\\n\\t(\\\""Check: ${ r._check_name } is: ${ r._level }\\\"")\\n\\ndata\\n\\t|\u003e v1.fieldsAsCols()\\n\\t|\u003e monitor.check(data: check, messageFn: messageFn, warn: warn)\""""},{""runID"":""04b0b42e3e1ac000"",""time"":""2019-10-28T10:44:30.255232-04:00"",""message"":""{\""total_duration\"":117983434,\""compile_duration\"":2665,\""queue_duration\"":8414,\""plan_duration\"":0,\""requeue_duration\"":0,\""execute_duration\"":117959267,\""concurrency\"":0,\""max_allocated\"":2744,\""total_allocated\"":0,\""runtime_errors\"":[],\""metadata\"":{\""influxdb/scanned-bytes\"":[8],\""influxdb/scanned-values\"":[1]}}""},{""runID"":""04b0b42e3e1ac000"",""time"":""2019-10-28T10:44:30.275754-04:00"",""message"":""Completed successfully""}]"
,,0,2019-10-28T14:41:20.725202Z,2019-10-28T14:56:20.725202Z,2019-10-28T14:44:45.135159Z,runs,success,04aa3f8119a48000,"[{""runID"":""04b0b43ce3dac000"",""time"":""2019-10-28T10:44:45.113283-04:00"",""message"":""Started task from script: \""package main\\nimport \\\""influxdata/influxdb/monitor\\\""\\nimport \\\""influxdata/influxdb/v1\\\""\\n\\ndata = from(bucket: \\\""telegraf\\\"")\\n\\t|\u003e range(start: -15s)\\n\\t|\u003e filter(fn: (r) =\u003e\\n\\t\\t(r._measurement == \\\""cpu\\\""))\\n\\t|\u003e filter(fn: (r) =\u003e\\n\\t\\t(r._field == \\\""usage_user\\\""))\\n\\t|\u003e filter(fn: (r) =\u003e\\n\\t\\t(r.cpu == \\\""cpu-total\\\""))\\n\\t|\u003e aggregateWindow(every: 15s, fn: mean, createEmpty: false)\\n\\noption task = {name: \\\""checker\\\"", every: 15s, offset: 0s}\\n\\ncheck = {\\n\\t_check_id: \\\""04aa3f8108248000\\\"",\\n\\t_check_name: \\\""checker\\\"",\\n\\t_type: \\\""threshold\\\"",\\n\\ttags: {},\\n}\\nwarn = (r) =\u003e\\n\\t(r.usage_user \u003e 4.32)\\nmessageFn = (r) =\u003e\\n\\t(\\\""Check: ${ r._check_name } is: ${ r._level }\\\"")\\n\\ndata\\n\\t|\u003e v1.fieldsAsCols()\\n\\t|\u003e monitor.check(data: check, messageFn: messageFn, warn: warn)\""""},{""runID"":""04b0b43ce3dac000"",""time"":""2019-10-28T10:44:45.226931-04:00"",""message"":""{\""total_duration\"":70781345,\""compile_duration\"":2182,\""queue_duration\"":7214,\""plan_duration\"":0,\""requeue_duration\"":0,\""execute_duration\"":70763215,\""concurrency\"":0,\""max_allocated\"":0,\""total_allocated\"":0,\""runtime_errors\"":[],\""metadata\"":{\""influxdb/scanned-bytes\"":[0],\""influxdb/scanned-values\"":[0]}}""},{""runID"":""04b0b43ce3dac000"",""time"":""2019-10-28T10:44:45.248597-04:00"",""message"":""Completed successfully""}]"
,,0,2019-10-28T14:41:20.725202Z,2019-10-28T14:56:20.725202Z,2019-10-28T14:45:00.113644Z,runs,success,04aa3f8119a48000,"[{""runID"":""04b0b44b899ac000"",""time"":""2019-10-28T10:45:00.092783-04:00"",""message"":""Started task from script: \""package main\\nimport \\\""influxdata/influxdb/monitor\\\""\\nimport \\\""influxdata/influxdb/v1\\\""\\n\\ndata = from(bucket: \\\""telegraf\\\"")\\n\\t|\u003e range(start: -15s)\\n\\t|\u003e filter(fn: (r) =\u003e\\n\\t\\t(r._measurement == \\\""cpu\\\""))\\n\\t|\u003e filter(fn: (r) =\u003e\\n\\t\\t(r._field == \\\""usage_user\\\""))\\n\\t|\u003e filter(fn: (r) =\u003e\\n\\t\\t(r.cpu == \\\""cpu-total\\\""))\\n\\t|\u003e aggregateWindow(every: 15s, fn: mean, createEmpty: false)\\n\\noption task = {name: \\\""checker\\\"", every: 15s, offset: 0s}\\n\\ncheck = {\\n\\t_check_id: \\\""04aa3f8108248000\\\"",\\n\\t_check_name: \\\""checker\\\"",\\n\\t_type: \\\""threshold\\\"",\\n\\ttags: {},\\n}\\nwarn = (r) =\u003e\\n\\t(r.usage_user \u003e 4.32)\\nmessageFn = (r) =\u003e\\n\\t(\\\""Check: ${ r._check_name } is: ${ r._level }\\\"")\\n\\ndata\\n\\t|\u003e v1.fieldsAsCols()\\n\\t|\u003e monitor.check(data: check, messageFn: messageFn, warn: warn)\""""},{""runID"":""04b0b44b899ac000"",""time"":""2019-10-28T10:45:00.271061-04:00"",""message"":""{\""total_duration\"":135971847,\""compile_duration\"":2144,\""queue_duration\"":7763,\""plan_duration\"":0,\""requeue_duration\"":0,\""execute_duration\"":135951535,\""concurrency\"":0,\""max_allocated\"":2744,\""total_allocated\"":0,\""runtime_errors\"":[],\""metadata\"":{\""influxdb/scanned-bytes\"":[16],\""influxdb/scanned-values\"":[2]}}""},{""runID"":""04b0b44b899ac000"",""time"":""2019-10-28T10:45:00.292236-04:00"",""message"":""Completed successfully""}]"
,,0,2019-10-28T14:41:20.725202Z,2019-10-28T14:56:20.725202Z,2019-10-28T14:45:15.112269Z,runs,success,04aa3f8119a48000,"[{""runID"":""04b0b45a2f5ac000"",""time"":""2019-10-28T10:45:15.091868-04:00"",""message"":""Started task from script: \""package main\\nimport \\\""influxdata/influxdb/monitor\\\""\\nimport \\\""influxdata/influxdb/v1\\\""\\n\\ndata = from(bucket: \\\""telegraf\\\"")\\n\\t|\u003e range(start: -15s)\\n\\t|\u003e filter(fn: (r) =\u003e\\n\\t\\t(r._measurement == \\\""cpu\\\""))\\n\\t|\u003e filter(fn: (r) =\u003e\\n\\t\\t(r._field == \\\""usage_user\\\""))\\n\\t|\u003e filter(fn: (r) =\u003e\\n\\t\\t(r.cpu == \\\""cpu-total\\\""))\\n\\t|\u003e aggregateWindow(every: 15s, fn: mean, createEmpty: false)\\n\\noption task = {name: \\\""checker\\\"", every: 15s, offset: 0s}\\n\\ncheck = {\\n\\t_check_id: \\\""04aa3f8108248000\\\"",\\n\\t_check_name: \\\""checker\\\"",\\n\\t_type: \\\""threshold\\\"",\\n\\ttags: {},\\n}\\nwarn = (r) =\u003e\\n\\t(r.usage_user \u003e 4.32)\\nmessageFn = (r) =\u003e\\n\\t(\\\""Check: ${ r._check_name } is: ${ r._level }\\\"")\\n\\ndata\\n\\t|\u003e v1.fieldsAsCols()\\n\\t|\u003e monitor.check(data: check, messageFn: messageFn, warn: warn)\""""},{""runID"":""04b0b45a2f5ac000"",""time"":""2019-10-28T10:45:15.253574-04:00"",""message"":""{\""total_duration\"":120303709,\""compile_duration\"":2093,\""queue_duration\"":7628,\""plan_duration\"":0,\""requeue_duration\"":0,\""execute_duration\"":120282992,\""concurrency\"":0,\""max_allocated\"":2744,\""total_allocated\"":0,\""runtime_errors\"":[],\""metadata\"":{\""influxdb/scanned-bytes\"":[8],\""influxdb/scanned-values\"":[1]}}""},{""runID"":""04b0b45a2f5ac000"",""time"":""2019-10-28T10:45:15.274023-04:00"",""message"":""Completed successfully""}]"
,,0,2019-10-28T14:41:20.725202Z,2019-10-28T14:56:20.725202Z,2019-10-28T14:45:30.114832Z,runs,success,04aa3f8119a48000,"[{""runID"":""04b0b468d5dac000"",""time"":""2019-10-28T10:45:30.094234-04:00"",""message"":""Started task from script: \""package main\\nimport \\\""influxdata/influxdb/monitor\\\""\\nimport \\\""influxdata/influxdb/v1\\\""\\n\\ndata = from(bucket: \\\""telegraf\\\"")\\n\\t|\u003e range(start: -15s)\\n\\t|\u003e filter(fn: (r) =\u003e\\n\\t\\t(r._measurement == \\\""cpu\\\""))\\n\\t|\u003e filter(fn: (r) =\u003e\\n\\t\\t(r._field == \\\""usage_user\\\""))\\n\\t|\u003e filter(fn: (r) =\u003e\\n\\t\\t(r.cpu == \\\""cpu-total\\\""))\\n\\t|\u003e aggregateWindow(every: 15s, fn: mean, createEmpty: false)\\n\\noption task = {name: \\\""checker\\\"", every: 15s, offset: 0s}\\n\\ncheck = {\\n\\t_check_id: \\\""04aa3f8108248000\\\"",\\n\\t_check_name: \\\""checker\\\"",\\n\\t_type: \\\""threshold\\\"",\\n\\ttags: {},\\n}\\nwarn = (r) =\u003e\\n\\t(r.usage_user \u003e 4.32)\\nmessageFn = (r) =\u003e\\n\\t(\\\""Check: ${ r._check_name } is: ${ r._level }\\\"")\\n\\ndata\\n\\t|\u003e v1.fieldsAsCols()\\n\\t|\u003e monitor.check(data: check, messageFn: messageFn, warn: warn)\""""},{""runID"":""04b0b468d5dac000"",""time"":""2019-10-28T10:45:30.25287-04:00"",""message"":""{\""total_duration\"":117718402,\""compile_duration\"":2303,\""queue_duration\"":10192,\""plan_duration\"":0,\""requeue_duration\"":0,\""execute_duration\"":117694792,\""concurrency\"":0,\""max_allocated\"":2744,\""total_allocated\"":0,\""runtime_errors\"":[],\""metadata\"":{\""influxdb/scanned-bytes\"":[16],\""influxdb/scanned-values\"":[2]}}""},{""runID"":""04b0b468d5dac000"",""time"":""2019-10-28T10:45:30.272817-04:00"",""message"":""Completed successfully""}]"
,,0,2019-10-28T14:41:20.725202Z,2019-10-28T14:56:20.725202Z,2019-10-28T14:45:45.115725Z,runs,success,04aa3f8119a48000,"
...
  1. Single stat picks arbitrary value from data returned The query 
    from(bucket: "telegraf")
|> range(start: v.timeRangeStart, stop: v.timeRangeStop)
|> filter(fn: (r) => r._measurement == "cpu")
|> filter(fn: (r) => r._field == "usage_user")
|> filter(fn: (r) => r.cpu == "cpu0" or r.cpu == "cpu1" or r.cpu == "cpu10")

    returns 3 series each of which are visible in the line graph

Screenshot 2019-10-28 11 00 36

However, when viewed as a single stat or guage, we get

Screenshot 2019-10-28 11 01 20

stale[bot] commented 4 years ago

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.

stale[bot] commented 4 years ago

This issue has been automatically closed because it has not had recent activity. Please reopen if this issue is still important to you. Thank you for your contributions.