question

@Alejandro C8,

I didn't see a model attached to your question, so I went ahead and created one to demonstrate a possible solution. If you are using a Statistics Collector to gather quality and throughput data, making the calculations you described is relatively easy. To do this, we will use a Calculated Table.

In your model, I assume that you're tracking good and bad quality in a Statistics Collector, so the only things we need are a count of the total items and a count of the good quality items. Then we can create the ratio you specified. For the first metric, we can aggregate the count of the items.

For the second metric, we can aggregate the sum of the quality (based on good quality = 1; bad quality = 0).

Then we use these newly created columns to calculate the ratio.

So our raw data and results table look like this:

You can always adjust this method to meet the needs of your model. If you have questions about the Calculated Table or how I set things up here, feel free to reach out.

ratio good quality example_1.fsm