#1085

Visits by Date

Traffic analytics is building a daily visits series. In a_events, count events where kind = 'visit', taking the date from ts. Return d and visits, sorted by d.

Eksempel på forventet output

Sådan ser et korrekt svar ud — dets rækketal er dets eget og behøver ikke at matche skematabellerne.

dvisits
2024-01-053
2024-01-062
2024-01-071

Resultatet af din forespørgsel vises her