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.
| Code Block | ||||
|---|---|---|---|---|
| ||||
SELECT c_status as 'status', COUNT(c_status) as 'count' FROM app_fd_tix_tickets WHERE c_category_id = '#userviewKey#'status IS NOT NULL GROUP BY c_status |