Please see newly attached 2018.2 workbook. I followed Jonathan Drummey's example for this same issue from this thread: Average Calls per Hour per Weekday I think I got fairly close to what he'd done. See if it works for you? I believe Jim Dehner is at the Tableau Conference, so probably unable to respond. 4-5 new calcs in the workbook. Several Table Calc settings throughout. Thx, Don
Thanks so much for looking Don. I am going to go over it closely tonight. I don't think it's correct though because I know that the arrivals arrange from about 1 patient per hour (in the middle of the night) to about 5 (mid afternoon). All of the values on the Y axis are less than 1 so I don't think it can be correct - but hopefully it will help me arrive at the solution.