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?
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.
User | Count |
---|---|
41 | |
36 | |
30 | |
23 | |
16 |