When doing a line graph viewing count of rows by week, the x axes labels make no sense. For example, where I would expect October I see “40th - 2016”
I bet that’s returning the week of the year. If you viewed count of rows by month, you would see “October” as the label, but then (I’m betting) you would lose the individual weeks’ data (just a sum over the month time frame).
Yea, what I want is for it to say month, but still have some representation of week
Yup, it’s returning the week number. This is what most SQL dialects return. Definitely worth looking into ways of making that look nicer however.