1 of 1 people found this helpful
Sheets don't contain data in Tableau like in Excel.
You can potentially recreate your total users calculation using Level of Detail. Can you please upload a Tableau Packaged Workbook?
Hi Tom! Thanks for the response! Unfortunately, I'm not working with data that can be uploaded to the internet. Would you be able to point me in the right direction if I gave a simplified example?
Sheet 2 (Directory)
How would I make a table that displayed that course CR001 has 40% (2/5) registration and course CR002 has 20% (1/5) registration. Currently, I am only able to blend the 2 data sets to show that CR001 has a 67% (2/3) registration and CR002 has a 33% (1/3) registration.
Thanks again for the speedy reply!!! I'm already looking into the level of detail function in Tableau to see if there is anything that can help me.
You can definitely make a sample file in Excel or similar and create a Tableau Packaged Workbook based on that.
Like I said, sheet's in Tableau don't contain data, data sources do. Create a sample and I'll take a look.
Is this ok? The main point is that I potentially have more people in the "Directory" dataset than in the "Courses" dataset and I want to be able to show a table calculation that utilizes both.
And once again, thanks for the help!
When you connect to data source in tableau, if you are using an excel spreadsheet with multiple worksheets, pull in all the relevant sheets. Tableau will automatically join the data using the common fields. In your worksheet, you can create the fixed calculations.
Does this help?