Add GROUP BY to query report
I have made this report to show us which users are eligible for mobile phone upgrades:
SELECT aau.FIRST_NAME "Requester", DATE_FORMAT(from_unixtime(reqf.UDF_DATE1/1000), '%m/%d/%Y') "Mobile Phone Upgrade Date" FROM AaaUser aau LEFT JOIN Requester_Fields reqf ON aau.USER_ID=reqf.USERID WHERE (reqf.UDF_DATE1/1000 < unix_timestamp(now()) )
I'd like to create two separate reports, one grouped by Site, and the other grouped by Region--how would I do this? We're using 8016 with MySQL. Thanks!
SELECT aau.FIRST_NAME "Requester", DATE_FORMAT(from_unixtime(reqf.UDF_DATE1/1000), '%m/%d/%Y') "Mobile Phone Upgrade Date" FROM AaaUser aau LEFT JOIN Requester_Fields reqf ON aau.USER_ID=reqf.USERID WHERE (reqf.UDF_DATE1/1000 < unix_timestamp(now()) )
I'd like to create two separate reports, one grouped by Site, and the other grouped by Region--how would I do this? We're using 8016 with MySQL. Thanks!