gistfile1.rb

@agents = @bucket.find(:all, :joins => {:store => [:agent]}, :select => "agents.name as agent_name, COUNT(card_creation_transactions.id) as card_creation_transaction_count, card_creation_transactions.store_id, card_id", :group => "agents.name", :order => "agents.name")

@agents.map! {|cct| {"agent_name" => cct.attributes["agent_name"], "card_creation_transaction_count" => cct.attributes["card_creation_transaction_count"]}}