I am trying to group my deadlines by weeks in Bubble.io, with the weeks starting from Monday and ending on Sunday. However, in the “Type of grouping” options, I can only choose “Exact”, “Day”, or “Month”. There is no option to group by “Week”.
I need to create a bar chart that shows the number of deadlines per week, starting from Monday and ending on Sunday. The current setup leads to incorrect data groupings.
In week 32 there should be 24 items.
Can someone help me with the correct setup or workaround to achieve this?
Here is what I’ve tried so far:
- Using “Day” with an interval of 7 days, but this does not correctly group the data by week starting from Monday.
- Creating a calculated field to set the start of the week, but I’m unsure of the correct expressions and workflow to use.
Any guidance or examples would be greatly appreciated!