1 of 1 people found this helpful
Whatever your primary data source is will limit what is returned from the secondary source in a blend. So if your primary source has 3 months and your secondary source has 12, you'll only see the 3 from the primary source.
You could either flip primary and secondary (start a new worksheet and make sure the first field you drop onto the view is from the quota sheet -- that will ensure it is primary.) Or you could do a three-way blend with a new dataset that is just a list of the 12 months. If you used that as your primary and the other two as secondary sources you would always have twelve months.
Thanks Joshua. I've tried flipping the primary and seconday sources earlier, but I couldn't get it to work for me. I'll see what I can do with blending three data sources and let you know if it works for me. Thanks again fro for the response
There's also turning on Show Missing Values, that will pad the data prior to the blend, here's some info on that: http://drawingwithnumbers.artisart.org/blending-using-show-missing-values/. The one thing is that Tableau will only pad out dates to the maximum date in the pane in the primary, so sometimes we need to add an extra row in the primary to give us the date.