Example for Alteryx Forum.xlsx|||`Sheet1$`
False
1
Example for Alteryx Forum.xlsx
Table=`Sheet1$`
User_ID - Ascending
Date - Ascending
User_ID
Avg Calls Before an Appointment
Int32
4
Empty
if [Flag]=1 then [Row-1:Avg Calls Before an Appointment]
elseif [Row-1:Flag]=1 then 1
else [Row-1:Avg Calls Before an Appointment]+1
endif
if [Flag]=1 then [Row-1:Avg Calls Before an Appointment]
else...
Avg Calls Before an Appointment = if [Flag]=1 then [Avg Calls Before an Appointm...
Date - Ascending
RunTot_Avg Calls Before an Appointment = if [RunTot_Flag]=0 then 0 else
[RunTot_...
Horizontal
solution