View Source

SQL Chart equips you with another medium of reporting by using charts. You are given the flexibility of defining your own SQL query to determine the charts that you would like to generate, ranging from a number of graph types.

SELECT c_status as 'status', COUNT(c_status) as 'count' FROM app_fd_tix_tickets WHERE c_status IS NOT NULL GROUP BY c_status

Knowledge Base for v4 > SQL Chart Userview Menu > Ticket - Report 2011-11-10 16-34-20.png

Knowledge Base for v4 > SQL Chart Userview Menu > Ticket - Report 2011-11-10 16-51-11.png

SELECT c_status as 'status', COUNT(c_status) as 'count' FROM app_fd_tix_tickets WHERE c_status IS NOT NULL AND c_category_id = '#userviewKey#' GROUP BY c_status