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.