
1. Re: Aggregation by Sum and Count
Andrew Watson Sep 1, 2016 5:10 AM (in response to Subha Yoganandan)1 of 1 people found this helpfulYour SUM is a window_sum currently and your COUNT is just a standard count. Change your count formula to be a window_sum and it'll work. Try this formula: WINDOW_SUM(SUM([Number of Records]))

2. Re: Aggregation by Sum and Count
Subha Yoganandan Sep 1, 2016 6:39 AM (in response to Andrew Watson)Thanks for the quick reply. I got the answer I was looking for
I was using WINDOW_COUNT instead of WINDOW_SUM and so it didn't work. I am curious as to why WINDOW_SUM works when I am just looking for the "count" of the number of records?
I have done similar things in R,SQL but being a tableaunewbie I found it confusing that the command SUM works to calculate the actual COUNT.

3. Re: Aggregation by Sum and Count
Andrew Watson Sep 1, 2016 6:59 AM (in response to Subha Yoganandan)1 of 1 people found this helpfulCounting the number of records is the same as summing the number of records. The number of records is just a 1 against each record so summing this is exactly the same as counting.
Sent from Samsung Mobile