Query editor
with claim_groups as (selectcasewhen CUBEs_claimed <= 1 then '1 CUBE'when CUBEs_claimed < 10 then '2-9 CUBEs'when CUBEs_claimed < 50 then '10-49 CUBEs'when CUBEs_claimed < 100 then '50-99 CUBEs'when CUBEs_claimed < 200 then '100-199 CUBEs'when CUBEs_claimed < 300 then '200-299 CUBEs'when CUBEs_claimed < 400 then '300-399 CUBEs'when CUBEs_claimed < 500 then '400-499 CUBEs'when CUBEs_claimed < 600 then '500-599 CUBEs'when CUBEs_claimed < 700 then '600-699 CUBEs'when CUBEs_claimed < 800 then '700-799 CUBEs'when CUBEs_claimed < 900 then '800-899 CUBEs'when CUBEs_claimed < 1000 then '900-999 CUBEs'when CUBEs_claimed >= 1000 then '1000+ CUBEs'end as cubes_claimed_groupfromquery_3435001)selectcubes_claimed_group,count(*) as Wallets,count(*) * 100.000 / (sum(count(*)) over() * 100) as sharefrom claim_groupsgroup by 1order by 2 desc