I am stuck on a BarChart. I have a bar chart displaying Call (activity) success. So I have a chart showing the success rates for Calls, so I am tracking Calls, and then I want to see how many have been connected (option set).
I am grouping the activities by 7 days, so that each bar would be activities happened in a week.
Even though this is blue, it doesn’t display correctly. I am testing today (dec 25th) and all of my activities are showing on November 27th
Can you share the internal of these search.
One more thing you are searching 3 times this will cost you too much work unit.
Create a variable RG once hidden it and use that as a reference in these 3 places, this will reduce your work unit cost 3x
Your grouping logic is correct,
but i think you you are using date format for the label is wrong. You’ve entered a static date ‘11/27/23’ as the custom format, so every bar gets that label.
Change it to a dynamic format code like ‘m/d’ to show the actual start of each week. Also, your search needs a constraint to only count ‘connected’ calls.
I’m sorry, but I don’t understand your suggestion here.
I have data type Activity, and one field of the data type is called Activity type (an option set) and then another field is called outcome (also an option set).
I wish to display on the chart, in groupings of 7 days (a week) the call success rate. I.e. how many calls were made and what was the outcome (answered, to be specific). So each group of 7 days should have two pillars, one for nr. of calls and one for nr. of answered calls.
The date format is not static:
@tove.zilliacus ping me when you are free, we can debug it with a call , i will walk you thorugh , if its okey .
Could you not maybe just try and point me in the right direction? The AI bot is just babbling about time zones etc.
What’s happening is that Bubble isn’t really grouping into true 7-day “weeks”. When you group by date directly, Bubble picks a single anchor date for each group, so all activities that fall within that range end up showing under one date — which is why your December activity is appearing on Nov 27.
The fix is to group by a normalized week value instead of the raw date. The usual approach is to use the activity date rounded down to the start of the week (for example Activity date:rounded down to week) and then use that same value as the chart category. That way, every activity in the same week shares the same bucket and Bubble doesn’t collapse everything onto one random day.
Once you do that, both the Calls and Connected series will line up correctly under the actual weeks they happened in.
The reasson , i am asking to for a call is, everyone problem is difference, and most of time its very small issue which is not clear in forum causign it. when we get on a call it will make it easy to hlep you.
@iamcharlesac need to see weekly sum of calls , like for 1st week of december or last week of novermber, he need to grupe his activation oby the week, and then within that group editor he need to sum the calls ,
he also have to use a variable to do the search once, else his WU will drasticly increae
Activity Date: group by :week
@tove.zilliacus if you can show me how the database lay out i will create a dummy app eaxactly showing your case, else if you create a small loom shoign your chart and also the fileds in Activity data.
Ok , so my groupings are like this. I can’t seem to do “week” grouping. The -70 is because I wanted to restrict it to be only 10 weeks of data here.
This is a screenshot of my Activity data @Baloshi69
also to @Baloshi69 : for some reason it has now updated… so I am currently showing the calls correctly - however, the Connected is not showing
although I have data in the database…
Seems very strange.
Good to here,
But there are few thigns whcih are not oke, first why -70 days you should use the RG first item date there , as this is aksign what the start date of you list not from when to when you want it. for limiting it to only 10 weeks.
Inside your search use a constraint creation date is <= current date - weeks 10, and as i told you you need to search the list only in one dummpy Repeating group should not be visible We can only use it to reference, the list so we dont search every where because it cost us WorkUnits, On all 3 palces you are doing the search, reference that RG, and for first date use its first item .
2ndly, you use day and interval as 7 , it can be form friday to friday or sat to sat, which is not exact week … use Weekly there so bubble automaticly grup it by each week, a year hve 52 weeks depenign on it it group each call by week.
3rdly as you are not seeing all the connected there is becaus you are useing count in series 2, for series to before coutn use a filter to show only connected and then we can count them.
For your current setup do the search and inside the search user a constrain Call outcome = connected this will only list out connected calles, and the we show the count
OR you can use the reference Repeating goup and use filter to limit only connected then use count.
One more thing you need as for data it should be a comma seperated list of value so it can build you graph like: 10,20,30,40,50 for this on the list before choozing count, use :Format as text this will give you a table one for what value you need and other for the delimeter.
user the count valeu and below add , as a delimiter this will give you a list and it will build you graph.
I hope the above reply ans your question, if you still need hlep, can ping me any time. love to help.
@iamcharlesac @Baloshi69 I am giving up, I have now tried building repeating groups on the page, won’t work. I have added a Data field (activity week) to the data type Activity to actually reference a week number in the app data. And I still can’t get this chart to work.
If you okey, i can help you with it for free, when you free ping me, let have a call and fix it
hey, i get the frustration. honestly, this kind of thing is one of the most annoying parts of bubble and you’re not wrong to feel stuck.
from what you’ve explained, you’re actually very close. the problem usually isn’t the chart or the repeating group, it’s how bubble handles dates when grouping by week. adding a separate “week” field feels logical, but charts still depend on the original date and that’s why it keeps behaving weirdly.
the approach that usually works is grouping activities by activity date → week, then summing the calls inside that grouped result, using one stored search so it doesn’t rerun over and over. once that’s in place, the bars line up correctly by week.
if you’re open to it, we can hop on a short call and i’ll help you set it up step by step. this is normally a quick fix once you see it working live.
