What you're trying to achieve is
just one (nested table calculation) step away.
Please take a look at the addressing of these table calcs.
Since they're nested ones, both the inner and the outer calc
have its own addressing / partitioning (Compute along).
And don't remove Salesforce Account Id from a view --
the table calculations depend on it for addressing.
Please find the attached.
Hope it could help.
churn example_YF.twbx 56.2 KB
Thank you so much Yuriy!
This problem had been bothering me for a while now.
Just one thing, is there any other way around the first()==0?
Each of your inner calculation is a Table Calc itself.
And it is addressing along Date dimension.
My (outer) calcs are addressing along Salesforce ID,
so one outta have this dimension in Details
and calculate the same result for each Salesforce ID
for a particular Date -- that's why the first()==0 filter
(Compute along Salesforce ID).
Hope this could help to clarify.