Create parameter and list the column names.
Create calc and cal the column names with parameter.
Create viz and get filtered view based on column.
I think you need reshape your data as below to get a pivot table.
And then visualize your data
As final result could be like
Hope this could help.
Workbook attached for your reference.
Tableautry.twbx 11.4 KB
Hi Zhouyi Zhang,
Thank you, it seems to work and a helpful one.
But I have an additional query.
1. The original data set is having several other columns along with these, which are used for a different visualization within the same workbook. In that case pivoting these 4 columns alone will it cause any issue?
2. I have 2 more sets like this so can I choose each set of columns individually and pivot them. Else if all the columns under different set is going to have same values under them as Yes/No then in that case can I Pivot all such columns together. And then exclude the unwanted pivot field names from each charts.
Glad it works for you.
to you question 1, I am not sure how you use other columns in your viz, so I can't tell
question 2., not quite sure when you say 2 data set, are you going to join or separately use? and to your exclude part, I think it should doable.