Hi there.
I want to show the amount of records of a SQL table (day by day) in a bar chart, using next script:
SET STATISTICS TIME, IO ON;
SELECT COUNT(*) , CAST([ShiftStartTS] AS date) FROM
MyTable
WHERE shiftstartts BETWEEN DATEADD(month, DATEDIFF(month, 0, GETDATE()), 0) AND DATEADD(month, DATEDIFF(month, 0, GETDATE())+1, 0)
GROUP BY CAST([ShiftStartTS] AS date)
ORDER BY 2 ASC
However, it does not work. If I use a power table, it works like this:
Is there a way to set Bar Chart object to show that information?
Thanks in advance.