
1. Re: Histograms: creating bins based on mean and standard deviation
Tracy Rodgers Oct 29, 2013 10:51 AM (in response to Florencia Curto)Hi Flo,
Sorry for the delay in receiving a response! It's hard to tell what the issue is without seeing the workbook. However, the error mentioned is addressed in this KB article:
Resolving "Cannot mix aggregate and nonaggregate arguments" Calculation Error  Tableau Software
Tracy

2. Re: Histograms: creating bins based on mean and standard deviation
Ramon Martinez Oct 29, 2013 11:15 AM (in response to Florencia Curto)Hi Florencia,
Try this formula for the Calculated field: Bin of Score
If SUM([Score]) < [MEAN]+[STDDEV]*3 then 1
ElseIf SUM([Score]) < [MEAN]+[STDDEV]*2 then 2
ElseIf SUM([Score]) < [MEAN]+[STDDEV]*1 then 3
ElseIf SUM([Score]) < [MEAN]+[STDDEV]*0 then 4
ElseIf SUM([Score]) < [MEAN]+[STDDEV]*1 then 5
ElseIf SUM([Score]) < [MEAN]+[STDDEV]*2 then 6
Else 7
End
Define Bin of Score as Discrete
Drag Bin of Score to Column shelf and Number of Records to Row Shelf
Add the dimension that define the granularity of your data to Detail
Ad finally, right click on the pill Bin of Score, that you located on Column and select Compute Using > the dimension you added to Detail.
Try this an let me know your results. I would be easy if you share a package workbook with sample data.
Best,
Ramon