InfluxDB sum of all values

jjm · November 15, 2024, 4:45pm

Hi, I’ve got this influxDB query

from(bucket: "bucket1")
  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
  |> filter(fn: (r) => r["_measurement"] == "Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes")
  |> filter(fn: (r) => r["_field"] == "system_power_input")
  |> group(columns: ["source"])
  |> aggregateWindow(every: v.windowPeriod, fn: sum, createEmpty: false)
  |> yield(name: "sum")

And it works as expected, showing two devices, and apparently one is using 321W of power and the other 320W.

My goal is to put them together and output just one value that’s sum of all the values that were found. So I’d expect to get another graph with single line at 641W.

To achieve this, instead of grouping by source, I tried grouping by time.

from(bucket: "bucket1")
  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
  |> filter(fn: (r) => r["_measurement"] == "Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes")
  |> filter(fn: (r) => r["_field"] == "system_power_input")
  |> group(columns: ["_time"])
  |> aggregateWindow(every: v.windowPeriod, fn: sum, createEmpty: false)
  |> yield(name: "sum")

Instead of a single line at 641, I got this.

If I try grouping by anything else, like for example “_measurement” I get something like this.

Here’s the query:

from(bucket: "bucket1")
  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
  |> filter(fn: (r) => r["_measurement"] == "Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes")
  |> filter(fn: (r) => r["_field"] == "system_power_input")
  |> group(columns: ["_measurement"])
  |> aggregateWindow(every: v.windowPeriod, fn: sum, createEmpty: false)
  |> yield(name: "sum")

I’ve searched around and tried many different ways to create the sum, including data transformation in grafana itself, but usually got similar results to this, which makes me think that maybe there isn’t a problem with the query but with the data itself?
But how would I even investigate that, what could cause something like this? Is the data for certain times simply missing for one of the devices? And if so, would there be a way to compensate for it?

Or is there something obvious I’m missing and the graphs are behaving as they should?

Thanks for any help

grant2 · November 19, 2024, 2:58am

Hi @jjm

If I understand correctly, you have two devices (aka “sources”?): one device generates 321 and the other generates 320 via this query:

from(bucket: "bucket1")
  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
  |> filter(fn: (r) => r["_measurement"] == "Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes")
  |> filter(fn: (r) => r["_field"] == "system_power_input")
  |> group(columns: ["source"])
  |> aggregateWindow(every: v.windowPeriod, fn: sum, createEmpty: false)
  |> yield(name: "sum")

What happens if you replace the aggregateWindow statement with

|> sum()

? Can you toggle to view the data in a table and paste back what you see?

jjm · November 19, 2024, 6:30pm

What happens if you replace the aggregateWindow statement with
|> sum()

Each device has multiple values, each corresponding to a specific time.
It seems that this adds them all up into one. So the result is only one value for each device that seems to be the sum of all their values.

The raw CSV is way too big to include here.
But to give an example of what I’m working with I ran this:

from(bucket: "bucket1")
  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
  |> filter(fn: (r) => r["_measurement"] == "Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes")
  |> filter(fn: (r) => r["_field"] == "system_power_input")
  |> yield(name: "sum")

and here’s the csv output of the query, but I renamed the sources to remove identifiable information and I could only include the first two sources. Otherwise I wouldn’t be able to fit in in the character limit.
In the initial examples I simply filtered out two random sources, but left that out of the query since I didn’t want to reveal the names.

