Requirement: create a report to show frequency of usage of snippets by each agent, with a pull-down to select the time period.
Title: Snippets used ${date} split by agent
SELECT v2_snippet_use_log.snippet.title, DPQL_COUNT() AS 'Uses' FROM v2_snippet_use_log
WHERE v2_snippet_use_log.snippet.id <> NULL AND v2_snippet_use_log.date_created = ${date}
SPLIT BY v2_snippet_use_log.person
GROUP BY v2_snippet_use_log.snippet.id
ORDER BY DPQL_COUNT() DESC) copy
Variable
Please log in or register to submit a comment.