Come raggruppare per data solo in data explorer

[pfaffman (Jay Pfaffman)]

You want to round the datetime to the day. See

9.9. Date/Time Functions and Operators

I am on my phone, so can’t (or won’t) do a full solution, but this should get you close

SELECT EXTRACT(DOY FROM created_at) as day