1 of 1 people found this helpful
Hi Steph, in most cases, you can eventually achieve the same result with blending and joins, but the solutions where blending is viable tend to be much simpler. For instance, consider your two tables of transactions (daily) and quotas (monthly). You can join these so that all transactions in a month have the same monthly quotas, but when you want to start summing up the monthly quotas, you end up needing to do some more complicated stuff, like using LOD calculations, just to get basic values. Not only that, but someone who isn't paying attention may accidentally use duplicated data because the join is asymmetric in granularity.
Blending may also be less resource-intensive than joins if you end up with some kind of cross-join that multiplies the record count substantially.
Hey, thanks Li, this clears it up for me. i did some experimenting. I can see the effect of this in the sub-total calculations. I was under the mistaken impression that Tableau simply did an inner join internally once it received the aggregated sets form each data source - effectively causing the same duplication of higher granularity values to the lower level rows, which it does, but then happily filters them back out for the sub-totals. I was able to create the LOD calc when using the x-database join which also worked for the sub-totals, but i agree with you, just adds extra complexity for this particular example.