Hi,
I m trying to make Weighted Sum on certain field.
It has to be in 12 months window size (ex, On 2023-02, it is the sum of 2022-03 ~ 2023-02).
And, each value of the month is multiplied by index (like 1, 2, 3 ... 12)
So, the formula looks like,
For i = 1 ~ 12, Σ i * Xi (Xi is the value of the month)
I tried window_sum and running_sum ... but it didn't make the result i want...
Thanks in advance!
1 answer
weighted averages can be calculated in 2 ways - see https://jimdehner.com/2020/05/12/faq-series-weighted-averages/ I always recommend the LOD method - it totals and subtotals correctly
Thanks
Jim - Tableau Visionary