Using ASPRunner and SQL database.
I am trying to have a chart dispaly the number of tickets for each market and also Display how many of those tickets are for each department on the chart.
Lets say my tables are the following: T_Number, Market and Department
I know the below will display each market and list the total number of tickets between that date range, but I am unsure how to add in the department to be displayed also.
select
Market,
COUNT(T_Number) AS TNUM
FROM mytable
WHERE (Creation_Date between '2005-01-01' AND '2005-12-31')
GROUP BY Market
ORDER BY Market DESC
And I know if I do GROUP BY Market, Department and look at the results it displays the information, but I am unsure how to get it to where I can have it display on the chart, since all i get to pick as a data series is TNUM.
Thanks!