Challenge #221: Avocado Consumption

[OllieClarke]

Here's my solution:

Spoiler

[JKCecil]

A solution by a newbie. Output on target. What more could I want? Well, since you asked, it'd be great to solve these in what I consider an efficient time period. Maybe next time. Still had fun though.

[mbens123]

Spoiler

9 Union tools, new record for me;)  Fun exercise.

[Sudha8990AI]

Very interesting used normal workflow to get the end result. But we would have created a batch macro and with an analytical application which will be more challenging and fun.

[AnaisComyn]

Done ! 

[vpl1611]

Here's my solution.

Spoiler

[huynv96]

Thanks

Spoiler

[kelly_gilbert]

Another good reshaping challenge! I always have my production hat on, so I tried to make this as dynamic as possible (it will calculate the difference between the last/first available month in the dataset and it could handle new PLUs).

I feel like I haven't developed an elegant way to handle crosstab column names that contain special characters (e.g. %), because non-word characters get converted to underscores. In this case, you know that the underscore is always a % (so you could just use dynamic rename and replace "_" with "%").

Edited to add idea here: https://community.alteryx.com/t5/Alteryx-Designer-Ideas/Retain-special-characters-in-crosstab-column...

Spoiler

[kelvin_law1]

Here is my solution:

Spoiler

[mbogusz]

Spoiler