1 of 1 people found this helpful
Ah blending.. short answer: if they're in the same datasource just join them. You'll save yourself this sort of grief.
Having had a play, I think you'll need to join anyway. You can't aggregate up blended data in the way you want. You can see in the changes I did you can get it to show a bar. However, because you're blending you have to have essentially the level of detail at the join (and you can aggregate no more). So, you can sort of get it to look like it but you can't do further calcs on it.
Thank you for the time of investigation. After running a couple of more tests in Tableau, it looks like I'll be working with much larger data tables to accomodate zero error writing. Drat, but I'm in agreement.
It would have been a great data blend feature.