You can try to implement worksheet swapping technique here. I have implemented it on a new dashboard
1. Create a calculated field to return a boolean value based on the parameter value selected as shown below:
2. Add the above to the filters in the WQI Map and select the "True" value. Ensure the parameter value is "Percentage of Surface Water..."
3. Add the above to the filters in the Water Quality Map and select the "False" value. Ensure the parameter value is not "Percentage of Surface Water..."
4. On a dashboard, place a horizontal/vertical container first, and then place the above 2 dashboards inside the container. Hide the titles for each of the worksheets. Now change the parameter values and check whether you have your desired map.
The updated workbook is attached. Hope this helps.
WaterMapBookAPF.twbx 455.5 KB
Hope this helps.
I only put example for "Percentage of Surface Water with Water Quality Index of Grade IV or Worse" and "Volume of Residential COD Emission (tonnes)"
as parameter selection, but you can expand the concept for others.
WaterMapBookAPF_SM_18.1.twbx 94.2 KB
Thanks for the reply Shinichiro. Unfortunately, the method you suggested did not resolve my problem, as I want a uniform colour for the Chinese provinces when the indicator "Percentage of Surface Water with Water Quality Index of Grade IV or Worse" is selected.
Thank you very much Hari for your solution as it produced something that's extremely close to what I want. I just have 3 follow up questions about some minor details:
1.I would like one legend from either of the worksheets to appear on the dashboard. Is there a way to have one legend applied to both worksheets on one dashboard?
2.Is there a way to produce something similar using only one worksheet, because I want to find a way to get rid of the "flashing" of the map when the indicator is switched to/from "Percentage of Surface Water with Water Quality Index of Grade IV or Worse".
3.If worksheet swapping is the only technique for this, is there a way to stabilize the map so that when the indicators are changed, the zoom and position of the map remains the same?
I don't really understand your comment, anyways let me know if you need further help.
You didn't explain all the parameter cases and I just tried to apply concept.
1 of 1 people found this helpful
1. You can create a horizontal bar chart with a value based on what you have selected in the parameter, and use that as the legend. You may however need to stick with 1 color range only. So, you will need to change the colors in one of the maps and see that you use the same color for the legend sheet also.
2. With 1 sheet, it would probably turn to be a solution suggested by Shinchiro above. I do not have a solution to prevent the flashing of the map.
3. I am not saying that worksheet swapping is the only technique for this. The zoom and position of the map can be pinned though.
Hi Hari and Shinichiro,
I've reviewed the methods that the two of you have suggested and I think Shinichiro's is more appropriate because I want to minimize the number of sheets I want to use for a dashboard. I didn't understand Shinichiro's method at first because when I looked at the dashboard of the workbook he had attached, the provinces were of different colours for all of the indicators. What I wanted were provinces of different colours only for one indicator, and a uniform colour for the provinces for all of the other indicators.
I tried Shinichiro's method again today and it worked! I'm just wondering what the zn function is used for.
For anyone reading this who has a similar problem, make sure you use elseif in the calculated field from the second if statement onward in order to create multiple conditional statements. In my case, entering this into the City Display calculated field:
if [Water Pollution Indicator]="Volume of Industrial COD Emission (tonnes)"
then [City (Eng)]
elseif [Water Pollution Indicator]="Volume of Industrial Ammonia Nitrogen Emission (tonnes)"
then [City (Eng)]
elseif [Water Pollution Indicator]="Volume of Industrial Waste Water Discharged (10,000 tonnes)"
then [City (Eng)]
would make the city bubbles for Volume of Residential COD Emission (tonnes), Volume of Industrial COD Emission (tonnes), and Volume of Industrial Waste Water Discharged (10,000 tonnes) appear.
I still need to find a way to make one legend that applies to all of the indicators in the new map using what Hari described.