Hello all, I need to calculate average, percentage, count in stacked bar chart. Sharing sample data. Please help me as soon as possible. I need to calculate like for :
Level column suppose (Price )1)how many are <=10 hours,>15days<=20days,>24 hours and<=15 days,>30 days and<=60 days and so on..(Count)
2) How much is Average for Level(column) under <=10 hours,>15days<=20days,>24 hours and<=15 days,>30 days and<=60 days and so on..(Average)
3)How much is Percentage for Level (column) under <=10 hours,>15days<=20days,>24 hours and<=15 days,>30 days and<=60 days and so on..(Percentage )
So, left hand side(y axis) we need get Level column and need to show count, average, percentage on chart and need to get data values of average at end of each bar.
Please let me know if you have any questions in data. Please help me asap. Thank you!
| Level | Hours | Values |
| Tag | <=10hours | -390.81 |
| Price | >15days<=20days | -158.96 |
| Digital | >24hours and <=15 days | -9.88 |
| Custom | >30 days and <=60 days | -1.13 |
| 134eRome | >90 days | 0.04 |
| 800Belt | >60 days and <=90 days | 0.09 |
| 19s045 total | <=10hours | 47 |
| Price | >15days<=20days | 48.02 |
| Digital | >24hours and <=15 days | 49.05 |
| Custom | >30 days and <=60 days | 52.34 |
| Nation | >90 days | 33.12 |
| 300year | >60 days and <=90 days | 43.45 |
| 250g | >60 days and <=90 days | 11.23 |
