my ideas are like below… there will be 4 quicksight reports… feel free to suggest if any better suggestions on this.
1st report will have 4 sheets → Corporate, Community, Caregivers, Residents
This report access will be given to only "corporate view users" from RLS
Sheet navigations between all above sheets need to be taken care. It means that if the user on Corporate sheet and looking at the Average response KPI chart with community dimension, clicking on any particular community should navigate him to Community sheet with default filter applied with selected community value.
Like wise, the navigations from Community sheet to Caregiver sheet and from Caregiver sheet to Residents sheet.
Also, by clicking on the chart, user should be able to get the raw data shown based on the selected community and measure values
2nd report will be the duplicate of 1st report but with out Corporate sheet.
This report access will be given to only "Community view users" from RLS
Rest of all the functionality remains the same
3rd report will be the duplicate of 2nd report but with out Community sheet.
This report access will be given to only "Caregiver view users" from RLS
Rest of all the functionality remains the same
4th report will be the duplicate of 3rd report but with out CommunityCaregiver sheet.
This report access will be given to only "Resident view users" from RLS
Rest of all the functionality remains the same