I am calculating sum(Days) in my barchart it is showing the no of days 9 it is correct ,I want to calculate AVG of the days,I used Avg(Days) expression in my chart it still showing 9 but as per my requirement it should show 4.5. Any help.
That is up to how the user is expecting the output to behave. Since, Name is there in the dimension, usually user would expect only the Name field's selection to be disregarded. I.e. - avg result should be sensitive to other selections. Otherwise, if all selections are expected to be disregarded(which is normally not expected), yours is the way to go with.
