Creating a Pareto of data in multiple columns

rprice1027

I am analyzing data pertaining to manufacturing defects (example below), and cannot seem to summarize the defect codes into an organized Pareto. Feel like I may be missing something, as I'm pretty new to Smartsheet. I can do a sheet summary, but that will not allow me to generate any type of visual chart.

Genevieve P.

Hi @rprice1027

What I would do with this data is have a second sheet with formulas as a metric sheet to be the source of your chart.

One column in this metric sheet would list all the possible options, e.g. "Missing space blocks".

The column next to it would have multiple COUNTIF formulas added together:

=COUNTIF() + COUNTIF() + COUNTIF()... one for each column. Adding all 5 together will give you a COUNT of how many times that value appears in your other sheet.

=COUNTIF({Cabinet defect 1}, [Column Name]@row) + COUNTIF({Cabinet defect 2}, [Column Name]@row)...

Each of {these} cross sheet references would point to one column, and the [Column Name]@row would be looking in the current metric sheet to where you house the defect you're searching for.

Let me know if this makes sense or if you'd like to see screen capture examples.

Cheers,

Genevieve