1 Reply Latest reply on Jul 31, 2018 9:45 PM by Zhouyi Zhang

    How to calculate the average, standard deviation, min, max and cov of summed value

    Alex Zhao

      Hi,

       

      I am new to Tableau. Not sure how to calculate the average, standard deviation, min, max and cov based on the summary table categorised by Did in Sheet 1, not the entire raw data source.

       

      I looked at some online examples and follow them to create a calculation field (avg of sum flow by did) to get the average, however, it is not working due to 'unknown countd function called'.

       

      Not sure how to calculate the rest (standard deviation, min, max and cov of summed value by did).

       

      Please find the attached .twbx file.

       

      Thanks for the help.