How can I create a Standard Deviation calculated field for Average Ratings in tableau?

Question

1 Answer

Krishna Singh · Answer 1 · 2021-02-12T11:16:30+0000

While the calculated field has aggregation inside,

Tableau doesn't let you aggregate it again.

So, If you may try using window aggregation, you need to use such as window_Avg.

EXAMPLE:

First Calculation: Profit Ratio

sum([profit])/sum([Sales]) //Aggregate Calculation

Second Calculation: Avg of Profit Ratio

window_avg([Profit Ratio]) //Table Calculation

Get trained to use Tableau with full potential through Tableau Online Training.