Forum Discussion
Custom column based on same column values
how to create Custom column based on same column values using between operator ??
example:i have a column with values range from 0 to 10..i wanted to create custom column based on the condition.(ie).0-5 as custom column and 5 -10 as other custom column..
If I understand this right you may be overthinking this.
Just a simple if statement would do.
You may have to change this a bit but here it is depending on where you want the 5 included
Custom Column = IF ( Table[Column] < 6, "0-5", "6-10" )
Good Luck! :smileyhappy:
I would do a conditional column in query editor based on the logic above. If less than or equal to 6 then... etc.
3 Replies
I would do a conditional column in query editor based on the logic above. If less than or equal to 6 then... etc.
Yes that works too! In fact that’s what I would do too! :smileyhappy:
If I understand this right you may be overthinking this.
Just a simple if statement would do.
You may have to change this a bit but here it is depending on where you want the 5 included
Custom Column = IF ( Table[Column] < 6, "0-5", "6-10" )
Good Luck! :smileyhappy: