When I create the calculated field named Normal Curve in order to calculate the normal distribution it says "Argument to MAX and Aggregate function is already an aggregation and cannot be further aggregated."
Hi Julian! Thanks for your comment! You must calculate MAX and MIN on an unaggregated column . You already have an aggregation on the field and you can't make an additional one. I hope this information was helpful.
@@btprovider5561 I had the same issue as Julian, I followed the instructions step-by-step as they were in the video and the same error appeared for me. The 'Normal Curve' formula is using MAX on the Mean + Standard Deviation calculated fields, which were both calculated using aggregate functions (AVG and STDDEV, respectfully)
Hi Joe, Thanks for your question and sorry for the late reply. I presume the error was generated when you had to calculate the MAX for Standard Deviation & Mean, this is why you need to check the formula for the two calculated fields and make sure that they are calculate as a FIXED. The formulas have to be like: Standard Deviation = { STDEV( [Sales by Customers] ) } Mean = { AVG( [Sales by Customers] ) } Hope this is helpful.
I could not figure out what was the immediate expression after this ( 1/MAX([standard deviation])* SQRT(2*PI()) ) * EXP( it looks like it was a MINUS sign followed by square function. But it is not working out can someone copy paste the formula here
Hi Prakash. Thank you for your comment. All the steps you need to go through to create a histogram with normal distribution are mentioned here: btprovider.com/histogram-with-normal-distribution-tableau-software/. Also, the formula is: ( 1/MAX([Standard Deviation])*SQRT(2*PI()) ) * EXP ( -SQUARE(MAX([Sales (bin)]) - MAX([Mean])) / (2 * SQUARE(MAX([Standard Deviation]))) )
The issue is with the minus sign inside the square function. If you copy/paste it directly from the supporting article, you will receive a "Bad Character" error. Just delete & retype the minus sign and Tableau will accept the formula.
The issue is with the minus sign inside the square function. If you copy/paste it directly from the supporting article, you will receive a "Bad Character" error. Just delete & retype the minus sign and Tableau will accept the formula.
Good to see it in action. Text-only instruction for this on Tableau site is a bit difficult to follow.
Absurdly complicated.
Thank you for sharing your feedback with us!🙂
We greatly appreciate it. We will take your feedback into consideration.
When I create the calculated field named Normal Curve in order to calculate the normal distribution it says "Argument to MAX and Aggregate function is already an aggregation and cannot be further aggregated."
Hi Julian! Thanks for your comment! You must calculate MAX and MIN on an unaggregated column
. You already have an aggregation on the field and you can't make an additional one. I hope this information was helpful.
@@btprovider5561 I had the same issue as Julian, I followed the instructions step-by-step as they were in the video and the same error appeared for me. The 'Normal Curve' formula is using MAX on the Mean + Standard Deviation calculated fields, which were both calculated using aggregate functions (AVG and STDDEV, respectfully)
@@btprovider5561 Hi could you explain how to get to the unaggregated column for the max values?
same
I am having the same issue here. But your standard deviation is aggregated...
When I try this, I get an error in my NORMAL CURVE calculation that the MAX function is aggregating and aggregation. How do I fix that?
Hi Joe,
Thanks for your question and sorry for the late reply.
I presume the error was generated when you had to calculate the MAX for Standard Deviation & Mean, this is why you need to check the formula for the two calculated fields and make sure that they are calculate as a FIXED. The formulas have to be like:
Standard Deviation = { STDEV( [Sales by Customers] ) }
Mean = { AVG( [Sales by Customers] ) }
Hope this is helpful.
I could not figure out what was the immediate expression after this
(
1/MAX([standard deviation])* SQRT(2*PI())
)
*
EXP(
it looks like it was a MINUS sign followed by square function. But it is not working out
can someone copy paste the formula here
Hi Prakash. Thank you for your comment. All the steps you need to go through to create a histogram with normal distribution are mentioned here: btprovider.com/histogram-with-normal-distribution-tableau-software/. Also, the formula is:
(
1/MAX([Standard Deviation])*SQRT(2*PI())
)
*
EXP
(
-SQUARE(MAX([Sales (bin)]) - MAX([Mean]))
/
(2 * SQUARE(MAX([Standard Deviation])))
)
The issue is with the minus sign inside the square function. If you copy/paste it directly from the supporting article, you will receive a "Bad Character" error. Just delete & retype the minus sign and Tableau will accept the formula.
Normal Curve function is also not working following the instructions. See @andrea da Costa comment below.
The issue is with the minus sign inside the square function. If you copy/paste it directly from the supporting article, you will receive a "Bad Character" error. Just delete & retype the minus sign and Tableau will accept the formula.
Hello! How can we add a kernel density curve to a histogram?