Sorting Table Widget Groups by the Highest Value Inside Each Group (Not Alphabetically)
Hi Wrike Team,
I’m trying to achieve a specific sorting behavior in a Dashboard Table widget.
I group projects by a custom field (“Object”), and then sort them by a numeric field (“Value”).
However, the Table widget only sorts within each group, while the groups themselves are always sorted alphabetically.
What I want to achieve:
Sort the entire groups based on the highest value of any project inside that group.
Example:
-
Object A
-
Project D — 10,000
-
Project C — 500
-
-
Object B
-
Project F — 2,000
-
-
Object E
-
Project A — 5,000
-
Project B — 500
-
Even though Project F (2,000) is bigger than Project C (500),
the whole Object A should appear at the top because it contains Project D (10,000) — the highest value overall.
So the expected order is:
-
Object A (max value in group = 10,000)
-
Object E (max value = 5,000)
-
Object B (max value = 2,000)
Because the groups should be sorted by the highest project value inside each group.
My questions:
-
Is there any way to sort Table widget groups by the maximum value inside each group?
-
If not, is this feature planned?
-
Are there any recommended workarounds to achieve this ranking logic in a dashboard?
This would make dashboards far more useful for prioritization and portfolio management.
Thanks!
Can you help? Answer the question and work your way towards becoming a Wrike Ninja 🥋 Sign in and answer.
Please sign in to leave a comment.