Query editor
WITH wash_trading AS (SELECT wash_trading_filterFROM (VALUES('ON', true), ('OFF', false)) AS x (switch, wash_trading_filter)WHERE '{{Wash Trading Filter}}' = switch)SELECT date_trunc('week', time) AS time, CASE WHEN MAX(latest_ranking) < 11 OR project='Magic Eden' THEN project ELSE 'Others' END AS project, CASE WHEN '{{Currency}}' = 'USD' THEN SUM(volume_usd) ELSE SUM(volume_eth) END AS volumeFROM query_2704831WHERE wash_filter IN (SELECT wash_trading_filter FROM wash_trading)AND time < date_trunc('week', NOW())GROUP BY 1, projectORDER BY MAX(latest_ranking)