From the course: Tableau: Mastering Calculations
Unlock this course with a free trial
Join today to access over 25,300 courses taught by industry experts.
What are table calculations? - Tableau Tutorial
From the course: Tableau: Mastering Calculations
What are table calculations?
We have already learned about many different calculation functions in the previous chapters, but there are some calculations that you don't necessarily have to write yourself, so-called table calculations. Contrary to what the name suggests, table calculations work not only in tables but in all visualization types. The name comes from the query cycle. The query cycle describes what happens in the background when we drag a field into the view in Tableau. Tableau formulates a query in its own language called VizQL, which a driver translates into the language of our database. The database then processes the query and returns a table of values that Tableau formats as we specified in the view, so that we can see our chart. And this is how table calculations got their name, because they do not send a query to the database. Instead, Tableau uses the table of query results that we already got back from the database and puts another…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
-
-
(Locked)
What are table calculations?2m 33s
-
(Locked)
Running total1m 42s
-
(Locked)
Absolute and relative differences1m 42s
-
(Locked)
Direction in table calculations2m 19s
-
(Locked)
Percent of total3m 6s
-
(Locked)
Rank and types of rank4m 41s
-
(Locked)
Filtering table calculations correctly5m 48s
-
(Locked)
Combining table calculations and aggregated calculations2m 53s
-
(Locked)
Nesting table calculations4m 39s
-
(Locked)
Challenge: Table calculations1m 12s
-
(Locked)
Solution: Table calculations2m 47s
-
(Locked)
-
-