-
1. Re: Selecting Fund/Benchmark Pair
Cathy Bridges Nov 2, 2018 5:03 PM (in response to Mitchell Tappan)I would put your funds worksheet and your benchmarks worksheet side by side on a dashboard as in attached.
You can't join or blend the two files, because you don't have a common field to blend on.
-
Benchmark_TestCompare.twbx 34.8 KB
-
-
2. Re: Selecting Fund/Benchmark Pair
Jennifer VonHagel Nov 2, 2018 10:22 PM (in response to Mitchell Tappan)Hi Mitchell,
Another idea is to union your two data sets. You seem to have the exact same metrics for each.
1. Put your two data sources off on their own in their own folder:
2. Go to Data > New Data Source > More > Navigate to the folder you created and choose one of the files
3. Drag "New Union" underneath the Funds pill and drop when it says "Drag table to union".
4. In the dialog box, go to Wildcard, and clear the Matching pattern for Sheets and Workbooks to both be blank. This will automatically union all the files in the Test folder created.
5. And voila - you have your data in one table. When you union datasets, Tableau will add a Path and Sheet column. In the Sheet column, so we already have a differentiator of Benchmarks and Funds to be used.
You could go a few different ways with this now. I quickly created the following parameters and calculations:
6. Create a Choose Benchmark parameter. Make the values equal the text in F1 perfectly. You can use Add from Field on the lower right, and then delete the funds leaving only benchmarks (except you probably have hundreds or thousands of funds).
7. Create a Choose Fund(s) calculation. Add the calculation as a filter to your worksheet, and the Choose Benchmark parameter as well.
IF [Sheet] = 'Funds' THEN [F1]
ELSE 'Show Benchmark'
END
8. Set up your worksheet.
9. And finally, add a filter so that only one Benchmark will ever show - the one selected in the parameter.
[Sheet] = 'Funds' OR [F1] = [Choose Benchmark]
This is one way to go about it; I hope it gets you started.
Best,
Jennifer
-
Benchmark_Test.twbx 28.5 KB
-