I can't go into too much detail, but I'll do my best.
My input contains 3 columns: id, name, and created date.
The output I'm looking for is: a row for each month of the year, with a column name, and a count of ids per name/month.
Sort of like this:
Name Name2 Name3
Jan-14 1 0 3
Feb-14 2 4 4
Mar-14 0 0 1
(I've got all the time conversion and sorting figured out, I'm just having trouble sorting by both month and name (I can easily do one or the other but not both) so I figured if each name had a field I could just count those fields by month)
... View more