Hi,
My Query looks like this
`
from(bucket: "network_usage") |> range(start: -7d)
|> filter(fn: (r) => r["_measurement"] == "network_usage_data")
|> filter(fn: (r) => r["deviceId"] == "1234")
|> filter(fn: (r) => r["clientIp"] == "192.168.13.123")
|> filter(fn: (r) => r["_field"] == "seconds")
|> aggregateWindow(every: 1d, fn: sum)
|> drop(columns: ["result", "table", "_start", "_stop", "_field", "_measurement", "clientIp", "deviceId"])
|> yield(name: "sum")`
Each row looks like this,
tags: clientIp, deviceId, hostName
fields: hostName(string), seconds(int)
results for 3days with aggregate by each day looks like this, but actually it requires to be shown dates are 14, 15 and 16
but with the output received how to get those values
`
{"result": "sum",
"table": "0",
"_start": "2020-06-14T09:16:37.577522612Z",
"_stop": "2020-06-16T09:16:37.577522612Z",
"hostName": "hos1",
"_value": "",
"_time": "2020-06-15T00:00:00Z"
},
{
"result": "sum",
"table": "0",
"_start": "2020-06-14T09:16:37.577522612Z",
"_stop": "2020-06-16T09:16:37.577522612Z",
"hostName": "hos1",
"_value": "431",
"_time": "2020-06-16T00:00:00Z"
},
{
"result": "sum",
"table": "0",
"_start": "2020-06-14T09:16:37.577522612Z",
"_stop": "2020-06-16T09:16:37.577522612Z",
"hostName": "hos1",
"_value": "",
"_time": "2020-06-16T09:16:37.577522612Z"
},`