action: ACCEPT |SELECT COALESCE(vpc_A_traffic.minute, vpc_B_traffic.minute) AS minute,
COALESCE(vpc_A_traffic.total_vpc_A_traffic, 0) * 100 / NULLIF(COALESCE(vpc_A_traffic.total_vpc_A_traffic, 0) + COALESCE(vpc_B_traffic.total_vpc_B_traffic, 0), 0) AS vpc_A_percentage,
COALESCE(vpc_B_traffic.total_vpc_B_traffic, 0) * 100 / NULLIF(COALESCE(vpc_A_traffic.total_vpc_A_traffic, 0) + COALESCE(vpc_B_traffic.total_vpc_B_traffic, 0), 0) AS vpc_B_percentage
SELECT date_trunc('minute', __time__) AS minute,
WHEN "end" - start = 0 THEN 1
END) AS total_vpc_A_traffic
WHERE srcaddr LIKE '192.168.%'
GROUP BY date_trunc('minute', __time__)) as vpc_A_traffic
SELECT date_trunc('minute', __time__) AS minute,
WHEN "end" - start = 0 THEN 1
END) AS total_vpc_B_traffic
WHERE srcaddr LIKE '172.16.%'
GROUP BY date_trunc('minute', __time__)) as vpc_B_traffic
ON vpc_A_traffic.minute = vpc_B_traffic.minute