Hello,
I’m trying to count how many the same data on the json table. Json table send via telegraf(source) and on Influxdb(destination).
For example, my josn table consider this table:
{
“items” : [
{
“ID” : “10.1003”, “host” : “Storage”, “AlarmLevel” : “Major”, “iSerialNo” : 806868,“dtOccurTime” : “1661144989915”,
},
{
“ID” : “10.1003”, “host” : “Storage”, “AlarmLevel” : “Major”, “iSerialNo” : 806896, “dtOccurTime” : “1661756400000”,
},
{
“ID” : “10.1003”, “host” : “Storage”, “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”
}
],
}
I’d like to be able to query this table and count how many all of the data where
host == Storage and AlarmLevel == Major
Can I put on the graph with time(x-axis) and count(y-axis):
now: 3 (Storage:Major)
