You're also either missing the closing parenthesis for the first CTE or having an extra opening parenthesis after the WHERE clause.

EDIT: Did I mention that you have several...

Bravo! You really out did yourself, Joe.
I wonder if anyone can make sense of your post.

Something that might slow down inserts, but could really help is to add a bit column to the table to identify the most recent row. This column needs to be...

XML Path is usually the fastest way to create comma-separated lists. However, you shouldn't store them in a table and you shouldn't be concatenating all those values at once.

You should change your UNION to UNION ALL

Is it possible that you have a group that is called everyone? The numbers are different on your results.

Your query looks so overwhelming when it can be so simple:

SELECT CAST( td.CallDateTime AS DATE),
   COUNT(CASE WHEN td.CallTypeId = 1 THEN 1 END) AS [1],