I have a table with multiple metrics like Conversion rate, engagement rate for multiple people. Some of them has conversion rate data and some doesnt have engagement rate data.
Is there any way , I can hide the columns based on the client selected or better based on the user.
So if A has engagement data and B has conversion data . A should not be seeing the conversion data in the table.
I currently have one table with both conversion metrics and engagment metrics. Basically hiding/unhiding columns .
Hi @liya101,
To hide a column, you can achieve this in the field well. For the column/field you’d like to hide, click the ellipses next to it’s name, then select ‘Hide’.
Please note, this hides the column completely though; there’s no way to ‘hide’ the blank cells within a column without also hiding the cells that have data.
Let me know if you have any additional questions or if this helps solve your question!
Hi @liya101 - For your requirement, you need to set up CLS ( Column Level Security) which will essentially disabled the column as per end user details.
Hi @Sanjeeb2022 , When I implemented column level security , the data in the column shows ‘Not authorized’. I would ideally want the whole column to hide and unhide based on each user.
Hello @liya101, the only option I can think of to handle this would be a mix of dynamic default parameter values with conditional rules in the free form layout. It wouldn’t necessary be functionality to show/hide a column, but rather show a table containing or excluding the column(s) you want depending on the user access.
Dynamic Default would require a QuickSight dataset, can be built from an excel file, similar to RLS. It would contain the User or Group Names for all of the people that would access the dashboard. Then you will need a single column and it could be something as simple as 1 or 0, or True or False to determine the parameter value.
In your analysis, add the new dynamic default dataset and create a parameter. Then set the dynamic default based on the dataset you brought in. With this, you can determine which of the 2 tables you will show depending on the user that is viewing the dashboard. I will include some documentation related to dynamic default parameter values and conditional rules below. This is likely the best work-around option to achieve your desired output.
