Adding 'ALL' as a dimension value

[sai_katare]

Hi, 

I have a column called 'direction' with values East,west, north, south. And I am using it as a filter in dashboard which is always a single selection. 

Now the requirement from user is that he wants another dimension value as 'All' added to the filter selecting which it shows data for all 4 directions.

Please help me how do I create this new column in load script using set analysis.

Thanks in advance.

[uacg0009]

Hi,
I think there are some methods to solve this. For example:
1. You can concatenate all the data to your origin table, and change the "direction" value to "All".
2. If possible, I think it's better to cancel the single selection setting in list box, you can tell user that when they selection nothing in the list box, that's "All".
Aiolos Zhao

[shiveshsingh]

in script, add one more line  in script like 'All' as direction;