Hi
I am using Apex 24.2
I have a page with a faceted report. It is looking at application activity using the following code
SELECT TO_CHAR(time_stamp, 'MM.YYYY') AS month, application_name,
COUNT(*) AS access_count
FROM apex_activity_log, APEX_APPLICATIONS
WHERE application_id = flow_id
and application_id IN (select application_id from APEX_APPLICATIONS
where application_id not in (162, 163)
and workspace = 'BDV_SCAN')
and application_name = :P4_APPLICATION_NAME
and time_stamp >= sysdate -365
GROUP BY TO_CHAR(time_stamp, 'MM.YYYY'), application_name
ORDER BY month
The report has facetes on month and application name and works fine.
I would also like to have a bar chart that reflects this report. Month as x, count as y, group by application.
I used the same sql for the report but how do I develop it so it responds to the changes in the facetes
Regards
Gus