Trying to build a SS that's basically a pivot tabl...
# administrationd
Dylan Fields
11/08/2023, 5:29 PMTrying to build a SS that's basically a pivot table of role permissions, where it would show the role on the left and then the permission name but then rather than just having a single "Level" column, I'd like to have a column each for Full, Create, Edit, and View. I figured I could do this with CASE WHEN statements, a la "case when {level} is "full" then "Full" else 0 end" or the like. Anyone know if this is possible?
Dylan Fields
11/08/2023, 5:35 PMAlternatively, I could have the permission on the left, then a column for every desired role with the permission level showing up for each. That would result in the lowest number of rows.
s
Sam-I-Am
11/08/2023, 6:01 PMI usually use the setup>users/roles>show role difference then just uncheck the "show only differences" check box. Rest I do it in excel. Have been using this for SOD review for SOX/ISO 27001 compliance for over 8 years now. Most easiest way - my 0.5 cents worth !!!!
👍 1
r
Robz
11/08/2023, 6:02 PMAs a summary saved search like below?
🏆 1
d
Dylan Fields
11/08/2023, 7:15 PMThat's it! Though it doesn't have to be summary. As kind of expected, my problem was syntax. I suck at the syntax when writing formulas in NS. 😞
Dylan Fields
11/08/2023, 7:18 PMResults look like this:
r
Robz
11/08/2023, 11:35 PM👍🙌
2 Views