When I try to make a BAR chart , I get an error message The type of column with name ... is not numeric. The data source for the chart is retrieved from SQL 2005 using this query:
SELECT DepartmentName, COUNT(*) AS departmentSummary FROM DimEmployee GROUP BY DepartmentName
which give me 2 coloums - one contains department name, one contains the number of employee in department name (please see attach image).
SELECT DepartmentName, COUNT(*) AS departmentSummary FROM DimEmployee GROUP BY DepartmentName
which give me 2 coloums - one contains department name, one contains the number of employee in department name (please see attach image).