I would like to make a Pareto chart that shows the sum of how many scrapped pieces were produced by their given reason (such as broken, bent, etc). I am unsure of how to search/setup this chart. Right now I have:
index=wipscrap OR index=componentscrap Department=D2
| chart sum(Scrap) AS totalscrapdept BY "Scrap Reason Description"
| sort - totalscrapdept
which gives me the correct bar graph. How can I show an overlay that correctly represents the data as a Pareto chart? I'm very new to Splunk