Bar Chart counted weekdays

Hi, I’m a bit puzzled. In my Bubble app, users can complete tasks. Completed tasks are stored in a separate data type. In this database, the day of the week (0-6) for each completed task is also recorded. I also added a formated “Mo”, “Di”… based on the created date.

Now I want to create a bar chart that shows users on which days of the week they complete the most tasks (Mon - Fri). Sorting (Mon - Fri) and showing always all weekdays even if they are empty (didnt work with “igonre empty field”)

I tried with grouping and aggregation but I simply coudn´t get it done. Any hint is much appreciated, thanks a lot.

graph

Best,
Carsten

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