Forum Discussion
How to create a Pie Chart using the same column but varying filters?
I want to create a simple pie chart that COUNTS (PART NUMBER) and the legend will show category by Mechanical, Hydraulic, and Electrical.
Problem is when I add "COUNTOF PART NUMBER" field to the "Values" and add "Department" to "Filters on this visual" I can only pick one item. Like I need to add "COUNTOF PART NUMBER" field to the "Values" 3 times, and have each repetitive count filter differnetly (i.e., Mechanical, electrical, hydraulic).
I've been running in circles for hours trying to create an entirely new table or new calcualted colum/field, but I just can't figure this out. Please help!
| PART NUMBER | DEPARTMENT |
| 58F-50-00101R | MECHANICAL |
| 58E-50-00501R | MECHANICAL |
| 58E3210050SERVR | MECHANICAL |
| EM8355R | HYDRAULIC |
| 94487240 | MECHANICAL |
| EM8355R | HYDRAULIC |
| PB9839 | HYDRAULIC |
| PC2575 | HYDRAULIC |
| EM9639 | HYDRAULIC |
| EM8353R | HYDRAULIC |
| 99210540R | HYDRAULIC |
| 79327973 | HYDRAULIC |
| 81325473 | HYDRAULIC |
| PB9008R | HYDRAULIC |
| PB8995R | HYDRAULIC |
| PB8995R | HYDRAULIC |
| PB8995R | HYDRAULIC |
| PB8995R | HYDRAULIC |
| PB8995R | HYDRAULIC |
| PB8995R | HYDRAULIC |
| PB8995R | HYDRAULIC |
| PB8995R | HYDRAULIC |
| 58B-50-40351R | MECHANICAL |
| 58B3200247SERVR | MECHANICAL |
| EM8353R | HYDRAULIC |
| 58F-41-00010R | HYDRAULIC |
| 58B-50-40351R | MECHANICAL |
| 58B3200247SERVR | MECHANICAL |
| PB9008R | HYDRAULIC |
| 58B-50-40351R | MECHANICAL |
| 58B3200247SERVR | MECHANICAL |
| 58F-50-00101R | MECHANICAL |
| 58F-41-00010R | HYDRAULIC |
| PB8995R | HYDRAULIC |
| GE0053R | ELECTRICAL |
| PB8995R | HYDRAULIC |
| EM8844R | MECHANICAL |
| PB8995R | HYDRAULIC |
| PB8995R | HYDRAULIC |
| EM8844R | MECHANICAL |
3 Replies
- VijayPCommunity Champion
- VijayPCommunity Champion
CAn you please mention what exactly outcome should be ! ( any pictorial reference will help)
- mbhattiFrequent Visitor
It will just be a pie chart with 3 sections on legend:
Count of Mechanical Parts = 13
Count of Electrical Parts = 1
Count of Hydraulic Parts = 26
The Pie Chart will show 40 items total on it in 3 different sections/colors on legend.