So I have ~50 machines that have daily uptime values (hours) for 20+ years. I am trying to create an app that allows operators to input those daily values into a table, and also see a graph of values over time for any given machine. I currently have two tables, one with unique machine Idโs and pertinent info about them, and another with dates in the first column, machine names in the column headers, and values for uptime for a given machine on that date. I am thinking I need to break the values table into 50 tables (one for each machine) to make this work, but I am hoping there is a more elegant solution that will allow me to dynamically filter a view to visualize or input data for any specific machine within the combined values table. Is this possible?
Thank you!
User | Count |
---|---|
39 | |
35 | |
29 | |
23 | |
18 |