Hi,
I have a question related to keeping a running total and then moving that running total to a new column called 'Most consecutive days' and I am not sure if I need to do this in a beast mode or MagicETL
Is there a way to, for example, product A sold for 10 days in a row, didnt sell a day then sold for 3 days in a row etc…. I would like to create table that shows product A and has the column names 'Current Consecutive Days' and then another column called 'Most consecutive days' and if the current consecutive days exceed 'Most consecutive days' then the new 'Most consecutive days' number is replaced by the 'Current Consecutive days' number.
Thanks in advance