community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

No Data for all months

Highlighted
Asteroid

Hi All,

 

I am trying to figure out a way to ensure each month has a record regardless of there being a value or not.

 

Currently :

 

OrgFiscal YearMonthValue 1Value 2
Org 12019Jan102
Org 12019Feb37
Org 22019Jan102
Org 32019Feb202

 

As you can see, for Org 2 it has 0 for value 1 and 2 in Feb and the record is missing. similarly for Org 3 , Jan record is missing . I want to show all 12 months for each org regardless of 0 or not in the value. how do i achieve this.

 

S

Alteryx Certified Partner
Alteryx Certified Partner

Hi @sr49ers I mocked up a workflow which I think answers your question. Let me know what you think?

 

Dates_200919.PNG

Bolide

The attached workflow seems to give the correct results

 

Capture.PNG

Labels