How to group data into weeks, quarterly or months and how to count data on y axis when groupoing

[benny1]

Chart.js I am using this plugin and I am trying to get my data grouped into weeks and quarterly. I have a blocker though. I can’t seem to be able to achieve this at the moment. Help pls

It would be good if I could on the x-axis show a weekly interval of the dates. Also on the y - axis is there a way I could use the count attribute to show the number of occurrences within these periods?

[ezduriez]

Try to insert a group by at the end of the data source and choose the days you want, or even dynamically from a dropdown (number of days). You probably will need to change the type of data to “grouping”.