topic Re: Adding 'ALL' as a dimension value in Water Cooler

Adding 'ALL' as a dimension value

sai_katare — Thu, 10 Jan 2019 08:59:06 GMT

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.

Re: Adding 'ALL' as a dimension value

uacg0009 — Thu, 10 Jan 2019 09:29:44 GMT

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

Re: Adding 'ALL' as a dimension value

shiveshsingh — Thu, 10 Jan 2019 09:51:22 GMT

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