In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Scaffolding missing dates

RKGV
7 - Meteor

Hi Experts,

 

I have a list of error identified date for products. I am creating a bar chart maping Months in X axis and affected products in Y axis and also calculating avg line per year ( total products affected / available months for that year).

 

I am able to add dates from first date til last date but I dont want all date. I just need 1 date in the missing months. Just to display month in the graph with value 0 and use the count of month for Average calculation.

 

I want to replace null (Product column ) with 0 because I dont want to count those values.

 

Can someonehelp ?

2 REPLIES 2
gabrielvilella
14 - Magnetar

You shared the workflow, but not the dataset. If you don't need all the days, try adding a month to the date rather the a day. You can use this formula to replace nulls with zeros: IF IsNull([FieldName]) THEN 0 ELSE [FieldName] ENDIF.

RKGV
7 - Meteor

Thanks

Labels
Top Solution Authors