Forum Documentation Showcase Pricing Learn more

[New Feature] Grouping and Aggregating Data


#1

Hi all,

We’ve heard from many of you that you’d like an efficient way of displaying your app’s data in a chart or table. For instance, maybe you’d like to be able to show a graph of new user signups by month, or show a table of total sales by region and account.

We now have a tool for supporting this kind of operation. It’s called “:group by”, and you apply it on top of a search or other list of data items in order to group and summarize the list.

The basic concept is that you define one or more groupings, which specify how we group the data (by creation date? by category? by owner?) and then one or more aggregations, which specify what you want to know about it (how many items there are, or the sum or average of a number field, etc.)

The output of the group by operation is a new, shorter list, that contains items that represent the resulting groups. Each group has the fields you grouped on, and the aggregations we calculated describing the group. You can then use this new list as the data to display in a chart element or a repeating group element.

For more details on exactly how groupings and aggregations work, please see the description of the new feature in the reference: https://bubble.is/reference#Data.Messages.list.group_by


Sub grouping within a repeating group
Group data in categories, then show the weight of each data group as a percentage of total
Group by Creator
How to aggregate data on line graph by month (Chart Element Plugin)
How to display data to graph or chart
amCharts plugin [Premium now Live]
[Solved] Create a chart showing data from previous week
Cummulative values in charts
How to count names and show the result in a chart?
Recommendations for simple bar and line charts?
How to only show unique data field from Repeating Group
[New Feature] Geographic search box improvements
Again, how to avoid the (1) on entries (things) with same text on identification field? (updated)
Repeating Group inside of a Repeating group?
amCharts plugin [Premium now Live]
#2

Where do i get this chart element?


#3

Amazing, Finally and just in time for my new project.

Thanks guys


#4

The one in my screenshot is the Bubble-team-built “Chart Element” plugin, but you should be able to use this new feature with any Bubble chart plugin: there’s a bunch of great community-created charts as well. Just go to “Plugins” -> “Add plugin” and search for charts


#5

Why not also have a “group by” option on RG’s?


#6

Is this only for the new bubble version?


#7

Works flawlessly. Very well done guys. Thanks.

@cheskiefisch, have you tried it? It works on searches so yes, you can use it on a RG.


#8

Oh my god… #fangirling over this.

Very, very cool. Nice work! :ok_hand:


#9

This is awesome! Should make data segregation a breeze :slight_smile:


#10

Very cool feature! This should help quite a bit when working with Google Charts. Looking forward to using it!

David
AirDev - Custom Software for Everyone


#11

Thank You!!!


#12

Clutch!


#13

So great to see this. Thanks guys.

Would this be a good time to ask for the ability to sort by these wonderful new groups? :slight_smile:

–Ken


#14

@josh this is an awesome addition to the platform. Really enjoying it!

Question: when I use the data source: Do a search for a User, it seems that the chart doesn’t render. However, when I use other data types, a chart renders. (Note: group by User where User is a thing on another table works. Just not when it is used for the initial data source).

Perhaps I’m missing something. Or is it not possible to use User as a data source?


#15

Grouping a list of users should work, so you might be seeing a bug (it’s brand new code, so there are probably still a few kinks to work out…). If you can put together a demo page that shows the issue, and email it to support@bubble.is, I’d appreciate it


#16

Figured that may be the case, will send in the next ~30 min.


#17

Actually @fayewatson beat you to it :slight_smile: . I guess it’s a general problem with the grouping Users. Investigating now, hopefully will have a fix this evening


#18

Sounds good, if you have any trouble replicating, ping me and I’ll put a video together.


#19

@dan1 Ah, I just saw these posts! I was trying to set up exactly what you described. :slight_smile:

Thank you so much for the help, @josh!


#20

@josh I LOVE YOU Right Now!