Forum Discussion

mbhatti's avatar
mbhatti
Frequent Visitor
3 years ago
Solved

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 NUMBERDEPARTMENT
58F-50-00101RMECHANICAL
58E-50-00501RMECHANICAL
58E3210050SERVRMECHANICAL
EM8355RHYDRAULIC
94487240MECHANICAL
EM8355RHYDRAULIC
PB9839HYDRAULIC
PC2575HYDRAULIC
EM9639HYDRAULIC
EM8353RHYDRAULIC
99210540RHYDRAULIC
79327973HYDRAULIC
81325473HYDRAULIC
PB9008RHYDRAULIC
PB8995RHYDRAULIC
PB8995RHYDRAULIC
PB8995RHYDRAULIC
PB8995RHYDRAULIC
PB8995RHYDRAULIC
PB8995RHYDRAULIC
PB8995RHYDRAULIC
PB8995RHYDRAULIC
58B-50-40351RMECHANICAL
58B3200247SERVRMECHANICAL
EM8353RHYDRAULIC
58F-41-00010RHYDRAULIC
58B-50-40351RMECHANICAL
58B3200247SERVRMECHANICAL
PB9008RHYDRAULIC
58B-50-40351RMECHANICAL
58B3200247SERVRMECHANICAL
58F-50-00101RMECHANICAL
58F-41-00010RHYDRAULIC
PB8995RHYDRAULIC
GE0053RELECTRICAL
PB8995RHYDRAULIC
EM8844RMECHANICAL
PB8995RHYDRAULIC
PB8995RHYDRAULIC
EM8844RMECHANICAL

3 Replies

  • VijayP's avatar
    VijayP
    Community Champion

    mbhatti 

    CAn you please mention what exactly outcome should be ! ( any pictorial reference will help)

    • mbhatti's avatar
      mbhatti
      Frequent 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.