Help guides · Your data
Missing values and days without sales
Rows missing a date, quantity or product are left out; days without sales count as zero.
Empty cells and placeholders like n/a or - are ignored. Rows missing a date, quantity or product are left out and you see how many. If more than 5% of rows are unusable, fix the file first.
Days without sales count as zero. If you were closed or out of stock, real demand was higher: add closures to your Calendar so they're left out.