I'm calculating a nb of merchants accessed per device.
So I have a column device and a measure that makes a count distinct. it works.
Then I add a column account_name, in that case the measure for each line in 1. So I did a window_sum (count distinct) computing on pane down and on every line I find the nb of account accessed per device. it works
But when I add new information like email of the account the the window_sum do not retrieve the nb of account accessed per device.
The problem is coming from the measure is not anymore computed in the right column. Is it possible to specify on window_sum function the column on which the window should apply?
Please thanks for your help!