Get opened and closed workitems per day
WITH Dates AS (
This gives me the following output
I now want to add SQL code to add a column counting the number of workitems that were created on that day, and a column indicating the number that were closed. I'm struggling with the syntax to get this output. Can anybody give me a pointer ?