#group,false,false,true,true,false,false,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true
#datatype,string,long,dateTime:RFC3339,dateTime:RFC3339,dateTime:RFC3339,long,string,string,string,string,string,string,string,string,string,string,string,string,string,string,string
#default,sum,,,,,,,,,,,,,,,,,,,,
,result,table,_start,_stop,_time,_value,_field,_measurement,cc,confgd_power_redundancy_mode/value,country,device_type,host,location,path,pem,pem_id/value,rack,region,source,subscription
,,0,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T15:34:53.33Z,163,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source1,green
,,0,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T15:35:53.33Z,164,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source1,green
,,0,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T15:36:53.334Z,163,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source1,green
,,0,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T15:37:53.338Z,163,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source1,green
,,0,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T15:38:53.334Z,163,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source1,green
,,0,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T15:39:53.334Z,163,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source1,green
,,0,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T15:40:53.334Z,163,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source1,green
,,0,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T15:41:53.334Z,163,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source1,green
,,0,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T15:42:53.33Z,163,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source1,green
,,0,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T15:43:53.33Z,163,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source1,green
,,0,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T15:44:53.331Z,163,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source1,green
,,0,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T15:45:53.33Z,164,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source1,green
,,0,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T15:46:53.331Z,163,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source1,green
,,0,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T15:47:53.331Z,163,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source1,green
,,0,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T15:48:53.331Z,163,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source1,green
,,0,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T15:49:53.331Z,163,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source1,green
,,0,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T15:50:53.331Z,163,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source1,green
,,0,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T15:51:53.332Z,163,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source1,green
,,0,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T15:52:53.331Z,163,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source1,green
,,0,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T15:53:53.331Z,163,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source1,green
,,0,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T15:54:53.332Z,163,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source1,green
,,0,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T15:55:53.333Z,163,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source1,green
,,0,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T15:56:53.331Z,163,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source1,green
,,0,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T15:57:53.332Z,163,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source1,green
,,0,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T15:58:53.332Z,163,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source1,green
,,0,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T15:59:53.331Z,163,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source1,green
,,0,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T16:00:53.332Z,163,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source1,green
,,0,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T16:01:53.332Z,163,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source1,green
,,0,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T16:02:53.332Z,163,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source1,green
,,0,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T16:03:53.336Z,163,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source1,green
,,0,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T16:04:53.333Z,163,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source1,green
,,0,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T16:05:53.332Z,163,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source1,green
,,0,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T16:06:53.334Z,163,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source1,green
,,0,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T16:07:53.333Z,163,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source1,green
,,0,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T16:08:53.334Z,163,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source1,green
,,0,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T16:09:53.335Z,163,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source1,green
,,0,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T16:10:53.333Z,163,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source1,green
,,0,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T16:11:53.333Z,163,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source1,green
,,0,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T16:12:53.334Z,163,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source1,green
,,0,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T16:13:53.333Z,163,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source1,green
,,0,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T16:14:53.334Z,163,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source1,green
,,0,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T16:15:53.336Z,163,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source1,green
,,0,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T16:16:53.333Z,163,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source1,green
,,0,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T16:17:53.334Z,163,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source1,green
,,0,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T16:18:53.334Z,163,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source1,green
,,0,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T16:19:53.334Z,163,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source1,green
,,0,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T16:20:53.334Z,163,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source1,green
,,0,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T16:21:53.334Z,163,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source1,green
,,0,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T16:22:53.335Z,163,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source1,green
,,0,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T16:23:53.334Z,163,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source1,green
,,0,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T16:24:53.334Z,163,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source1,green
,,0,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T16:25:53.335Z,163,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source1,green
,,0,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T16:26:53.335Z,163,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source1,green
,,0,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T16:27:53.334Z,163,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source1,green
,,0,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T16:28:53.335Z,163,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source1,green
,,0,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T16:29:53.335Z,163,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source1,green
,,0,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T16:30:53.336Z,163,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source1,green
,,0,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T16:31:53.335Z,163,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source1,green
,,0,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T16:32:53.336Z,163,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source1,green
,,0,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T16:33:53.336Z,163,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source1,green
,,1,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T15:34:50.732Z,140,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source2,green
,,1,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T15:35:50.732Z,140,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source2,green
,,1,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T15:36:50.732Z,140,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source2,green
,,1,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T15:37:50.733Z,140,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source2,green
,,1,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T15:38:50.733Z,140,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source2,green
,,1,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T15:39:50.732Z,140,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source2,green
,,1,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T15:40:50.733Z,140,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source2,green
,,1,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T15:41:50.733Z,140,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source2,green
,,1,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T15:42:50.733Z,140,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source2,green
,,1,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T15:43:50.735Z,140,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source2,green
,,1,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T15:44:50.734Z,140,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source2,green
,,1,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T15:45:50.733Z,140,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source2,green
,,1,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T15:46:50.733Z,140,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source2,green
,,1,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T15:47:50.734Z,140,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source2,green
,,1,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T15:48:50.734Z,140,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source2,green
,,1,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T15:49:50.735Z,140,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source2,green
,,1,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T15:50:50.734Z,140,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source2,green
,,1,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T15:51:50.734Z,140,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source2,green
,,1,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T15:52:50.734Z,140,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source2,green
,,1,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T15:53:50.734Z,140,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source2,green
,,1,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T15:54:50.734Z,140,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source2,green
,,1,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T15:55:50.735Z,140,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source2,green
,,1,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T15:56:50.735Z,140,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source2,green
,,1,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T15:57:50.735Z,140,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source2,green
,,1,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T15:58:50.735Z,140,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source2,green
,,1,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T15:59:50.734Z,140,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source2,green
,,1,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T16:00:50.735Z,140,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source2,green
,,1,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T16:01:50.735Z,140,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source2,green
,,1,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T16:02:50.74Z,140,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source2,green
,,1,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T16:03:50.735Z,140,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source2,green
,,1,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T16:04:50.736Z,140,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source2,green
,,1,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T16:05:50.735Z,140,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source2,green
,,1,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T16:06:50.736Z,140,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source2,green
,,1,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T16:07:50.736Z,140,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source2,green
,,1,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T16:08:50.736Z,140,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source2,green
,,1,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T16:09:50.738Z,140,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source2,green
,,1,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T16:10:50.736Z,140,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source2,green
,,1,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T16:11:50.736Z,140,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source2,green
,,1,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T16:12:50.736Z,140,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source2,green
,,1,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T16:13:50.737Z,140,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source2,green
,,1,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T16:14:50.737Z,140,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source2,green
,,1,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T16:15:50.737Z,140,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source2,green
,,1,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T16:16:50.737Z,140,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source2,green
,,1,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T16:17:50.736Z,140,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source2,green
,,1,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T16:18:50.736Z,140,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source2,green
,,1,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T16:19:50.737Z,140,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source2,green
,,1,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T16:20:50.737Z,140,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source2,green
,,1,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T16:21:50.737Z,140,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source2,green
,,1,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T16:22:50.737Z,140,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source2,green
,,1,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T16:23:50.739Z,140,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source2,green
,,1,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T16:24:50.737Z,140,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source2,green
,,1,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T16:25:50.737Z,140,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source2,green
,,1,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T16:26:50.737Z,140,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source2,green
,,1,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T16:27:50.738Z,140,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source2,green
,,1,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T16:28:50.737Z,140,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source2,green
,,1,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T16:29:50.738Z,140,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source2,green
,,1,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T16:30:50.738Z,140,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source2,green
,,1,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T16:31:50.738Z,140,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source2,green
,,1,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T16:32:50.739Z,140,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source2,green
,,1,2024-11-19T15:33:54.01461922Z,2024-11-19T16:33:54.01461922Z,2024-11-19T16:33:50.741Z,140,system_power_input,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,NA,(Group 0 + Group 1),NA,NA,telegraf,0,Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes,0,0,NA,NA,source2,green

