BigData / Tableau Interview Questions
What is the difference between a calculated field and a table calculation?
Both create derived values, but they operate at fundamentally different points in Tableau's query pipeline, which changes what each one can and can't do.
| Calculated Field | Table Calculation |
| Computed as part of the underlying query (row-level or aggregate). | Computed after the query returns, on the already-aggregated view. |
| Result doesn't depend on what else is in the view. | Result depends on the view's structure (partitioning/addressing). |
| Can be used across different views without recomputation concerns. | Tied to the specific view it's built for; moving it can change results. |
| Good for: ratios, IF/CASE logic, string/date manipulation. | Good for: rank, running total, percent of total, moving average. |
A simple diagnostic: if a calculation's correct result depends on knowing what other rows are currently visible in the view (like "what rank is this among the rows shown"), it needs to be a table calculation; if it only depends on that row's own values, a regular calculated field is the right tool.
Invest now in Acorns!!! 🚀
Join Acorns and get your $5 bonus!
Acorns is a micro-investing app that automatically invests your "spare change" from daily purchases into diversified, expert-built portfolios of ETFs. It is designed for beginners, allowing you to start investing with as little as $5. The service automates saving and investing. Disclosure: I may receive a referral bonus.
Invest now!!! Get Free equity stock (US, UK only)!
Use Robinhood app to invest in stocks. It is safe and secure. Use the Referral link to claim your free stock when you sign up!.
The Robinhood app makes it easy to trade stocks, crypto and more.
Webull! Receive free stock by signing up using the link: Webull signup.
More Related questions...
