Athlete data: a single row per athlete |
Stuff to buy data: note there is no column mentioning athlete |
Next, after bringing in both data sets into Tableau, I created a cross dataset calculated field on the 'Stuff to Purchase' dataset that would allow me to filter out when the number of items exceeded the athletes pay.
running_sum(sum([Cost]))<=sum([Forbes 100 Athletes].[Pay $]) |
Finally, I added
- RowID into the details
- 'How Many' true false filter to the filter section
- IMPORTANT: Change the 'Compute Using' to use RowID
- Add the purchase category and item to the filter section
- Added the object's description to shape
- Filtered it for the specified athlete (from the secondary source).
- This ultimately ended up being a quick filter that allowed me to select different athletes
Now I had my sheet that showed each of the items that the person could buy.
- RowID into the details
- 'How Many' true false filter to the filter section
- IMPORTANT: Change the 'Compute Using' to use RowID
- Add the purchase category and item to the filter section
- Added the object's description to shape
- Filtered it for the specified athlete (from the secondary source).
- This ultimately ended up being a quick filter that allowed me to select different athletes
Now I had my sheet that showed each of the items that the person could buy.
If I had joined them ahead of time, I would have had a Cartesian product of over 160,000 rows! This not only saved me data space, but also cut down on the data prep I needed to get dashboard built.
So the answer all along (to the question that was never asked) was yes, it will blend...even if there are no common dimensions. Let me know if you have any other questions and feel free to comment. Thank you!