A weird bug I think.
I can group by Year and then State:
But not State then Year:
Thanks Alexi. Got quickly excited about the new stuff and forget about managing expectations.
2 features so far I would like to see in grouping:
Hi Retool team,
Just to clarify there isn't a built-in feature at the moment where I can have all the groups expanded by default or even expanded per group?
@Kabirdas thanks for the clarification, please keep me updated when this is implemented, thanks.
Daniel
Hi @yiga2! Just wanted to follow up and let you know that we've officially launched aggregation. You can read about it here.
@andoliveyou - Do we have a way to sort our data by an aggregated value? Or to at least to Group by one term, and then sort it by an associated value?
@skyler, unfortunately, there is no way to sort by aggregated value at this time. I don't think I understand what you mean by "Or to at least to Group by one term, and then sort it by an associated value?" Can you give an example?
@andoliveyou, thanks for letting me know. Hopefully sorting (and nested sorting for that matter) by aggregated values is something we'll see in the future.
Regarding the Group by one term (or value) and then sort it by an associated value question. In the primary table, we (and all our customers) use, we have a calculated aggregated value that we sort by.
e.g., we have
Every variant belongs to a Section and the Section Volume is the aggregated value of the Variant Volume for all Variants in the Section. The data is sorted using nested filters to keep everything grouped together. With the first sort being by Section Volume.
Hope that made sense.
Here with an update - @Alexi shipped the following update in the latest Cloud release, 3.25.0, to add the option "Expand grouped rows by default."
We're still tracking requests for more customization on expanding groups, but hopefully this helps for the time being!
Hey @bradlymathews ! quick question... did you find a solution for the repeated values on the grouped columns? I´m experiecing the same issue and cant find the solution!
Thanks!
They added this to the component, so the grouped row now stays visible along with it aggregate values.
Any update on the option for end users to configure groups (with a button or programmatically)?
Sorry, neglected to update here!
Now live on cloud we have support for:
setGrouping
API. Example usages:table1.setGrouping('role')
table1.setGrouping(['role', 'enabled'])
table1.setGrouping({ columnId: 'role', sortDirection: 'desc' })
table1.setGrouping([{ columnId: 'role', sortDirection: 'asc' }, { columnId: 'enabled', sortDirection: 'desc' }])
Happy building!
HI,
Very good work.
Thanks