1 Reply Latest reply on Mar 20, 2016 5:07 PM by Bill Lyons

    Create variable size bin in tableau

    utkarsh bhardwaj

      I have a set of data in which i want to categorize based on a particular field into three groups which are small, medium and large.

      i have two rows in the data, accountnumber and amount. One account number can come more than one time.

      i have to find all the unique account numbers and there sum of amount.

      then based on that i have to display the number of account in small, medium and large group.

      the problem where i am facing is that , i have to create the groups based on a certain formula.i.e in the small group i will be having the number of account number which are having the amount less than the mean. medium group will have from mean to 2* standard deviation. while all rest will be in three.