This content has been marked as final.
Show 1 reply

1. Re: Fitting a normal curve to histograms in Tableau 10.1.3  need help setting up calculated fields
Matt Lutton May 16, 2018 1:31 PM (in response to Christopher Klapperich)With just a quick first glance, I can tell you that you cannot do an aggregation on a regular aggregate  so AVG(Count(Measure)) will never work in Tableau.
You can try figuring out how to use a WINDOW_AVG calc, which will compute the AVG of the Counts within the table/window you're working with:
https://interworks.com/blog/rcurtis/2017/10/31/funwindowfunctionstableau/
Other than Table Calculations, you may be able to use an LOD for this, since those can also be used to aggregate an already aggregate value.
I hope this sets some directions to look at, sorry I don't have more time right now to jump in!