Forum Academy Marketplace Showcase Pricing Features

[New Feature] Grouping and Aggregating Data

The fix is live.

It would be nice to be able to aggregate date fields.

I’m grouping log entries made by the same user. I can get the count, which gives me the total number of log entries made by that user. I would like to also find the most recent log entry in that group using MAX on the modified date field, but it looks like MAX only works on number fields.

1 Like

It would also be nice to be able to “join” the list of groupings.

I’m scoring a survey that has several categories within it. The “group by” works to generate an average for each category, and the grouping itself has the “category” and “average” as fields side by side, but I’d like to keep the results organized in an array or table when I save them. “Join with” only appears when I select an individual field, which means the results look like this:
A,B,C, + 1,2,3
instead of this:
A-1,B-2,C-3
Basically, to save or print the results I need to concatenate the fields in the list and then join the resulting strings.

1 Like

Hello,
@Bubble Do you plan to add a sorting function applied to the grouping result ?

3 Likes

Will the list of type “grouping” be supported in more bubble elements and actions?

I’d like to be able to save the results but nothing outside of the repeating group (and chart?) recognize “grouping” as an option. So I can’t even save the grouping to a database thing, because that action requires picking the source type from the dropdown.

Is there a way to group by hour? I tried grouping by day and setting the interval to a decimal (like .1) but it doesn’t look like it works.

I tried getting the list of things, converting it into a list of dates, and formatting each date as HH (just the hour) but then I can’t group by anymore.

3 Likes

An aggregate type that would be useful is “difference between consecutive items”.

I’m calculating fasting periods as the time between when foods are logged. So it’s the time between each entry that I need. The time stamps can be converted to numbers, which aggregates already work in.

I was able to do this in the toolbox Expression element using map Toolbox plugin - collection of utility elements

Anyone figured out how to return a grouping from an API? I’m trying to get a list of my users sorted by creation date - grouped by Month… and return this from the API. Currently no luck, as ‘grouping’ is not an option in the data types, and trying to coerce the fields to change using standard bubble hacks (copy expression and paste etc., hoping the data type auto updates to grouping once you select ‘group by’ etc.) are not working.
@fayewatson @copilot any tips?

I tried it with a simple example, and it worked much the same as for grouping a list from a search.

Say for example, setting up a RG … start with the data source, grab the API data, extract the part that is a list, then group by, then the RG data type should change to Grouping.

Edit: looks like this, API result is in the RG’s parent group (pardon the pun):
image

all, I have done everything as shown in the original post but bar chart only shows last month’s data. any idea?

and below is the results (shoud’ve shown multiple months):

image

any idea?

Does it work for count instead?
Is there any entries with an empty shipping cost?

count is still showing last month.

no blank shipping cost.

Try narrow the range so there are no missing months in the selection?
Try “skip empty groups”?

Edit - Try copying the data source expression, paste it as the data source for a repeating group, and see what rows you get.

just tried repeating group and it only shows August 1,2016 12:00 AM. It’s not even showing only the month of august 2018 (without a date) like in the original post.

That formatting is a feature of the graph, in the RG it just shows the date so that bit is okay.

So either the group by is doing something weird, or the search isn’t returning what you expect. Try in the RG remove the group by, and check your search results?

repeating without group by is returning normal It lists all records.

I just submitted a bug report.

It works now for whatever reason, maybe it was a glitch in the system yesterday.

My next question is if there’s a way to create a chart with multiple grouping? I don’t see a way to add more label / series…

any thought?

Hi

How can I show the month in text. Instead of seeing 8 I see August?

Thanks

this is not working for me, i can get the category part working but when i got to expression it wont let me. i have to do extract first and its only showing 1 of everything, can you please advise.

Can we do anything with Type of Grouping per year instead of month?