Bar Chart to show cumulative data, day by day

Ignition
1

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:

imagen
imagen466×517 4.71 KB

Is there a way to set Bar Chart object to show that information?

Thanks in advance.

2

The date should probably be the first column.

3

@Rigoberto, a tip: use the </> code formatting button to format code - not bold type.