Sort by doesn't work when I had a group by filter on the table. For example when I click on the group by device, and then sort by users it doesn't sort... but when I remove the group by filter the sorting works fine.
Also, the condition of the color set for some columns doesn't work after clicking on the 'group by' filter.
Any idea why?
Is it a bug?
Hi @R_S_I_F ,
Generally, sort and group by should work together. I also tried to reproduce the issue but was unsuccessful.
In the screenshots below, you can see that the table is grouped by Role and sorted by ID. Both the descending and ascending sorting look correct to me.
Can you share some additional context on your issue? Are you able to sort by other columns? Your screenshot also indicates that your table is currently not sorted by any column.
when the group by filter is on the sort by just doesn't work.
For example I group by date and then want to sort by Cost (currency type) it shows a date with 150$ then one with 687$ and then one with 124$.
Also, I have a margin collum with conditional coloring. and when the group by filter is on the conditional coloring stops working.
We have a feature request in our backlog for sorting grouped rows by a column outside of the grouping. I'll follow up here when it ships
+1 for this feature request
+1
My observation is that it will sort within a group, but not sort the groupings (sub-totals) by that column.
For example, I have a table of billed work with two key columns; assignee (who) and revenue ($ amount).
I group by 'assignee' to see the 'revenue' sub-totals per person, then I sort by revenue descending.
Expectation, the assignee grouping shifts around to bring whoever has billed the most revenue to the top.
Reality, grouping order stays as is (e.g. assignee alphabetically), but the individual entries within each assignee are sorted by revenue.
+1
+1
Could really do with this functionality. It makes it very challenging to layout grouped tables.
Hi Team - any update on this feature? The lack of this feature renders the grouping by functionality pretty much useless.
Welcome to the community, @ankurs! It doesn't look like this particular feature has been prioritized, but I'll bump the corresponding ticket internally and give you an update as soon as I can.
+1. This feature would be very helpful.
@Darren any update on this ?
Hi there,
Thanks for checking in! Unfortunately, since this request is still in our backlog, we're not able to estimate an eta for a fix. If that changes, we'll follow up here
