Related list - display uniques / group by field

[Wojciech_Redman]

I’m trying to find a way to group those rows by 1st two columns
(those should have only unique values) and last 3 columns should display sum of those…

Could anyone help me to achive that?

[1minManager]

Maybe if you show us an example of the data and how you want it to look, that might help

[Wojciech_Redman]

Sure, I’ve just updated uploaded picture in my 1st post.

[1minManager]

Send me a screen shot of the columns you have in the SPAKOWANO table

[Wojciech_Redman]

[1minManager]

Create a virtual Yes/No columm called [Unique] in SPAKOWANO with this formula

[_RowNumber]=MAX(Select(SPAKOWANO[_RowNumber],[Nazwa SPECYFIKACJI]=[_ThisRow].[Nazwa SPECYFIKACJI]))

Then change your start expression to

<<START: Select([SPAKOWANOs][ID],[Unique]=TRUE)>>

That should get column 1 correct

[Wojciech_Redman]

Thank you for helping me with this!

I had this:

I’ve created virtual column called [Unique] in SPAKOWANO with this formula:

[_RowNumber]=MAX(Select(SPAKOWANO[_RowNumber],[Nazwa SPECYFIKACJI]=[_ThisRow].[Nazwa SPECYFIKACJI]))

Then I’ve changed
<<Start: [Related SPAKOWANOs] >>

to
<<START: Select([Related SPAKOWANOs][ID],[Unique]=TRUE)>>

Now it looks:

Something happend, but many of those are still missing.

[1minManager]

Send a screen shot of both the template file and the whole table for the example above with 12 rows of data. Its hard to understand which columns your trying to group by

[Wojciech_Redman]

And after changes:

I’m trying to group by [DPL] but number values from last 3 columns (Worków / Palet / kg ) should consolidate.

I’ve made something like this in app view, it shows grouped DPL’s:

Automation is triggered from diffrent table “WYNIKI PRODUKCJI”, whom SPAKOWANO is related to.

[Wojciech_Redman]

Any ideas?

[Steve]

Single category headers in workflow templates for multiple records of same category Tips & Tricks 💡

Outer <<Start>> tag: <<Start: ORDERBY(FILTER("table", ([_ROWNUMBER] = MIN(SELECT(table[_ROWNUMBER], ([_THISROW-1].[category] = [category]))))), [category])>> Inner <<Start>> tag: <<Start: FILTER("table", ([_THISROW-1].[category] = [category]))>>

Issue with embedding templates Questions

corresponding employees: ORDERBY( FILTER( "log", ( [_ROWNUMBER] = MAX( SELECT( log[_ROWNUMBER], AND( ([employee] = [_THISROW-1].[employee]), ([date] >= [_THISROW].[start date]), ([date] <= [_THISROW].[end date]) ) ) ) ) ), [employee] ) corresponding logs: ORDERBY( FILTER( "log", AND( ([date] >= [_THISROW].[start date]), ([date] <= [_THISROW].[end date]) …

Report Expressions for Grouping and Sorting Data Questions

I’d posted a reply yesterday (since deleted) saying: As I understand it (I don’t work with reports much), there’s no automatic way to group data in reports: you’d have to do it manually. But as I though about it, I couldn’t get passed the feeling there is a way to do it. After some tinkering, I found it! It’s not trivial–in fact, I’d call it expert-level stuff. This is the <<Start>> tag to group by agent: <<Start: ORDERBY(FILTER("All Data", ([Row Key] = MAXROW("All Data", "_ROWNUMBER", (…