Scaffolding missing dates

[RKGV]

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 ?

[gabrielvilella · Accepted solution]

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]

Thanks