1 of 1 people found this helpful
Dear Hub Yoo,
I think I had a similar problem before and the solution is more likely that you will need to create a 3rd date field that is neutral. As you suspect, if you based Order Date as your column field, for days when there has been a shipment but no order made, the data will not be displayed. I had a similar issue when I was trying to create a visualization for a Project Plan chart and worked around the requirement by doing a neutral date field.
Thank you for your reply! Unfortunately, that option did not work for me, or I don't know how to do it. Do you have a sample workbook you can post that I can look at to try to understand date linking?
Siraj pointed me inthe right direction.
What I did was to change the [Ship_Date] into a months calculation by using datepart('month',[Ship_Date]) and did the same for [Order_Date]. Then using a neutral date field works, or using an excel sheet that i made containing just dates.