Sorted and counted rows agreggated

Aleksandra
Aleksandra Registered Posts: 7 ✭✭✭
in Using Dataiku

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

Tagged:
· Share on Facebook

Answers

  • Manuel
    Manuel Alpha Tester, Dataiker Alumni, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Core Concepts, Dataiku DSS Adv Designer, Registered Posts: 193 ✭✭✭✭✭✭✭

    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

    //play.vidyard.com/8b6PrRt21Qzwmw4KnLrHgQ.html?

    I hope this helps.

    Best regards

    · Share on Facebook
  • Aleksandra
    Aleksandra Registered Posts: 7 ✭✭✭

    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

    · Share on Facebook
Bookmark this topic

Categories

Setup Info
    Tags
      Help me…