Forum Discussion

SantiagoTorres's avatar
SantiagoTorres
Icon for Helper I rankHelper I
3 years ago
Solved

Pareto Chart

Hi All,

 

I need help here. I got three columns with text (Quality, Safety and Environmental); I need to create a Pareto Chart counting the data in these three columns excluding the blanks. What I got at the moment is something like this:

 

Contributing Condition (S)Contributing Condition (Q)Contributing Condition (E)
MEWP or Mobile Plant  
General PPE  
 Installation 
 Installation 
  Waste management
safety documentation  
Site establishment set up  
  Waste management
safety documentation  
 Installation 
Fall hazard  
scaffolding  
scaffolding  
Fall hazard  
Dropped objects  
 Documentation 
Access and Egress of site  
 Installation 
 Documentation 
Access and Egress of site  
Fall hazard  
scaffolding  
 Installation 

 

Obs/Type = COUNTA('2. Observations'[Contributing Condition (S)]) I need to exclude the blanks and count '[Contributing Condition (Q) and '[Contributing Condition (E)]
 
Then for the chart:
 
Pareto Chart =
VAR ObsRev = [Obs/Type]
VAR AllObs = CALCULATE( [Obs/Type], ALLSELECTED('2. Observations')) 

RETURN
DIVIDE(
SUMX(
    FILTER(
        SUMMARIZE( ALLSELECTED('2. Observations'), '2. Observations'[Contributing Condition (S)], In here I also need to exclude the blanks and also count '[Contributing Condition (Q) and '[Contributing Condition (E)]
            "Cumulative", [Obs/Type] ),
                [Cumulative] >= ObsRev ),
                    [Obs/Type] ),
    AllObs,0 )
 
What I'm getting at the moment is this, which is something close  to what I need,

As you can see, the blanks play a big part in the results, so I need to capture (count) just the rows, including descriptions based on each column, '[Contributing Condition (S)], '[Contributing Condition (Q) and '[Contributing Condition (E)].

 

Thanks for your help,

 

 
Need Help