
1. Re: Normal function vs Window Function
Lauren Bearden Feb 11, 2016 4:22 AM (in response to Rahul Panday)4 of 4 people found this helpfulHi Rahul,
A regular aggregation (like sum or average) will take the aggregation of all the rows in your data source. If you have 3 rows, Tableau will simply take the average of those 3 rows.
Now, let's say you have a more advanced problem. You want to find the average of the sum of certain categories (2 pass aggregation, or an aggregation based on an aggregate). This is where you could use a function like WINDOW_AVG. The window functions will take into account only what's in the view, and aggregate based on those number. This comes in handy when you have something like the sum of sales for a certain dimension, but then want to find the average sales across the dimension. You could use a WINDOW_AVG.
You can read more about window calculations if you scroll down in this page. You can read more about other ways to do two pass aggregation here.

2. Re: Normal function vs Window Function
Steve Martin Feb 11, 2016 5:02 AM (in response to Rahul Panday)1 of 1 people found this helpfulHi Rahul,
In addition to Lauren's response I just wanted to clarify her point of: "will take the aggregation of all the rows in your data source" This means your filtered datasource so if you have specific calculations or filtering in place, then the regular aggregation will run against the final filtered set.
Steve

3. Re: Normal function vs Window Function
Rahul Panday Feb 11, 2016 11:25 PM (in response to Lauren Bearden)Thank you Michael ...it helped to understand .
On Thu, Feb 11, 2016 at 6:36 PM, Michael Hesser <