Understanding how to solve Multi-column data

[Anudeep_Yalamuru]

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

[Clifford_Coon]

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)

 

[Anudeep_Yalamuru]

 Thanks Clifford. Will try this