Putting week data into a chart by where one year has 53 weeks and another has 52 weeks
Peter DeGregorio
Customer
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
------------------------------
Peter DeGregorio
Senior Technical Project Leader
ITW Global Brands
United States
------------------------------
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
------------------------------
Peter DeGregorio
Senior Technical Project Leader
ITW Global Brands
United States
------------------------------
0
Answers
-
Hi Peter,
you can use the Advanced Options "Hide zeros" to avoid the empty week.
Regards,
Leone
------------------------------
Leone Scaburri
Consultant
Board Community
Switzerland
------------------------------
-------------------------------------------0 -
Thanks so much for the useful solution! It works great!
------------------------------
Peter DeGregorio
Senior Technical Project Leader
ITW Global Brands
United States
------------------------------
-------------------------------------------1
