I have a MySQL database which has data collected from several remote devices. The metrics are the same for each device, only the device ID column in the MySQL table will be different. Now, for a single user, say there are 4 metrics I want to graph (I have written 4 queries and the graph is obtained as expected).
However, intuitively, this becomes more complicated with an increase in the number of users. Is there any way I can select the user whose data I want to graph. The queries will remain the same, as the metrics (columns of MySQL table) are the same.