Hello Everyone,
I need help on this one. Please respond asap- I attached some sample data in which I need to calculate count, percentage, average. I need to show for level column how many are under <24 days, <24 hours >15days<24 days and so on... along with need to show percentage and average. Other words- Y axis need to show level column ( like - Car, Wheel, and so on...) on stacked bar chart need to show count of <24 days,<24 hours,>15days <24 hours and so on, average of 'Values' column for <24 days, <24 hours and so on.. and percentage also. Please let me know if you are not clear on this. Thank you!
| Level | Time spent | Values |
| Car | >24 hours | 9.2 |
| Wheel | >15 days< 24 days | 8.6 |
| Air bag | >24 days | 0.03 |
| Condition | >90 days | 12.3 |
| Tires | >24 hours | 3.5 |
| Wheel | >15 days< 24 days | 3.9 |
| Air bag | >24 days | 4.3 |
| Condition | >90 days | 4.8 |
| Car | >24 hours | 5.4 |
| Gas | >15 days< 24 days | 5.9 |
| Stereo | >24 days | 6.3 |
| Sound | >90 days | 6.9 |
| Winds | >90 days | 8.1 |
| Finder | >30 days | 4 |
| Check | >15 days <30 days | 4.23 |
| Gas | >15 days | 5.67 |
| Wheel | >30 days | 7.14 |
| Condition | >20 days | 8.23 |
| Car | >15days <25 days | 9.24 |
| Air bag | >15days <25 days | 7.134 |
| Tires | >15 days< 24 days | 12.34 |
| Sound | >24 days | 17.56 |
| Winds | >90 days | 6.78 |
| Gas | >24 hours | 9.83 |
| Sound | >15 days< 24 days | 9.8 |
