hi there,
I need to create Normal Distribution Trendline. even if I used calculation below, it returns NULL. could you please support me with the Calc below?
since i am new user of the Software, I am not being able to help myself.
Found the Calc example from the Link (https://www.theinformationlab.co.uk/2013/11/04/fitting-a-gaussian-normal-distribution-curve-to-a-histogram-in-tableau/)
Appreciate it
GZ
Normal Distribution (copy)
Role:
Discrete Measure
Type:
Calculated Field
Status:
Valid
Formula
(1/([Standard Deviation]*SQRT(2*PI())))*EXP(-((ATTR([Actual Bin])-[AVG])^2/(2*[Standard Deviation]^2)))*1000*TOTAL(SUM([Number of Records]))
Good morning
I posted a blog piece on this recently see See it your way: Normal distribution
it looks like this
there is an accompanying workbook at Tableau Public feel free to download it to use as a model
Jim
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
