Hello,
I’m trying to filter and count the same results, and showing on graph with time series.In my case, source is telegraf(json url) and destination is influxdb.
My input json file are:
{
“items” : [
{ “ID” : “10.1003”, “host” : “Storage”, “AlarmLevel” : “Major”, “iSerialNo” : 806868, “dtOccurTime” : “1661144989915” },
{ “ID” : “10.1003”, “host” : “Storage”, “AlarmLevel” : “Critical”, “iSerialNo” : 806896, “dtOccurTime” : “1661756400000” },
{ “ID” : “10.1001”, “host” : “VM”, “AlarmLevel” : “Minor”, “iSerialNo” : 806842, “dtOccurTime” : “1661729238683” },
{ “ID” : “10.1002”, “host” : “Network”, “AlarmLevel” : “Major”, “iSerialNo” : 806872, “dtOccurTime” : “1661720934451” },
{ “ID” : “10.1003”, “host” : “Storage”, “AlarmLevel” : “Major”, “iSerialNo” : 806875, “dtOccurTime” : “1661241960000” },
{ “ID” : “10.1003”, “host” : “Network”, “AlarmLevel” : “Major”, “iSerialNo” : 806832, “dtOccurTime” : “1661164998683” }
],
}
I’d like to show on the graph which count of the same data on json where
host== Storage and
AlarmLevel == “Major”
f exmpl: now, count of the data is 2 (Storage:Major).
Please, Help write the code