In the first bar chart I have shown average of sales per day during a period and in the second one I have used "Split bars" as sub_bucket in order to show average of sales per day per type of customers during the period. But the result has been completely changed. The range of y.axis in the first graph is between 0 , 1000 . But in the second one is between 0 , 5500. For some of days , this amount extremely has been changed.
I'm agreed that it's logically some of bars will see an increase in its value because the average will be calculated in other way (For example : There is a type of customer which has very low number of custmers ( such as 5) but each of them has high value in their sale.) .
The point is , as you can see the peak of first graph contains those customers which "only" belong to "one" group (type) of customers. Even in this case , a huge increase can be seen there.
Is there any one can help me with this ?