{"metrics":["player_division","player_spending_quotient"],"group_bys":["player_division"],"filters":{"replay_date":{"logic":"relative","value":"current_year"},"format":{"logic":"in","value":["1v1"]},"game_type":{"logic":"in","value":["AutoMM"]}},"order":[{"player_division":"DESC"}],"date":"replay_date:current_year","settings":{"number_format":true,"fact_only":true},"original_request":{"metrics":["player_division","player_spending_quotient"],"group_bys":["player_division"],"filters":{"replay_date":{"logic":"relative","value":"current_year"},"format":{"logic":"in","value":["1v1"]},"game_type":{"logic":"in","value":["AutoMM"]}},"order":[{"player_division":"DESC"}],"date":"replay_date:current_year","settings":{"number_format":true,"fact_only":true}},"results":{"mappings":{"chart":{"title":""},"group_bys":{"player_division":{"metric_title_header":"Division","metric_description":null}},"metric":{"player_spending_quotient":{"metric_title_header":"Spending Quotient","metric_description":null,"max":"113"}}},"data":[{"player_division":"unranked","player_spending_quotient":"94"},{"player_division":"silver","player_spending_quotient":"78"},{"player_division":"platinum","player_spending_quotient":"90"},{"player_division":"master","player_spending_quotient":"104"},{"player_division":"grandmaster","player_spending_quotient":"113"},{"player_division":"gold","player_spending_quotient":"83"},{"player_division":"diamond","player_spending_quotient":"99"},{"player_division":"bronze","player_spending_quotient":"85"}],"sql":"SELECT player_division,any(player_spending_quotient_metric) AS player_spending_quotient FROM (SELECT player_division AS player_division,avg(dfgp0.player_spending_quotient) AS player_spending_quotient_metric FROM degenerate_fact_game_player dfgp0 WHERE dfgp0.`replay_date` BETWEEN toDateTime('2024-01-01 00:00:00') AND toDateTime('2024-11-16 16:35:04') AND dfgp0.`format` IN ('1v1') AND dfgp0.`game_type` IN ('AutoMM') GROUP BY player_division) tmp GROUP BY player_division ORDER BY player_division DESC"}}