Interestingly enough if I pair certain devices only, it seems to sort of work. With others it’s jumping all over the place. So I’m begining to think that the the problem is with the data. Maybe I simply do not have the values for the same times for each device, so when there are gaps, it only displays the values that it can find, and that’s why the graphs are jumping up and down.

I wonder if there’s an easy way to confirm the theory. And if I’m right, if there’s a way to solve it.

ebabeshko · November 19, 2024, 7:10pm

Try Add field from calculation transformation and see if it suits for your case:

jjm · November 20, 2024, 9:42am

Try Add field from calculation transformation and see if it suits for your case:

Thanks, I’ve tried that too, but I still get the jumps in values.

Since this seems to be the case of missing values, I tried to play a bit around with the window period.

 |> aggregateWindow(every: v.windowPeriod, fn: sum, createEmpty: false)

by default it’s 15s, I tried setting to 1m.

 |> aggregateWindow(every: 1m, fn: sum, createEmpty: false)

And surprisingly, I got more or less correct value, although the changes in time, small as they are, pretty much disappear all together. And the graph seems to be oscillating between two very close values about every minute, with sharp drops at the start of the graph and at the end.

Here’s the full query:

from(bucket: "bucket1")
  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
  |> filter(fn: (r) => r["_measurement"] == "Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes")
  |> filter(fn: (r) => r["_field"] == "system_power_input")
  |> group(columns: ["_measurement"])
  |> aggregateWindow(every: 1m, fn: sum, createEmpty: false)
  |> yield(name: "mean")

