Forum

Notifications
Clear all

Displaying items with no data and displaying "0" for empty cells - 12 month rolling trend chart

2 Posts
2 Users
0 Reactions
101 Views
(@ivokarlovic71)
Posts: 1
New Member
Topic starter
 

My 12-month trend chart from Nov 2020 to Oct 2021 displays trend from Jan 2020 to Dec 2021 (24 months) when "Show items with no data" and For empty cells show "0" are enabled. Please see the attached sample chart. How can I display only the trend from Nov 2020 to Oct 2021?

Thank you in advance!

 
Posted : 13/11/2021 12:09 am
(@mynda)
Posts: 4762
Member Admin
 

Hi Lavan,

Welcome to our forum!

It's not clear why  you need Show Items with No Data turned on. It seems pointless to display November and December 2021 in your chart when there is no data for those periods yet.

If you want to force these periods, then you'll need to add rows to your source data for those dates with zeros for each product. When you get actual data for those periods you can remove the zero value rows.

Mynda

 
Posted : 13/11/2021 5:04 am
Share: