Pivot based on date

Hello!

I am new to Alteryx, and hoping to get some insight on how to pivot based on the date field. I have created a workflow that displays the following results:

However, I am hoping to achieve the following by day format:

Any help would be greatly appreciated! Thank you.

Help

Accepted answers

fmvizcaino

Hi @batwood2 ,

Since it is not an easy task to produce a doubled header, I would suggest you doing like this.

See if this is ok for you.

Best,

Fernando Vizcaino

2020-03-31 Pivot based on date.yxmd

All comments

smoskowitz

Try transposing the data and then cross tabbing back keeping the key columns you wish to use. If you can supply some data, I can try to generate a small example for you.

Thanks,

Seth

Stay safe!!

fmvizcaino

Hi @batwood2 ,

Since it is not an easy task to produce a doubled header, I would suggest you doing like this.

See if this is ok for you.

Best,

Fernando Vizcaino

2020-03-31 Pivot based on date.yxmd

batwood2

That worked perfectly! Thank you so much!

DataMeister

To All: I need the exact opposite of this! My data source is a report like the final product of this solution and I need to unravel it into a data-friendly table to feed Tableau & Spotfire visualizations. Of course the ideal is not to use reports, but their source data in the first place, but this is the funny business world we live in. Thanks for any ideas.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703