Hello! I have a view with a line chart showing SUM(Open PO Quantity) by WEEK(Planned Delivery Week). Right now, week 1, 2021 shows a zero amount between week 53, 2020 and week 2, 2021, which both show values. Any idea what could be causing this?

I have a similar problem, and it has to do with using the week function on the week begin date of last week of the year. For example in 2019/2020 transition week, the Gregorian calendar treats the week beginning 12/29/2019 as week 53, but the following week (beginning 1/5/2020) as week 2 because technically week 1 is hidden as it begins in the middle of the week (1/1/2020 - 1/4/2020). The ISO-WEEK calendar is intended to correct for it by only allowing 7 day weeks, but ISO weeks start on Mondays and most companies weeks begin on Sundays. I don’t have a solution but zero null is probably not the only reason that can happen.