Sql on window functions and partial on tableau

Question

Accepted Answer

Window functions in SQL can be used for partial calculations in Tableau.

Window functions allow for calculations to be performed on a subset of data within a larger dataset.
These functions can be used in Tableau to create partial calculations, such as running totals or moving averages.
Examples of window functions include ROW_NUMBER(), RANK(), and LAG().
Partial calculations in Tableau can be created using table calculations, which can be based on window functions.
These calculations can be used to show trends or patterns in data over time or across different categories.

Interview Questions Asked to Senior Tableau Developer at Other Companies