apiVersion: influxdata.com/v2alpha1 kind: Label metadata: name: agitated-driscoll-46e001 spec: color: '#00C9FF' name: island_pulse --- apiVersion: influxdata.com/v2alpha1 kind: Bucket metadata: name: wondrous-blackburn-46e005 spec: associations: - kind: Label name: agitated-driscoll-46e001 name: node8 --- apiVersion: influxdata.com/v2alpha1 kind: CheckThreshold metadata: name: ecstatic-pasteur-c6e001 spec: associations: - kind: Label name: agitated-driscoll-46e001 every: 15m0s name: Kailua Threshold query: |- from(bucket: "node8") |> range(start: v.timeRangeStart, stop: v.timeRangeStop) |> filter(fn: (r) => r["_measurement"] == "modbus") |> filter(fn: (r) => r["_field"] == "Central/Wahiawa") |> aggregateWindow(every: 1m, fn: mean) |> yield(name: "mean") status: active statusMessageTemplate: 'Check: ${ r._check_name } is: ${ r._level }' thresholds: - level: CRIT type: greater value: 5 - level: WARN max: 5 min: 3 type: inside_range - level: OK type: lesser value: 3 --- apiVersion: influxdata.com/v2alpha1 kind: CheckThreshold metadata: name: fasting-mahavira-06e001 spec: associations: - kind: Label name: agitated-driscoll-46e001 every: 15m0s name: University/Manoa Threshold query: |- from(bucket: "node8") |> range(start: v.timeRangeStart, stop: v.timeRangeStop) |> filter(fn: (r) => r["_measurement"] == "modbus") |> filter(fn: (r) => r["_field"] == "University/Manoa") |> aggregateWindow(every: 1m, fn: mean) |> yield(name: "mean") status: active statusMessageTemplate: 'Check: ${ r._check_name } is: ${ r._level }' thresholds: - level: CRIT type: greater value: 3 - level: WARN max: 3 min: 2 type: inside_range - level: OK type: lesser value: 2 --- apiVersion: influxdata.com/v2alpha1 kind: CheckThreshold metadata: name: gallant-swartz-c6e000 spec: associations: - kind: Label name: agitated-driscoll-46e001 every: 15m0s name: Kahuku Threshold query: |- from(bucket: "node8") |> range(start: v.timeRangeStart, stop: v.timeRangeStop) |> filter(fn: (r) => r["_measurement"] == "modbus") |> filter(fn: (r) => r["_field"] == "Central/Wahiawa") |> aggregateWindow(every: 1m, fn: mean) |> yield(name: "mean") status: active statusMessageTemplate: 'Check: ${ r._check_name } is: ${ r._level }' thresholds: - level: CRIT type: greater value: 8 - level: WARN max: 8 min: 5 type: inside_range - level: OK type: lesser value: 5 --- apiVersion: influxdata.com/v2alpha1 kind: CheckThreshold metadata: name: goofy-wright-06e005 spec: associations: - kind: Label name: agitated-driscoll-46e001 every: 15m0s name: Kalihi Threshold query: |- from(bucket: "node8") |> range(start: v.timeRangeStart, stop: v.timeRangeStop) |> filter(fn: (r) => r["_measurement"] == "modbus") |> filter(fn: (r) => r["_field"] == "Kalihi") |> aggregateWindow(every: 1m, fn: mean) |> yield(name: "mean") status: active statusMessageTemplate: 'Check: ${ r._check_name } is: ${ r._level }' thresholds: - level: CRIT type: greater value: 7 - level: WARN max: 7 min: 5 type: inside_range - level: OK type: lesser value: 5 --- apiVersion: influxdata.com/v2alpha1 kind: CheckThreshold metadata: name: practical-colden-06e001 spec: associations: - kind: Label name: agitated-driscoll-46e001 every: 15m0s name: Island Pulse `Total_System_Generation` Threshold query: |- from(bucket: "node8") |> range(start: v.timeRangeStart, stop: v.timeRangeStop) |> filter(fn: (r) => r["_measurement"] == "modbus") |> filter(fn: (r) => r["_field"] == "Total_System_Generation") |> aggregateWindow(every: 1m, fn: mean) |> yield(name: "mean") status: active statusMessageTemplate: 'Check: ${ r._check_name } is: ${ r._level }' thresholds: - level: CRIT type: lesser value: 430 - level: WARN max: 600 min: 431 type: inside_range - level: INFO max: 720 min: 601 type: inside_range - level: OK type: greater value: 721 --- apiVersion: influxdata.com/v2alpha1 kind: CheckThreshold metadata: name: rustling-wu-46e001 spec: associations: - kind: Label name: agitated-driscoll-46e001 every: 15m0s name: Ewa Threshold query: |- from(bucket: "node8") |> range(start: v.timeRangeStart, stop: v.timeRangeStop) |> filter(fn: (r) => r["_measurement"] == "modbus") |> filter(fn: (r) => r["_field"] == "Central/Wahiawa") |> aggregateWindow(every: 1m, fn: mean) |> yield(name: "mean") status: active statusMessageTemplate: 'Check: ${ r._check_name } is: ${ r._level }' thresholds: - level: CRIT type: greater value: 7 - level: OK type: lesser value: 5 - level: WARN max: 7 min: 5 type: inside_range --- apiVersion: influxdata.com/v2alpha1 kind: CheckThreshold metadata: name: terrifying-ride-c6e004 spec: associations: - kind: Label name: agitated-driscoll-46e001 every: 15m0s name: Downtown Threshold query: |- from(bucket: "node8") |> range(start: v.timeRangeStart, stop: v.timeRangeStop) |> filter(fn: (r) => r["_measurement"] == "modbus") |> filter(fn: (r) => r["_field"] == "Central/Wahiawa") |> aggregateWindow(every: 1m, fn: mean) |> yield(name: "mean") status: active statusMessageTemplate: 'Check: ${ r._check_name } is: ${ r._level }' thresholds: - level: CRIT type: greater value: 28 - level: WARN max: 28 min: 20 type: inside_range - level: OK type: lesser value: 20 --- apiVersion: influxdata.com/v2alpha1 kind: CheckThreshold metadata: name: vivid-bhabha-c6e008 spec: associations: - kind: Label name: agitated-driscoll-46e001 every: 15m0s name: Airport Threshold query: |- from(bucket: "node8") |> range(start: v.timeRangeStart, stop: v.timeRangeStop) |> filter(fn: (r) => r["_measurement"] == "modbus") |> filter(fn: (r) => r["_field"] == "Airport") |> aggregateWindow(every: 1m, fn: mean) |> yield(name: "mean") status: active statusMessageTemplate: 'Check: ${ r._check_name } is: ${ r._level }' thresholds: - level: CRIT type: greater value: 10 - level: WARN max: 9 min: 6 type: inside_range - level: OK type: lesser value: 6 --- apiVersion: influxdata.com/v2alpha1 kind: CheckThreshold metadata: name: wizardly-wilson-c6e00c spec: associations: - kind: Label name: agitated-driscoll-46e001 every: 15m0s name: Central/Wahiawa Threshold query: |- from(bucket: "node8") |> range(start: v.timeRangeStart, stop: v.timeRangeStop) |> filter(fn: (r) => r["_measurement"] == "modbus") |> filter(fn: (r) => r["_field"] == "Central/Wahiawa") |> aggregateWindow(every: 1m, fn: mean) |> yield(name: "mean") status: active statusMessageTemplate: 'Check: ${ r._check_name } is: ${ r._level }' thresholds: - level: WARN max: 7 min: 5 type: inside_range - level: OK type: lesser value: 5 - level: CRIT type: greater value: 7 --- apiVersion: influxdata.com/v2alpha1 kind: Variable metadata: name: sharp-mahavira-06e00d spec: associations: - kind: Label name: agitated-driscoll-46e001 name: area_names type: constant values: - Airport - Central/Wahiawa - Downtown - Ewa - Kahuku - Kailua - Kalihi - University/Manoa --- apiVersion: influxdata.com/v2alpha1 kind: Variable metadata: name: suspicious-kare-06e009 spec: associations: - kind: Label name: agitated-driscoll-46e001 name: energy_types type: constant values: - Total_System_Generation - BioFuel - Coal - Fossil_Fuel - Solar - Waste2Energy - WindFarm --- apiVersion: influxdata.com/v2alpha1 kind: Dashboard metadata: name: agreeing-chatelet-46e001 spec: associations: - kind: Label name: agitated-driscoll-46e001 charts: - colors: - hex: '#7CE490' name: honeydew type: text decimalPlaces: 0 height: 1 kind: Single_Stat name: "\U0001F50C Today's usage" queries: - query: |- from(bucket: "node8") |> range(start: -1d, stop: now()) |> filter(fn: (r) => r["_measurement"] == "modbus") |> filter(fn: (r) => r["_field"] == "Airport" or r["_field"] == "Central/Wahiawa" or r["_field"] == "Downtown" or r["_field"] == "Ewa" or r["_field"] == "Kahuku" or r["_field"] == "Kailua" or r["_field"] == "Kalihi" or r["_field"] == "University/Manoa") |> group(columns: ["_measurement"]) |> sum(column: "_value") |> map(fn: (r) => ({ r with _value: r._value / 100.0 })) suffix: ' MWs' width: 4 - colors: - hex: '#00C9FF' name: laser type: text decimalPlaces: 0 height: 1 kind: Single_Stat name: "\U0001F50C Yesterday's usage" queries: - query: |- from(bucket: "node8") |> range(start: -2d, stop: -12h) |> filter(fn: (r) => r["_measurement"] == "modbus") |> filter(fn: (r) => r["_field"] == "Airport" or r["_field"] == "Central/Wahiawa" or r["_field"] == "Downtown" or r["_field"] == "Ewa" or r["_field"] == "Kahuku" or r["_field"] == "Kailua" or r["_field"] == "Kalihi" or r["_field"] == "University/Manoa") |> group(columns: ["_measurement"]) |> map(fn: (r) => ({ r with _value: r._value / 100.0 })) |> sum(column: "_value") suffix: ' MWs' width: 4 yPos: 1 - colors: - hex: '#32B08C' name: viridian type: min - hex: '#BF3D5E' name: ruby type: max value: 200 decimalPlaces: 2 height: 3 kind: Gauge name: "\U0001F50C Today Highest Usage" queries: - query: |- from(bucket: "node8") |> range(start: -1d, stop: now()) |> filter(fn: (r) => r["_measurement"] == "modbus") |> filter(fn: (r) => r["_field"] == "Airport" or r["_field"] == "Central/Wahiawa" or r["_field"] == "Downtown" or r["_field"] == "Ewa" or r["_field"] == "Kahuku" or r["_field"] == "Kailua" or r["_field"] == "Kalihi" or r["_field"] == "University/Manoa") |> aggregateWindow(every: v.windowPeriod, fn: max) |> group(columns: ["holding_register"]) |> max() suffix: ' MW' width: 4 yPos: 2 - colors: - hex: '#00C9FF' name: laser type: min - hex: '#32B08C' name: viridian type: max value: 200 decimalPlaces: 2 height: 3 kind: Gauge name: "\U0001F50C Yesterday Lowest Usage" queries: - query: |- from(bucket: "node8") |> range(start: -1d, stop: -3h) |> filter(fn: (r) => r["_measurement"] == "modbus") |> filter(fn: (r) => r["_field"] == "Airport" or r["_field"] == "Central/Wahiawa" or r["_field"] == "Downtown" or r["_field"] == "Ewa" or r["_field"] == "Kahuku" or r["_field"] == "Kailua" or r["_field"] == "Kalihi" or r["_field"] == "University/Manoa") |> aggregateWindow(every: v.windowPeriod, fn: min) |> group(columns: ["holding_register"]) |> unique() |> min() suffix: ' MW' width: 4 yPos: 5 - height: 2 kind: Markdown name: Name this Cell note: |- # ♻️ Energy Production **tip**: use the `v.energy_types` dashboard variable to control the cells below width: 12 yPos: 8 - colors: - hex: '#32B08C' name: viridian type: min - hex: '#7CE490' name: honeydew type: max value: 1000 decimalPlaces: 2 height: 4 kind: Gauge name: ♻️ Production avg. past 1d queries: - query: |- from(bucket: "node8") |> range(start: -1d, stop: now()) |> filter(fn: (r) => r["_measurement"] == "modbus") |> filter(fn: (r) => r["_field"] == v.energy_types) |> aggregateWindow(every: v.windowPeriod, fn: mean) width: 4 yPos: 10 - colors: - hex: '#32B08C' name: viridian type: text decimalPlaces: 0 height: 2 kind: Single_Stat name: ♻️ CLEAN ENERGY queries: - query: |- sum_result = from(bucket: "node8") |> range(start: -30m, stop: now()) |> filter(fn: (r) => r["_measurement"] == "modbus") |> filter(fn: (r) => r["_field"] == "WindFarm" or r["_field"] == "Waste2Energy" or r["_field"] == "Solar" or r["_field"] == "BioFuel") |> fill(value: 0.0) |> sum(column: "_value") |> group(columns: ["_measurement"]) |> map(fn: (r) => ({ r with _value: r._value / 100.0 })) |> sum(column: "_value") |> yield(name: "sum") suffix: ' MWs' width: 6 yPos: 14 - height: 2 kind: Markdown name: Name this Cell note: |- # Single Area Information **tip**: use the `v.area_names` dashboard variable to control the cells below width: 12 yPos: 16 - axes: - base: "10" name: x scale: linear - base: "10" label: MW name: y scale: linear colors: - hex: '#00A3FF' name: Solid Blue type: scale - hex: '#00A3FF' name: Solid Blue type: scale - hex: '#00A3FF' name: Solid Blue type: scale geom: line height: 4 kind: Xy name: "\U0001F50C Usage by `area_names` last two days" position: overlaid queries: - query: |- from(bucket: "node8") |> range(start: -2d, stop: now()) |> filter(fn: (r) => r["_measurement"] == "modbus") |> filter(fn: (r) => r["_field"] == v.area_names) |> aggregateWindow(every: v.windowPeriod, fn: max) |> yield(name: "mean") shade: true width: 12 xCol: _time yCol: _value yPos: 18 - colors: - hex: '#F48D38' name: tiger type: text decimalPlaces: 2 height: 1 kind: Single_Stat name: "\U0001F50C \U0001F4C8 Today highest usage" queries: - query: |- from(bucket: "node8") |> range(start: -1d, stop: now()) |> filter(fn: (r) => r["_measurement"] == "modbus") |> filter(fn: (r) => r["_field"] == v.area_names) |> aggregateWindow(every: v.windowPeriod, fn: max) |> unique() |> max() |> group(columns: ["holding_register"]) |> sort(desc: true) |> yield(name: "max") suffix: ' MW' width: 2 yPos: 22 - colors: - hex: '#00C9FF' name: laser type: text decimalPlaces: 2 height: 1 kind: Single_Stat name: "\U0001F50C Today lowest MW usage" queries: - query: |- from(bucket: "node8") |> range(start: -1d, stop: now()) |> filter(fn: (r) => r["_measurement"] == "modbus") |> filter(fn: (r) => r["_field"] == v.area_names) |> aggregateWindow(every: v.windowPeriod, fn: min) |> unique() |> min() |> group(columns: ["holding_register"]) |> sort(desc: true) |> yield(name: "min") suffix: ' MW' width: 2 yPos: 23 - colors: - hex: '#FFB94A' name: pineapple type: text decimalPlaces: 2 height: 1 kind: Single_Stat name: "\U0001F50C \U0001F4C8-1d highest usage" queries: - query: |- from(bucket: "node8") |> range(start: -2d, stop: -1d) |> filter(fn: (r) => r["_measurement"] == "modbus") |> filter(fn: (r) => r["_field"] == v.area_names) |> aggregateWindow(every: v.windowPeriod, fn: max) |> unique() |> max() |> group(columns: ["holding_register"]) |> sort(desc: true) |> yield(name: "max") suffix: ' MW' width: 2 xPos: 2 yPos: 22 - colors: - hex: '#00C9FF' name: laser type: text decimalPlaces: 2 height: 1 kind: Single_Stat name: "\U0001F50C -1d lowest MW usage" note: No data for yesterday noteOnEmpty: true queries: - query: |- from(bucket: "node8") |> range(start: -2d, stop: -1d) |> filter(fn: (r) => r["_measurement"] == "modbus") |> filter(fn: (r) => r["_field"] == v.area_names) |> aggregateWindow(every: v.windowPeriod, fn: min) |> unique() |> min() |> group(columns: ["holding_register"]) |> sort(desc: true) |> yield(name: "min") suffix: ' MW' width: 2 xPos: 2 yPos: 23 - axes: - base: "10" name: x scale: linear - base: "10" label: MW name: y scale: linear colors: - hex: '#31C0F6' name: Nineteen Eighty Four type: scale - hex: '#A500A5' name: Nineteen Eighty Four type: scale - hex: '#FF7E27' name: Nineteen Eighty Four type: scale geom: line height: 4 kind: Xy name: ♻️ Energy creation by energy_type position: overlaid queries: - query: |- from(bucket: "node8") |> range(start: v.timeRangeStart, stop: v.timeRangeStop) |> filter(fn: (r) => r["_measurement"] == "modbus") |> filter(fn: (r) => r["_field"] == "BioFuel" or r["_field"] == "Coal" or r["_field"] == "Fossil_Fuel" or r["_field"] == "Solar" or r["_field"] == "Waste2Energy" or r["_field"] == "WindFarm") |> aggregateWindow(every: v.windowPeriod, fn: max) |> yield(name: "max") shade: true width: 8 xCol: _time xPos: 4 yCol: _value - colors: - hex: '#ffffff' name: white type: text fieldOptions: - displayName: _start fieldName: _start visible: true - displayName: _stop fieldName: _stop visible: true - displayName: _time fieldName: _time visible: true - displayName: _value fieldName: _value visible: true - displayName: _field fieldName: _field visible: true - displayName: _measurement fieldName: _measurement visible: true - displayName: host fieldName: host visible: true - displayName: name fieldName: name visible: true - displayName: type fieldName: type visible: true height: 4 kind: Table name: ♻️ Consolidated Prouction queries: - query: |- from(bucket: "node8") |> range(start: v.timeRangeStart, stop: v.timeRangeStop) |> filter(fn: (r) => r["_measurement"] == "modbus") |> filter(fn: (r) => r["_field"] == "BioFuel" or r["_field"] == "Coal" or r["_field"] == "Fossil_Fuel" or r["_field"] == "Solar" or r["_field"] == "Waste2Energy" or r["_field"] == "WindFarm") |> group(columns: ["_field"]) |> unique() |> drop(columns: ["_start", "_stop", "_measurement", "host", "name", "type"]) tableOptions: verticalTimeAxis: true timeFormat: hh:mm a width: 4 xPos: 4 yPos: 4 - axes: - base: "10" name: x scale: linear - base: "10" label: MW name: y scale: linear colors: - hex: '#00A3FF' name: Solid Blue type: scale - hex: '#00A3FF' name: Solid Blue type: scale - hex: '#00A3FF' name: Solid Blue type: scale geom: line height: 4 kind: Xy name: ♻️ Energy Production past 1d position: overlaid queries: - query: |- from(bucket: "node8") |> range(start: -1d, stop: now()) |> filter(fn: (r) => r["_measurement"] == "modbus") |> filter(fn: (r) => r["_field"] == v.energy_types) |> aggregateWindow(every: v.windowPeriod, fn: max) |> yield(name: "mean") shade: true width: 8 xCol: _time xPos: 4 yCol: _value yPos: 10 - colors: - hex: '#FFB94A' name: pineapple type: text decimalPlaces: 2 height: 1 kind: Single_Stat name: "\U0001F50C \U0001F4C8 -2d highest usage" queries: - query: |- from(bucket: "node8") |> range(start: -3d, stop: -2d) |> filter(fn: (r) => r["_measurement"] == "modbus") |> filter(fn: (r) => r["_field"] == v.area_names) |> aggregateWindow(every: v.windowPeriod, fn: max) |> unique() |> max() |> group(columns: ["holding_register"]) |> sort(desc: true) |> yield(name: "max") suffix: ' MW' width: 2 xPos: 4 yPos: 22 - colors: - hex: '#00C9FF' name: laser type: text decimalPlaces: 2 height: 1 kind: Single_Stat name: "\U0001F50C -2d lowest usage" queries: - query: |- from(bucket: "node8") |> range(start: -3d, stop: -2d) |> filter(fn: (r) => r["_measurement"] == "modbus") |> filter(fn: (r) => r["_field"] == v.area_names) |> aggregateWindow(every: v.windowPeriod, fn: min) |> unique() |> min() |> group(columns: ["holding_register"]) |> sort(desc: true) |> yield(name: "min") suffix: ' MW' width: 2 xPos: 4 yPos: 23 - colors: - hex: '#513CC6' name: planet type: text decimalPlaces: 0 height: 2 kind: Single_Stat name: ♻️ Total System Generation queries: - query: |- sum_result = from(bucket: "node8") |> range(start: -30m, stop: now()) |> filter(fn: (r) => r["_measurement"] == "modbus") |> filter(fn: (r) => r["_field"] == "Total_System_Generation") |> fill(value: 0.0) |> sum(column: "_value") |> group(columns: ["_measurement"]) |> sum(column: "_value") |> map(fn: (r) => ({ r with _value: r._value / 100.0 })) |> yield(name: "sum") suffix: ' MWs' width: 6 xPos: 6 yPos: 14 - colors: - hex: '#7CE490' name: honeydew type: text decimalPlaces: 2 height: 1 kind: Single_Stat name: "\U0001F50C \U0001F4C8 -3d highest usage" queries: - query: |- from(bucket: "node8") |> range(start: -4d, stop: -3d) |> filter(fn: (r) => r["_measurement"] == "modbus") |> filter(fn: (r) => r["_field"] == v.area_names) |> aggregateWindow(every: v.windowPeriod, fn: max) |> unique() |> max() |> group(columns: ["holding_register"]) |> sort(desc: true) |> yield(name: "max") suffix: ' MW' width: 2 xPos: 6 yPos: 22 - colors: - hex: '#00C9FF' name: laser type: text decimalPlaces: 2 height: 1 kind: Single_Stat name: "\U0001F50C -3d lowest usage" queries: - query: |- from(bucket: "node8") |> range(start: -4d, stop: -3d) |> filter(fn: (r) => r["_measurement"] == "modbus") |> filter(fn: (r) => r["_field"] == v.area_names) |> aggregateWindow(every: v.windowPeriod, fn: min) |> unique() |> min() |> group(columns: ["holding_register"]) |> sort(desc: true) |> yield(name: "min") suffix: ' MW' width: 2 xPos: 6 yPos: 23 - colors: - hex: '#ffffff' name: white type: text fieldOptions: - displayName: _start fieldName: _start visible: true - displayName: _stop fieldName: _stop visible: true - displayName: _time fieldName: _time visible: true - displayName: _value fieldName: _value visible: true - displayName: _field fieldName: _field visible: true - displayName: _measurement fieldName: _measurement visible: true - displayName: host fieldName: host visible: true - displayName: name fieldName: name visible: true - displayName: type fieldName: type visible: true height: 4 kind: Table name: "\U0001F50C Consolidated Usage" queries: - query: |- from(bucket: "node8") |> range(start: v.timeRangeStart, stop: v.timeRangeStop) |> filter(fn: (r) => r["_measurement"] == "modbus") |> filter(fn: (r) => r["_field"] == "Airport" or r["_field"] == "Central/Wahiawa" or r["_field"] == "Downtown" or r["_field"] == "Ewa" or r["_field"] == "Kahuku" or r["_field"] == "Kailua" or r["_field"] == "Kalihi" or r["_field"] == "University/Manoa") |> group(columns: ["_field"]) |> unique() |> drop(columns: ["_start", "_stop", "_measurement", "host", "name", "type"]) tableOptions: verticalTimeAxis: true timeFormat: hh:mm a width: 4 xPos: 8 yPos: 4 - colors: - hex: '#FFB94A' name: pineapple type: text decimalPlaces: 2 height: 1 kind: Single_Stat name: "\U0001F50C \U0001F4C8 -4d highest usage" queries: - query: |- from(bucket: "node8") |> range(start: -5d, stop: -4d) |> filter(fn: (r) => r["_measurement"] == "modbus") |> filter(fn: (r) => r["_field"] == v.area_names) |> aggregateWindow(every: v.windowPeriod, fn: max) |> unique() |> max() |> group(columns: ["holding_register"]) |> sort(desc: true) |> yield(name: "max") suffix: ' MW' width: 2 xPos: 8 yPos: 22 - colors: - hex: '#00C9FF' name: laser type: text decimalPlaces: 2 height: 1 kind: Single_Stat name: "\U0001F50C -4d lowest usage" queries: - query: |- from(bucket: "node8") |> range(start: -5d, stop: -4d) |> filter(fn: (r) => r["_measurement"] == "modbus") |> filter(fn: (r) => r["_field"] == v.area_names) |> aggregateWindow(every: v.windowPeriod, fn: min) |> unique() |> min() |> group(columns: ["holding_register"]) |> sort(desc: true) |> yield(name: "min") suffix: ' MW' width: 2 xPos: 8 yPos: 23 - colors: - hex: '#4591ED' name: ocean type: text decimalPlaces: 2 height: 1 kind: Single_Stat name: "\U0001F50C \U0001F4C8 -5d highest usage" queries: - query: |- from(bucket: "node8") |> range(start: -6d, stop: -5d) |> filter(fn: (r) => r["_measurement"] == "modbus") |> filter(fn: (r) => r["_field"] == v.area_names) |> aggregateWindow(every: v.windowPeriod, fn: max) |> unique() |> max() |> group(columns: ["holding_register"]) |> sort(desc: true) |> yield(name: "max") suffix: ' MW' width: 2 xPos: 10 yPos: 22 - colors: - hex: '#00C9FF' name: laser type: text decimalPlaces: 2 height: 1 kind: Single_Stat name: "\U0001F50C -5d lowest usage" queries: - query: |- from(bucket: "node8") |> range(start: -6d, stop: -5d) |> filter(fn: (r) => r["_measurement"] == "modbus") |> filter(fn: (r) => r["_field"] == v.area_names) |> aggregateWindow(every: v.windowPeriod, fn: min) |> unique() |> min() |> group(columns: ["holding_register"]) |> sort(desc: true) |> yield(name: "min") suffix: ' MW' width: 2 xPos: 10 yPos: 23 description: Oahu energy usage and generation name: Island Pulse --- apiVersion: influxdata.com/v2alpha1 kind: Telegraf metadata: name: wiggitty-huh-127002 spec: associations: - kind: Label name: agitated-driscoll-46e001 config: | # Telegraf Configuration # # Telegraf is entirely plugin driven. All metrics are gathered from the # declared inputs, and sent to the declared outputs. # # Plugins must be declared in here to be active. # To deactivate a plugin, comment out the name and any variables. # # Use 'telegraf -config telegraf.conf -test' to see what metrics a config # file would generate. # # Environment variables can be used anywhere in this config file, simply surround # them with ${}. For strings the variable must be within quotes (ie, "${STR_VAR}"), # for numbers and booleans they should be plain (ie, ${INT_VAR}, ${BOOL_VAR}) # Global tags can be specified here in key="value" format. [global_tags] # dc = "us-east-1" # will tag all metrics with dc=us-east-1 # rack = "1a" ## Environment variables can be used as tags, and throughout the config file # user = "$USER" # Configuration for telegraf agent [agent] ## Default data collection interval for all inputs interval = "10s" ## Rounds collection interval to 'interval' ## ie, if interval="10s" then always collect on :00, :10, :20, etc. round_interval = true ## Telegraf will send metrics to outputs in batches of at most ## metric_batch_size metrics. ## This controls the size of writes that Telegraf sends to output plugins. metric_batch_size = 100000 ## Maximum number of unwritten metrics per output. Increasing this value ## allows for longer periods of output downtime without dropping metrics at the ## cost of higher maximum memory usage. metric_buffer_limit = 100000 ## Collection jitter is used to jitter the collection by a random amount. ## Each plugin will sleep for a random time within jitter before collecting. ## This can be used to avoid many plugins querying things like sysfs at the ## same time, which can have a measurable effect on the system. collection_jitter = "0s" ## Default flushing interval for all outputs. Maximum flush_interval will be ## flush_interval + flush_jitter flush_interval = "10s" ## Jitter the flush interval by a random amount. This is primarily to avoid ## large write spikes for users running a large number of telegraf instances. ## ie, a jitter of 5s and interval 10s means flushes will happen every 10-15s flush_jitter = "4s" ## By default or when set to "0s", precision will be set to the same ## timestamp order as the collection interval, with the maximum being 1s. ## ie, when interval = "10s", precision will be "1s" ## when interval = "250ms", precision will be "1ms" ## Precision will NOT be used for service inputs. It is up to each individual ## service input to set the timestamp at the appropriate precision. ## Valid time units are "ns", "us" (or "µs"), "ms", "s". precision = "s" ## Log at debug level. # debug = true ## Log only error level messages. # quiet = false ## Log target controls the destination for logs and can be one of "file", ## "stderr" or, on Windows, "eventlog". When set to "file", the output file ## is determined by the "logfile" setting. # logtarget = "file" ## Name of the file to be logged to when using the "file" logtarget. If set to ## the empty string then logs are written to stderr. # logfile = "" ## The logfile will be rotated after the time interval specified. When set ## to 0 no time based rotation is performed. Logs are rotated only when ## written to, if there is no log activity rotation may be delayed. # logfile_rotation_interval = "0d" ## The logfile will be rotated when it becomes larger than the specified ## size. When set to 0 no size based rotation is performed. # logfile_rotation_max_size = "0MB" ## Maximum number of rotated archives to keep, any older logs are deleted. ## If set to -1, no archives are removed. # logfile_rotation_max_archives = 5 ## Override default hostname, if empty use os.Hostname() hostname = "" ## If set to true, do no set the "host" tag in the telegraf agent. omit_hostname = false ############################################################################### # OUTPUT PLUGINS # ############################################################################### # Configuration for sending metrics to InfluxDB [[outputs.influxdb_v2]] ## The full HTTP or UDP URL for your InfluxDB instance. ## ## Multiple URLs can be specified for a single cluster, only ONE of the ## urls will be written to each interval. # urls = ["unix:///var/run/influxdb.sock"] # urls = ["udp://127.0.0.1:8089"] # urls = ["http://127.0.0.1:8086"] urls = ["$INFLUX_HOST"] ## Token for authentication. token = "$INFLUX_TOKEN" ## Organization is the name of the organization you wish to write to; must exist. organization = "$INFLUX_ORG" bucket="node8" ## Timeout for HTTP messages. timeout = "5s" ############################################################################### # INPUT PLUGINS # ############################################################################### [[inputs.modbus]] ## Connection Configuration ## ## The module supports connections to PLCs via MODBUS/TCP or ## via serial line communication in binary (RTU) or readable (ASCII) encoding ## ## Device name name = "Device" ## Slave ID - addresses a MODBUS device on the bus ## Range: 0 - 255 [0 = broadcast; 248 - 255 = reserved] slave_id = 1 ## Timeout for each request timeout = "1m" ## Maximum number of retries and the time to wait between retries ## when a slave-device is busy. # busy_retries = 10 # busy_retries_wait = "100ms" # TCP - connect via Modbus/TCP controller = "tcp://0.0.0.0:8502" ## Serial (RS485; RS232) # controller = "file:///dev/ttyUSB0" # baud_rate = 9600 # data_bits = 8 # parity = "N" # stop_bits = 1 # transmission_mode = "RTU" ## Measurements ## ## Digital Variables, Discrete Inputs and Coils ## name - the variable name ## address - variable address # discrete_inputs = [ # { name = "Start", address = [0]}, # { name = "Stop", address = [1]}, # { name = "Reset", address = [2]}, # { name = "EmergencyStop", address = [3]}, # ] # coils = [ # { name = "Motor1-Run", address = [0]}, # { name = "Motor1-Jog", address = [1]}, # { name = "Motor1-Stop", address = [2]}, # ] ## Analog Variables, Input Registers and Holding Registers ## measurement - the (optional) measurement name, defaults to "modbus" ## name - the variable name ## byte_order - the ordering of bytes ## |---AB, ABCD - Big Endian ## |---BA, DCBA - Little Endian ## |---BADC - Mid-Big Endian ## |---CDAB - Mid-Little Endian ## data_type - INT16, UINT16, INT32, UINT32, INT64, UINT64, FLOAT32, FLOAT32-IEEE (the IEEE 754 binary representation) ## scale - the final numeric variable representation ## address - variable address holding_registers = [ { name = "Airport", byte_order = "AB", data_type = "FLOAT32", scale=0.1, address = [0]}, { name = "Central/Wahiawa", byte_order = "AB", data_type = "FLOAT32", scale=0.1, address = [1]}, { name = "Downtown", byte_order = "AB", data_type = "FLOAT32", scale=0.1, address = [2]}, { name = "Ewa", byte_order = "AB", data_type = "FLOAT32", scale=0.1, address = [3]}, { name = "Kahuku", byte_order = "AB", data_type = "FLOAT32", scale=0.1, address = [4]}, { name = "Kailua", byte_order = "AB", data_type = "FLOAT32", scale=0.1, address = [5]}, { name = "Kalihi", byte_order = "AB", data_type = "FLOAT32", scale=0.1, address = [6]}, { name = "Total_System_Generation", byte_order = "AB", data_type = "FLOAT32", scale=0.1, address = [7]}, { name = "University/Manoa", byte_order = "AB", data_type = "FLOAT32", scale=0.1, address = [8]}, { name = "BioFuel", byte_order = "AB", data_type = "FLOAT32", scale=0.1, address = [9]}, { name = "Coal", byte_order = "AB", data_type = "FLOAT32", scale=0.1, address = [10]}, { name = "Fossil_Fuel", byte_order = "AB", data_type = "FLOAT32", scale=0.1, address = [11]}, { name = "Solar", byte_order = "AB", data_type = "FLOAT32", scale=0.1, address = [12]}, { name = "Waste2Energy", byte_order = "AB", data_type = "FLOAT32", scale=0.1, address = [13]}, { name = "WindFarm", byte_order = "AB", data_type = "FLOAT32", scale=0.1, address = [14]}, ] name: Modbus Monitor