Have SQL table, need to build interactive SQL chart
HI all I'm trying to take a very basic SQL table which shows the count of submitted IR's by month for a certain year (and also a separate table which does the same but for SR's) and turn it into an interactive bar chart like you can with Cireson's usual bar charts, where it will show the total number at the top of each column in the chart, and when you click each bar it'll show you a list of all the service requests (or IR's) contained in that count.
Data Source: ServiceManagement
Here's what I'm using just for the table:
SELECT MONTH(Created) MONTH, COUNT(*) COUNT
AND WorkItemId like 'SR%'
GROUP BY MONTH(Created);