It's probably worth posting another question on this, with some clearer details on what you want, for example, how do you want to handle FirstSeen as 2021-01-10 23:59 and LastSeen as 2021-01-11 00:01. If you bin by 1d, then there will be no LastSeen. Also when you use 'count by', did you mean the average. And your question of 'average' by day, is that also by type.
... View more