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

[ranjith]

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? 

[VinceDS · Accepted solution]

Hi, 

Yes indeed you can use Formula processor with nested 'if()' conditions to achieve your value remapping.

You can also use "Discretize (bin) Numerical values" from the processor list with a custom raw value remapping and enter your boundaries and target values.

Hope this helps

[ranjith]

 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!  🙂