100% Stacked bar chart with Average

[aarav021]

Dear all, 

I want to represent Average hit count I want to show stacked bar chart showing the average hit count. I am able to show sum of hit count, also count of hit count. But not getting 100% share if using average. 

It's urgent requirement please if anyone could help me in this 

[HeshamKhja1]

Hi @aarav021 ,

One day later although it is urgent to you, I didn't get what you mean by 100% Share? what are you expecting the chart to be?

I used below sample:

T1:
LOAD * Inline [
Month, Categ, Value
1, Misc, 1
1, Mailers, 1
1, Banners, 1
1, Posts, 2
1, Misc, 3
2, Misc, 3
2, Mailers, 2
2, Mailers, 3
2, Mailers, 4
];

Created two charts, 1) Using Sum. 2) Using Avg.

Everything seems correct. What did you encounter?

[aarav021]

By 100% what I mean is that the total share for the categories should sum to 100%