Sorted and counted rows agreggated

[Aleksandra]

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

[Manuel]

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]

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