Sorted and counted rows agreggated

Aleksandra
Level 2
Sorted and counted rows agreggated

Hi all,

I have table with data (example): Group name, Region, Value (number of something). For future calculatons i need to add column with counter of rows (1 to N) in each group, where #1 will be the biggest condition of Value and N is lowest.

Does anybody know how i can do that?

Thanks!


Operating system used: Windows

0 Kudos
2 Replies
Manuel
Dataiker Alumni

Hi,

You should use the Group recipe, which allows you to identify the aggregation keys and metrics, such as min and max of columns.

See this concept video

 

I hope this helps.

Best regards

Aleksandra
Level 2
Author

Hi Manuel,

I already tried it, but may be have mistake during setting. Thanks a lot for video, I will try again!

Best regards, Aleksandra

0 Kudos