How Tableau Table Calculations Work
Вставка
- Опубліковано 23 лип 2024
- Connect with us:
•Upcoming Tableau Classes: www.eventbrite.com/o/onenumbe...
•Book an Office Hour with Eric: www.eventbrite.com/e/tableau-...
•Subscribe to the OneNumber Newsletter: onenumber.biz/newsletter
•Follow Eric on LinkedIn: / eric-parker-37513249
Description:
Table Calculations are a family of functions in Tableau Desktop which allow users to reference data at the aggregated, data point (mark) level. They are a powerful but often misunderstood component of the Tableau ecosphere.
Some of the most common applications of Table Calculations include calculating Percent of Total, Percent Difference and Rank.
Table Calculations differ from standard calculations in a number of key ways. First, standard calculations typically create a new column of data in the data source. Table Calculations do not. Table Calculations are flexible and their application is specific to the worksheet they are used on and what dimensions are used in that sheet.
When using Table Calculations, you also have the ability as a user to set a Scope (Table, Pane, Cell) and Direction (Across, Down, etc.). Scope and Direction allow you to answer the question, "How do I want this Table Calculation to compute?" For example, if you have two dimensions (State and City) and one measure (Sales) and want to calculate a percent of total, you have two main options.
Option 1: Calculate the percent of total across all cities/states so the entire worksheet adds up to 100%.
Option 2: Calculate the percent of total where each state is the scope so each state adds up to 100%.
The more dimensions in the view, the more options you have available.
Want to master the basics of Table Calculations? Check out this in-depth video to better understand what they are, how they work, and how they can help you!
Resources:
•Tableau Public Workbook: public.tableau.com/app/profil...
•Table Calculation Errors: onenumber.biz/blog-1/2019/8/1...
•Table Calculations - Specific Dimensions: onenumber.biz/blog-1/2018/1/1...
•Highlighting Points in a Line Graph (RANK): onenumber.biz/blog-1/2017/10/...
Chapters:
0:00 Table Calcs Background
3:03 WINDOW_AVG Example
5:50 How Filters Affect Table Calcs
8:00 Percent of Total Example (Scope & Direction)
16:11 Percent Difference Example
22:28 Table Calcs and Aggregations
Great session for table calculation! Thanks a lot!
Absolutely, we're so glad you found it helpful!
Eric, great tutorial. I'm now playing with these and know what's going on.
I have always shy'd away from table calcs, claiming that solid calcs were 'more stable'. The truth was that I don't use them in order to understand how they work. As I worked along with your video, I began to realise that the yellow highlighting and [#] numbers actually show you what effect each table selection has on the various selections which makes understanding where and how to use them so much more intuitive.
We're so glad you are finding it useful! That was exactly our hope in creating this!
Learning so much from your videos
We are so glad to hear that!
Need help with your Table Calculations? Schedule an hour with Eric here: www.eventbrite.com/e/tableau-office-hours-with-eric-parker-tickets-42691995909
Ready to master Tableau? Check out our lineup of upcoming classes! www.eventbrite.com/o/onenumber-15678294163
Hi sir
Visibility is very low due to this unable to read and view what are the options you are choosing and clicking in tableau worksheet
It looks okay to me. Are you talking about a specific point in the video? Can you try and make the UA-cam video full screen so you can see better?
@@onenumbertableau sir after open the vedio and watching at worksheet level for example @ 7minutes we are not see clearly which option you click what are the dimensions and measures in row and columns we can't see.
Sir plz excuse me if iam wrong.
Just little bit zoom required.
Zoom required