Tuesday, June 20, 2017

Displaying Standard Error with Average in Tableau

Lately I was struggling with displaying bars displaying average response along with standard deviation on them. Finally I found a way to show it!

Lets first create a standard bar chart as shown above with Average response. Now add Standard error calculation 


Now create two calculated fields : Average plus standard error and Average minus standard error  as below:


Now add these two calculated fields in Marks section and create a calculated field for count of responses and add it in the marks section as well.
Now Click on SHOW ME option on the right and select Bullet Graphs

Then change the chart drop down in marks section to Bar again


Now right click on the grey area in the chart and click on edit





Change the style to Band and in Band from add : Avg -  Std Error and Band to : Avg + Std Error

Then select Label on count field in Marks section. 




Once you complete these steps you should see something as below: 




You can change color or do formatting changes as you wish!