Forum Documentation Showcase Pricing Learn more

[New Feature] Grouping and Aggregating Data


#48

@gxjansen Is this what you’re looking to set up? :slight_smile: In this example, 1 User signed up on April 17th, and 3 signed up today, April 21st:

The data setup I used is:

*Note: This is showing the past 30 days and the future 3 days so the graph doesn’t get cut off on April 21st. If you want to remove the next three days, the Ending Date would just be “Current date/time”


How to display sign-ups in a calendar month?
Chart Tools Plugin
Chart Tools Plugin
#49

Is searching done in the server in one request? Or is there going to be a slight performance issue like :filter and other modifiers?

@josh


#50

Unfortunately you’re not missing something – we don’t have out-of-the-box support for cumulative calculations. That said, this is something that could be easily added to a custom chart plugin. I haven’t checked our existing plugins to see if any of them support cumulative graphs or not, yet – I’d recommend checking them out, and if none of them support it, you could consider sponsoring one of them to add it if you really need the feature.

Generally, group by operations done on top of search will be done on the server in a single request, so it should be pretty fast. If there are more than 100 groups in the result, we load them 100 at a time, so a chart that tries to display 1000 data points at once might be a little slow.

If you do a group by on top of a list that doesn’t come straight from a search, depending on what operations you do to build the list, we may have to do the grouping in the web browser, which means loading all the underlying data to the web browser, which is much slower. So if you do a search -> advanced filter -> group by, that will take about as long as it would to load every result in the original search. Generally if we’re able to calculate the underlying list on the server, though, we’re also able to do the group by on the server.

(Sometimes Bubble will choose to do the grouping the web browser even if we don’t have to, if you’ve already loaded most of the results and we think it will be faster to just load all of them than it will be to do a separate group by search).


#51

No, I managed to get what you have, but I’m looking for cumulative calculations, what @josh mentioned


#52

I had thought I could do the following with this feature:

Show in a chart items per grouping. For example I have a data type of ‘Groceries’. Each entry has a type and a product.

Type Product
Vegetables Zucchini
Vegetables Eggplant
Fruit Banana
Fruit Apple

In an Excel pivot table/chart, it looks like this:

Anyone figured something like this out?


#53

hey @gxjansen - Chart Tools offers cumulative aggregation. I am mid-way through transitioning the plugin to these native Bubble grouping tools (it previously offered grouping / aggregation but this Bubble implementation offers more firepower).


#54

Oh cool thx for that, I’ll check it out. Let me know when the native grouping is ready!


#55

Is there any update to fixing the freezing of repeating groups? If not, I will go back to they way I was doing them before until this is sorted out.


#56

it´s not fixed yet. I filed a report today about this because my app keeps freezing. I was told developers are working on the fix and will deploy as soon as ready


#57

We deployed a fix to a bug last evening that caused the page to freeze when grouping on a user or custom thing in situations where Bubble was loading all the raw data to the web browser, which was likely the cause of many of the reported bugs above. If you’re still seeing issues with this, please submit or follow up on a bug report to us.


#58

That took care of my bug report, all fixed…Thanks @josh


#59

@josh would it be possible to sort the result list from the grouping please ?
I’ve not been able to sort my [Products] according to one of its field


sending you the exemple in PM


Sorting Repeating Groups That Use :grouped by?
#60

I´ve already reported this is a bug and this is the reply I got:

So…it seems we´ll have to wait…


#61

@josh It seems this feature is kind of useless in repeating groups if you can’t group and sort by the same field. Now I have a bunch of groups in a random order.

Also, what is the best way to create category headers in a repeating group? Right now I have a repeating group with the source as a thing and grouped by a category field. This repeating group has the category field shown as a text header and then a nested repeating group underneath. How do I get those things that belong to that category in the nested repeating group? The only way I can make it work is to do another search for those things that belong to that cell’s category. This doesn’t seem very efficient however, since I have already searched and fetched those things in the main repeating group, but now I’m doing another search for each category. Is there a way to tell the nested repeating group to show those things from the original search in the current cell’s group without doing multiple searches? I hope this makes sense!


#62

Hi Josh,

Should we still submit a bug report for the freezing issues or are you guys working on it? Would be willing to chip in to sponsor a fix as I need it for a client app.

Cheers, Greg


#63

Just pushed the latest update to my cluster and I think it’s fixed.


#64

Hi @josh

Is the freezing issue fixed? because I’m still having issues with browser freezing on pages where the “:group by” is used on a chart.


#65

Hi @vascolucci, I believe we’ve fixed all freezing-related group by bug reports that we’ve gotten so far, so if you’re still seeing freezing issues, please submit a report and we’ll investigate


#66

Thanks, I will check if the freezing persist, I will submit bug report.


#67

@josh Can we not group by a Yes/No field? Yes/No fields do not show up in the group by drop down.