5 Replies Latest reply on Aug 10, 2017 5:36 AM by Vincent C

# How to calculate Min,Max,Avg of  different bins

Hi All,

I have a column rfactor with range -100 to +100 with difference of 10. Which means  i have 20 columns of rfactor like shown below

rf -91 to -100rf -81 to -90 ......, rf -11 to 0rf 0 to 10 , rf 11 to 20 ....., rf 91 to 100

I know , we can calculate different max,min,avg of all bins but i want to calculate  a single min,max,avg of all rfactor bins.

Rf_11-20,Rf_21-30,Rf_31-40,Rf_41-50,Rf51-60,Rf_N51-N60,Rf_N41-N50,Rf_N31-N40

1,3,4,7,44,33,22,67

8,12,45,345,78,123,67,90

according to above data

min = 1  , max = 345 , avg = (first calculate avg  per bin then decide single avg)

Quick help will be much appreciated.

Regards,

Pinki Sharma

• ###### 1. Re: How to calculate Min,Max,Avg of  different bins

If you can Pivot your data, then it is easy to do.

• ###### 2. Re: How to calculate Min,Max,Avg of  different bins

Hi Deepak,

Could you please guide me how can i pivot data.

Regards,

Pinki

• ###### 3. Re: How to calculate Min,Max,Avg of  different bins

Hi Pinki,

Please check this one. It is Supereasy. You can Combine your Bins into 2 Columns and can easily manipulate. If you would be stuck , let me know. But, Happy Pivoting first.

Thanks

Deepak

• ###### 4. Re: How to calculate Min,Max,Avg of  different bins

Hi Deepak,

It was great to know this feature of tableau but i still no help.

The generated graph using pivot and without pivot are same.

I want to show  all bins bar and single min, max and avg for all bins.

Regards,

Pinki Sharma

• ###### 5. Re: How to calculate Min,Max,Avg of  different bins

Hi Pinki,

I'm not sure at all I've understood what you are trying to achieve. Do you want to calculate the min, max and avg for all the value, so across all bin, like this:

Or do you want to calculate min, avg and max of each bin?