Your workbook is very complex - but to the firs 2 questions
your LOD was considered a dimension - I changed them to Measures (right clock and select convert to measure) then replaced them on the viz with SUM() (not ATTR() )
now you will get this
as for the third issue - I don't know what you expect -
I looked at the worksheet and the total was set to automatic I reset it to Avg() think that is what you want
just a comment for what it's worth - I do a lot of call center analytics with one of my clients and over time I have found that bringin in both the discrete level data (individual call data) and the aggregate data Totals - leads to problems (mixing aggregate an disaggregate data) they have moved to bringing in discrete data and doing the aggregation with analysis
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.
Call Volume Comparison_v10.5.twbx 409.7 KB