1 of 1 people found this helpful
A blend should work well here.
I suspect the issue is that the date fields are not matching. Try changing the field type for InvDate in the secondary data source to Date (or DateTime, if that's the type in the primary).
Needless to say, all the linked fields need to match. I'm happy to provide another set of eyes if you want to send me a twbx at firstname.lastname@example.org. I'm in Europe now, so my day is over, but I'm happy to take a quick look tomorrow morning.
The extracts worked.
I think what's happening is the date / time field do not match in the
initial blend because of the time stamp.
However, if you unlink the InvDate in the secondary data source the blend
works, and then (somewhat oddly) you can reapply the link and it still
works---seems like Tableau applies the truncated date that's in the view to
both data sources.
Since you have the date fields in the view, you don't really need to have
the InvDate link. Tableau will lookup all the matches based on StoreID and
then partition the results by the dimensions in the view.
You'll run into a problem if you don't have dates in the view, but want to
filter on dates. For example, in Sheet 14, I just have a single bar and use
a date filter to show just the last 7 days. If the InvDate field is not
linked, all dates will be returned and displayed.
You could fix this second problem and perhaps make everything more robust
by creating a calculated field in each data source that truncates InvDate
to the day level and then link on this field.
DATETRUNC('day', [InvDate] )
On Thu, Jul 18, 2013 at 9:28 PM, Neal Smoller <