Summarize Date coming back as Nulls

Karl_Spratt

Hi Community,

I'm trying to create a pivot view in Alteryx  but in the Summarize tool the Date coming back as Nulls

I have created this formula to add a column to change the created date into a Monthly date  formula is:

Datetimeformat([Created date], '%B-%Y')

Attaching pictures of what Im seeing ca some explain the issue please.

TIA,

Karl. 

1.PNG

2.PNG

atcodedog05

Hi @Karl_Spratt 

Use a filter tool and filter the row out like below.

Workflow:

Hope this helps : )

SIM2_BookingsWith Frame.yxmd