$VAR1 = {
          'columnsettings' => 'date,Date

user,User

invoices,Invoice Count

turnover,Total Turnover

average,Invoice Average

covers,Covers

AHS,AHS',
          'selector' => '2',
          'data' => 'SELECT 

	dci.date AS \'date\',

	w.`name` AS \'user\',

	COUNT(dci.tillinvoices_id) AS \'invoices\',

	SUM(dci.`dcinv_turnover_total`) AS \'turnover\',

	SUM(dci.`dcinv_turnover_total`)/COUNT(dci.`tillinvoices_id`) AS "average",

	SUM(dci.covers) AS \'covers\',

	SUM(dci.`dcinv_turnover_total`)/SUM(dci.`covers`) AS "AHS"

	

FROM dcashinvoices dci

JOIN tillinvoices ti ON dci.`tillinvoices_id` = ti.`id`

JOIN waitron w ON w.id = ti.`waitron_id`



WHERE dci.`f_status` = 1 and dci.date >= \'[sdate]\' AND dci.date <= \'[edate]\'



GROUP BY w.name, dci.date



ORDER BY average desc ;',
          'description' => 'AVERAGE PER INVOICE AND HEAD SPEND',
          'settings' => 'sdate,date,Start Date

edate,date,End Date',
          'rollup' => 'date',
          'id' => '96',
          'title' => 'APH SALES',
          'category' => 'Tests',
          'code' => '96'
        };