Explore Courses Blog Tutorials Interview Questions

Explore Tech Questions and Answers

Welcome to Intellipaat Community. Get your technical queries answered by top developers!

0 votes
by (2.6k points)
How can I create a Standard Deviation calculated field for Average Ratings in tableau?

1 Answer

0 votes
by (7.2k points)
edited by

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.


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.

Browse Categories