-
1. Re: Totals of Totals
Deepak RaiSep 4, 2018 5:12 PM (in response to morton hsiao)
How are you expecting -135 and where?
-
2. Re: Totals of Totals
morton hsiao Sep 4, 2018 8:05 PM (in response to Deepak Rai)I did this quickly, sorry, I actually meant -225 everywhere 15-240. Sorry, I'm actually having an even bigger problem connecting to postgres views. The tables are fine, views, not so much.
-
3. Re: Totals of Totals
morton hsiao Sep 5, 2018 10:45 AM (in response to morton hsiao)No, solved the view issue. Still haven't solve the functions on table functions
-
4. Re: Totals of Totals
morton hsiao Sep 5, 2018 1:00 PM (in response to morton hsiao)Holy good gravy! I must be the only one in America with these questions. Anyway, I found the solution. It is the realization that a table function of a table function are called nested table functions and when you have a table function of table functions, the "direction" of the inside table function has to be set on the outside table function
I have this:
total_delta = [total_actual] - [total_bc]
total_actual = total(sum(actual))
total_bc = total(sum(bc))
BUT if you put total_delta in the table with total_actual and total_bc, the computer does not look at the total_actual and total_bc values in table to calculate delta like it would a window function. It's like DAX. It recalculates total_delta from scratch even after it calculated total_actual and total_bc elsewhere in the table. Thus, you must set the directoin of both total_actual and total_bc individually here:
It used to be that words mean something, but in tableau, apparently variables do not. These aren't really variables, they're labels for underlying calculations. Stil
-
5. Re: Totals of Totals
Deepak RaiSep 5, 2018 1:15 PM (in response to morton hsiao)
I was getting -225 , but you said -135 so I asked you that question earlier. But anyway, you got the answer through your efforts.