Balkar Lathwal
08/25/2025, 10:20 AMBalkar Lathwal
08/25/2025, 10:21 AMBalkar Lathwal
08/25/2025, 10:21 AMBalkar Lathwal
08/25/2025, 10:21 AMXiang Fu
Xiang Fu
HAVING $0='GUxxx'Balkar Lathwal
08/25/2025, 11:05 AMSELECT
arrayToMv(manager_ids),
COUNT(CASE WHEN event_name = 'ss_deployed_v1' THEN 1 END) AS ss_deployed,
COUNT(CASE WHEN event_name = 'qr_deployed_v1' THEN 1 END) AS qr_deployed,
COUNT(CASE WHEN event_name = 'merchant_onboarded_v1' THEN 1 END) AS merchant_onboarded
FROM ace_watchtower_agents_agent_kpi_events
WHERE
event_name IN ('ss_deployed_v1', 'qr_deployed_v1', 'merchant_onboarded_v1')
GROUP BY arrayToMv(manager_ids) having $0='GU2406261237361289228350'Balkar Lathwal
08/25/2025, 11:05 AMBalkar Lathwal
08/25/2025, 3:42 PMXiang Fu
WITH agg AS (
SELECT
arrayToMv(manager_ids) AS manager_id,
COUNT(CASE WHEN event_name = 'ss_deployed_v1' THEN 1 END) AS ss_deployed,
COUNT(CASE WHEN event_name = 'qr_deployed_v1' THEN 1 END) AS qr_deployed,
COUNT(CASE WHEN event_name = 'merchant_onboarded_v1' THEN 1 END) AS merchant_onboarded
FROM ace_watchtower_agents_agent_kpi_events
WHERE event_name IN ('ss_deployed_v1', 'qr_deployed_v1', 'merchant_onboarded_v1')
GROUP BY arrayToMv(manager_ids)
)
SELECT *
FROM agg
WHERE manager_id = 'GU2406261237361289228350';Balkar Lathwal
08/25/2025, 4:04 PMBalkar Lathwal
08/25/2025, 4:04 PMSELECT
arrayToMv(manager_ids) as m,
COUNT(CASE WHEN event_name = 'ss_deployed_v1' THEN 1 END) AS ss_deployed,
COUNT(CASE WHEN event_name = 'qr_deployed_v1' THEN 1 END) AS qr_deployed,
COUNT(CASE WHEN event_name = 'merchant_onboarded_v1' THEN 1 END) AS merchant_onboarded
FROM ace_watchtower_agents_agent_kpi_events
WHERE
event_name IN ('ss_deployed_v1', 'qr_deployed_v1', 'merchant_onboarded_v1')
GROUP BY m having m ='GU2406261237361289228350'Balkar Lathwal
08/25/2025, 4:04 PMBalkar Lathwal
08/25/2025, 4:06 PMXiang Fu
Balkar Lathwal
08/25/2025, 4:08 PMBalkar Lathwal
08/25/2025, 4:32 PMBalkar Lathwal
08/25/2025, 4:32 PMSELECT
arrayToMv(manager_ids) AS manager_id,
COUNT(CASE WHEN event_name = 'ss_deployed_v1' THEN 1 END) AS ss_deployed,
COUNT(CASE WHEN event_name = 'qr_deployed_v1' THEN 1 END) AS qr_deployed,
COUNT(CASE WHEN event_name = 'merchant_onboarded_v1' THEN 1 END) AS merchant_onboarded
FROM ace_watchtower_agents_agent_kpi_events
WHERE event_name IN ('ss_deployed_v1', 'qr_deployed_v1', 'merchant_onboarded_v1')
and arrayToMv(manager_ids) in ('GU2406261237361289228350')
GROUP BY arrayToMv(manager_ids)Balkar Lathwal
08/25/2025, 4:32 PMBalkar Lathwal
08/25/2025, 4:33 PMWITH agg AS (
SELECT
arrayToMv(manager_ids) AS manager_id,
COUNT(CASE WHEN event_name = 'ss_deployed_v1' THEN 1 END) AS ss_deployed,
COUNT(CASE WHEN event_name = 'qr_deployed_v1' THEN 1 END) AS qr_deployed,
COUNT(CASE WHEN event_name = 'merchant_onboarded_v1' THEN 1 END) AS merchant_onboarded
FROM ace_watchtower_agents_agent_kpi_events
WHERE event_name IN ('ss_deployed_v1', 'qr_deployed_v1', 'merchant_onboarded_v1')
and arrayToMv(manager_ids) in ('GU2406261237361289228350')
GROUP BY arrayToMv(manager_ids)
)
SELECT *
FROM agg
WHERE manager_id = 'GU2406261237361289228350';Balkar Lathwal
08/25/2025, 4:33 PMBalkar Lathwal
08/25/2025, 4:34 PMBalkar Lathwal
08/25/2025, 4:47 PMXiang Fu
Xiang Fu
HAVING m= 'GU2406261237361289228350'Balkar Lathwal
08/26/2025, 6:18 AMBalkar Lathwal
08/26/2025, 6:19 AMBalkar Lathwal
08/26/2025, 6:20 AMBalkar Lathwal
08/26/2025, 6:21 AMSELECT
arrayToMv(manager_ids) as m,
COUNT(CASE WHEN event_name = 'ss_deployed_v1' THEN 1 END) AS ss_deployed,
COUNT(CASE WHEN event_name = 'qr_deployed_v1' THEN 1 END) AS qr_deployed,
COUNT(CASE WHEN event_name = 'merchant_onboarded_v1' THEN 1 END) AS merchant_onboarded
FROM ace_watchtower_agents_agent_kpi_events
WHERE
event_name IN ('ss_deployed_v1', 'qr_deployed_v1', 'merchant_onboarded_v1')
GROUP BY m having m in ('GU2406261237361289228350')Balkar Lathwal
08/26/2025, 6:29 AMXiang Fu
Balkar Lathwal
08/26/2025, 6:41 AMBalkar Lathwal
08/26/2025, 8:34 AMBalkar Lathwal
08/26/2025, 12:37 PMXiang Fu
WITH agg AS (
SELECT
arrayToMv(manager_ids) AS manager_id,
COUNT(CASE WHEN event_name = 'ss_deployed_v1' THEN 1 END) AS ss_deployed,
COUNT(CASE WHEN event_name = 'qr_deployed_v1' THEN 1 END) AS qr_deployed,
COUNT(CASE WHEN event_name = 'merchant_onboarded_v1' THEN 1 END) AS merchant_onboarded
FROM ace_watchtower_agents_agent_kpi_events
WHERE event_name IN ('ss_deployed_v1', 'qr_deployed_v1', 'merchant_onboarded_v1')
and arrayToMv(manager_ids) in ('GU2406261237361289228350')
GROUP BY arrayToMv(manager_ids)
LIMIT 10000000
)
SELECT *
FROM agg
WHERE manager_id = 'GU2406261237361289228350';Xiang Fu
LIMIT clause will break the query into two stages so the filter will work in the outer queryBalkar Lathwal
08/26/2025, 3:10 PMBalkar Lathwal
08/26/2025, 3:11 PMXiang Fu
Balkar Lathwal
08/26/2025, 4:39 PM