Understanding how to solve Multi-column data

Question

Hi All,

A small interesting one for Friday.

I have a data containing if a member shopped during certain weeks. (1 for Yes, 0 for No)

I want to understand if the member is loyal/recurring by understanding if he shops once every 3 weeks, or occasional (once every 5 weeks) or Rare ( 6weeks or more between two appearances).

Would be very helpful if I can solve this on Alteryx as we have similar analysis to run most of the time.

Attached is how the table looks.

Thanks,

Anudeep

Test_Continuity.PNG

Anudeep_Yalamuru · Answer

Thanks Clifford. Will try this

Clifford_Coon · Answer

Hi @Anudeep_Yalamuru

Here is a direction I would go for this:

First Make the data vertical using a transpose tool.

Then use some multi-row formulas looking back 3 weeks, 5 weeks, and 6 weeks.

Something like:

(Not a complete solution, but a direction)

Multi-Column_to_Rows.yxmd