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