50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
|
# File 'app/models/workarea/metrics/search_for_last_week.rb', line 50
def group_by_query
{
'$group' => {
'_id' => '$query_id',
'query_string' => { '$first' => '$query_string' },
'total_results' => { '$first' => '$total_results' },
'searches' => { '$sum' => '$searches' },
'orders' => { '$sum' => '$orders' },
'units_sold' => { '$sum' => '$units_sold' },
'discounted_units_sold' => { '$sum' => '$discounted_units_sold' },
'merchandise' => { '$sum' => '$merchandise' },
'discounts' => { '$sum' => '$discounts' },
'tax' => { '$sum' => '$tax' },
'revenue' => { '$sum' => '$revenue' },
'reporting_on' => { '$min' => '$reporting_on' }
}
}
end
|