In a connector I have a table that lists the users in the system. The Instance column is the user ID which us unique. I want to be able to group the users based on the uplink port they are assigned to. Uplink port is in another column.
Is there a way to do this, or do I have to create separated tables per port?
I do not want to have autoincrement on instance.
The list of users will be quite extensive, I would like to be able to group like in the dashboard. Is this possible?

Hi Anna,
Small question, is there a reason why the grouping needs to be implemented in a connector? Using a dashboard does not cover your use case?
Both Dataminer Cube and the view in the dashboard is used. Dataminer Cube is used when configuring the users, dashboard is only used for monitoring.
Added more information in separate comment.