Grouping Deadlines by Weeks (Monday to Sunday) in Bubble.io

martinskaarup1 · 2024-08-05T08:28:16.990Z

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.

Skærmbillede 2024-08-05 kl. 10.26.441709×488 20 KB

Skærmbillede 2024-08-05 kl. 10.27.41704×829 73 KB

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!

system · 2024-10-14T08:28:49.449Z

This topic was automatically closed after 70 days. New replies are no longer allowed.