In your data set not good one. Please add titles in first row and delete unwanted things in excel and try it. Fill the channel column and don't leave any blanks.
I have created with correct output. Create calculation for null to zero.
Drag this into text.
Count workbook.twbx 10.1 KB
Thanks for your reply.
my data look like this because it would be like this after joining 2 tables.
i can fill in the channel with
if isnull(LOOKUP( ATTR( [Channel] ),0 )) then PREVIOUS_VALUE( ATTR( [Channel] ) ) else ATTR([Channel] ) end
howerver i would like it to also based on user_id and date to determine what to fill in
or may be there is a way to count until the channel changed?