I had to group by measurement, because grouping by time produces the strange slopes instead of a graph, same as before changing the window period.

But I still feel that this is not working reliably, because if it were, increasing the window period further shouldn’t produce drastically different results, but it does. If I set the window period as 2m, I pretty much double the resulting values, if I set it to 3m, it’s about triple the real value. I’m really not sure what’s going on there, but I would expect that increasing the window period would simply smooth out any changes over time, not multiply the results.

grant2 · November 20, 2024, 12:29pm

Can you inspect your raw (unaggregated) data in Influx Data Explorer (dump into CSV or whatever is easiest) to definitely determine if you do indeed have values for the same times for each device?

If there are gaps (missing values at certain times), do you have the ability to alter your ingest method so that there are always values present (ideally with the same timestamp)?

jjm · November 20, 2024, 3:49pm

I already did include the csv, in my previous response, but had to limit it to two sources due to the character limit.
To get around it, I uploaded the file to my personal server.

Here’s the link: https://files.phalkon.eu/influx.csv

The query is still the same, as when I shared the csv output before, no aggregation.
Here’s the query I used:

from(bucket: "bucket1")
  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
  |> filter(fn: (r) => r["_measurement"] == "Cisco-IOS-XR-sysadmin-fretta-envmon-ui:environment/oper/power/location/pem_attributes")
  |> filter(fn: (r) => r["_field"] == "system_power_input")
  |> yield(name: "power")

grant2 · November 21, 2024, 3:58am

Because you had questioned your data several times, I was just asking if you could inspect your data to prove or disprove this.

jjm · November 21, 2024, 10:46am

I’m not sure how to disprove that I’m right about the cause of the issue.

I know that the “_time” values are not same for each device.
The default time period of an influx query seems to be 1h, and the query pulls 60 values from each device, but the “_time” field values differ between all the sources. They don’t all have the same 60 “_time” values.

My theory is that this could be the cause of the problems I’m having. But I admit my knowledge of Influx is quite limited, so this is just my best guess.

To give a bit more detail about my set up, I have Cisco devices configured to stream telemetry to telegraf and telegraf then sends it to influx.
I’m using this: GitHub - cisco-open/green-monitoring: Tracks an open-source stack of services that monitor the energy and CO2-eq emissions of IOS-XR, NX-OS devices, Meraki switches, UCSs, ACI APIC nodes, Eaton and Raritan PDUs.
There are more details about the setup on that github page, if interested.

jjm · November 21, 2024, 1:13pm

This might also be interesting to inspect.

I took the “_time” values from the original csv re-sorted them based on the source and put them into a new csv file, including the min/max value and the range (which is always 59s, I’m guessing influx puts that limit there by default).

(interestingly, there’s one value missing, it was missing in the original exported csv too, but it’s not the cause of these issues)

As I said, each device will give 60 values spreading over 1h time range.
But the times for the first value are different for each device, and the same is true for second values, third, etc.

https://files.phalkon.eu/times.csv

Topic		Replies	Views
How to sum up the data of a column on InfluxDB Query? InfluxDB	7	11746	January 13, 2022
How to sum some fields and display it in line chart? InfluxDB influxdb , flux , dashboard , query-editor	1	162	May 21, 2024
Sum of values where is the mistake InfluxDB	2	1372	December 3, 2019
How to addion 2 Values? (solved) InfluxDB flux	3	32	October 7, 2024
Sum of values in same table InfluxDB query-help , table-panel	16	8533	May 21, 2022

InfluxDB sum of all values

Related topics