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 |