Hi guys! Having a bit of trouble with what I thought would be a simple, common requirement.
I've got a data table that looks something like this:
Shipment Date is the date that the item was shipped, Shipment Week is Shipment Date rounded to the previous sunday. My visuals are on an itemnumber-by-itemnumber & week-by-week basis.
My red < lines show periods where entire weeks have no shipments. When I visualize this in a line graph, what I'd like is for that to show as 0, because 0 of that item shipped that week. What it does instead is it draws a continuous line from the weeks with data, like so:
So yeah, where the red v's are is where there is no shipments for that week. Naturally I'd like to see that go down to 0 rather than show a continuous line.