I have 2 tables on my dashboard that are below:
| ID | COLOR | STATUS |
| WA13 | GREEN | INITIATED |
| ZW20 | YELLOW | REVIEWED |
| BC23 | GREEN | FINALIZED |
| WD50 | ORANGE | REVIEWED |
| ID | User Role | User Name |
| WA13 | SUPERVISOR | USER1 |
| WA13 | ANALYST | USER2 |
| WA13 | ADMIN | USER3 |
| ZW20 | MANAGER | USER4 |
| ZW20 | ADMIN | USER3 |
| ZW20 | SUPERVISOR | USER5 |
| BC23 | ANALYST | USER6 |
| BC23 | ANALYST | USER7 |
| BC23 | SUPERVISOR | USER5 |
| WD50 | SUPERVISOR | USER8 |
| WD50 | MANAGER | USER9 |
The ID on the second table does NOT show up on the dashboard, but it is the column that connects it to the first table. I only display "USER ROLE" and "USER". It is here so the connection between the 2 can be seen.
Each ID has multiple "USER ROLE"s associated with it. The way I am displaying the data is through 2 tables. When no filters are selected, it lists all of the "USER ROLE"s and "USER"s. Once a specific "ID" is selected, it will only show the associated "USER ROLE"s and "USER"s.
Here is what I need:
If "STATUS" = "INITIATED", highlight anyone with the "USER ROLE" of "ANALYST" associated with that specific ID in the bottom table. There may be multiple "ANALYST" user roles associated with that ID as well.
If "STATUS"="REVIEWED", highlight anyone with the "USER ROLE" of "MANAGER" associated with that specific ID in the bottom table. There may be multiple "MANAGER" user roles associated with that ID as well.
If "STATUS"="FINALIZED", highlight anyone with the "USER ROLE" of "SUPERVISOR" associated with that specific ID in the bottom table. There may be multiple "SUPERVISOR" user roles associated with that ID as well.
It would be ideal if the highlighting only occurs once a specific "ID" is selected, otherwise there will be a ton of highlights with no filter. The main thing is, I need to show the user that based on the "STATUS", the specific user needs to be highlighted or indicated in some manner. I am open to options.
Example:
Filter by "ID" = "WA13"
| ID | COLOR | STATUS |
| WA13 | GREEN | INITIATED |
| ID | User Role | User Name |
| WA13 | SUPERVISOR | USER1 |
| WA13 | ANALYST | USER2 |
| WA13 | ADMIN | USER3 |
Since "STATUS" = "INITIATED", the "USER ROLE" of "ANALYST" is highlighted. If there were multiple "ANALYST"s associated with that ID, then all of them would be highlighted.
