Forum Discussion
Solved
Group by specific condition
Hello, I have a table that I'd like to group by with a specific condition, the condition is : each time there is a 1 in a colum I'd like to group until there is another 1 in the same column. (Not...
In the query editor just add an index column first. Then multiply that with Type. Replace 0 by null and fill down values.
That will allocate the same number to each row in the group but a different number per group.
