Forum Discussion
How to create range column..
Hi All, Is there any way to create range column like this -10-5, -5-0, 0-5 etc automatic. I have one column which is start from -10 and highest value is 1000 i need to increments by 5 on it. Any ...
Anonymous , Generate a series and then create a text column on that
new table=
addcolumns(generateseries(-10, 1000, 5) , "end value", [Value] +5 , "Bucket", [Value] &" - " & "Value"+5)
amitchandak Thanks for your reply, i created a new table with bucket column but now how can i use this table with the actual data table i need to count the number between this range.
New Table
Main Data Table
And i want to count (Count Column) the values between this bucket which is given in the main data table.