Hello,
I have a chart with SQL code below, I was wondering if it is possible to add a GROUP BY clause in the BeforeSQL query page event to modify the existing one?
i.e right now it is group by case_signed, I would like to have the option on the BeforeSQL query page event to change the group by clause to GROUP BY counselor. is this possible?
Thanks
SELECT
COUNT(date_added) AS Cases,
case_signed
FROM quotes
GROUP BY case_signed
ORDER BY case_signed DESC