Hello Bill Lepler,
I have attached a solution for you. Change AGG(Count distinct admit date) to Discrete then add a Reference Line for the Sum() of AGG(Count distinct admit date) to the view. Set this to be a "per cell" calculation.
I have made the line blank and formatted the "Value" to appear at the center of each bar.
The bar is actually a bunch of stacked values for MRN based on the Aggregate calculation in use.
Hope this helps.
mrm test_pvdh.twbx 32.1 KB
Patrick - Thank you for the solution.
One additional question for my own Tableau knowledge:
What is the significance of thin blue lines that appear in each bar ?