New column generation (USING FORMULA) based on a set of conditions

ranjith
ranjith Registered Posts: 12 ✭✭✭✭

I want to create a new column using an existing one ( A numerical field having values from 0-100)

I'd like my new column to score the values as

0-15 -> 5

16-30 ->4

31-45 ->3

46-60 -> 2

61-rest ->1

Can I use " formula" on the existing column to achieve this?

Best Answer

Answers

  • ranjith
    ranjith Registered Posts: 12 ✭✭✭✭

    I actually implemented the binning logic!

    Wasn't sure if that was the right way to go about it though.

    Thanks for the solution + reassurance. Cheers!

  • Usersyed
    Usersyed Partner, Registered Posts: 29 Partner

    Is there a way to define bins based on a different variable?
    For example if there is a data point with type as type 1 then use bins like 1-15, 15-20 etc for it and if the type is type 2 , then use bins like 1-5, 5-10 and so on?

Setup Info
    Tags
      Help me…