Putting week data into a chart by where one year has 53 weeks and another has 52 weeks

Hello,
We have a capsule which shows a chart with data by week. Because 2020 had 53 weeks and 2019 had 52 the chart shows zero for the corresponding week in 2019. Our user in her previous Excel report would go back 52 weeks for the comparison to avoid this problem. Is there a way to do this in Board. Currently we are using the Previous Year function as shown. I have tried other things here to the chart does not change. Any suggestions?
Thank you,
Pete

Showing week 53 for 2020 when previous year has no week 53

------------------------------
Peter DeGregorio
Senior Technical Project Leader
ITW Global Brands
United States
------------------------------

Find more posts tagged with

Accepted answers

All comments

Leone Scaburri

Hi Peter,

you can use the Advanced Options "Hide zeros" to avoid the empty week.

Regards,
Leone

------------------------------
Leone Scaburri
Consultant
Board Community
Switzerland
------------------------------
-------------------------------------------

Peter DeGregorio

Thanks so much for the useful solution! It works great!

------------------------------
Peter DeGregorio
Senior Technical Project Leader
ITW Global Brands
United States
------------------------------
-------------------------------------------