Group by date (day,week,month,year) from unixtimestamp

[vsr1]

Thanks.

Aggregating weekly data in N1QL? In MySQL I would use YEARWEEK()

How do I generate a weekly aggregates using N1QL? The result I am looking for: count || date 100 || 2020-11-02 300 || 2020-11-09 400 || 2020-11-16 In MySQL I would use YEARWEEK() to come up with the results above, but in N1QL I am lost because I have been looking at the documentations and looking through various forums but I never found the answer. I am hoping there’s a way in N1QL because I’m trying to avoid using VIEW to make it simple for my team.