Table comparison

I have two tables. One with a list of registered machines, and another one where they register those same machines with defect.

I want to create a UX with a graph that shows me a percentage of those machines that are defective.

it’s possible ?

Do you want to show only one value… the overall percentage?

Hi, @Aleksi

I drew this scheme to better expose what I desire.
Can you understand ?

Create an additional small table with one column. Add two records like “Not defected” and “Defected”. After you have generated that table, add a virtual column where you can calculate the percentage value. Then create a chart view from that table.