Not particularly happy with how much extra is needed here (specifically doing the `date_trunc` on a joined table, but I don't really have any other options.