You can dynamically change the map type based on selections in a toggle widget. For example, you can create a toggle that switches between two different types of maps.
Let’s say you want to analyze your company’s performance globally and in the United States. You add a toggle that switches from a world map by country to a country map by state. And you show the world map by default if no selection is made.
When you click State, the dashboard shows your results for each state.
The custom query (static_1) provides the “Country” and “State” values that appear in the toggle widget. The chart widget has a Map Type property so you can select the type of map to display. To dynamically set the map type based on a selection in the custom query (static_1), bind the Map Type property in the query (State__c_1) of the chart widget to the custom query (static_1). For more information about maps, see Map Charts.
Here’s the dashboard JSON. Focus on the values attribute of static_1, the groups attribute of the State__c_1 query, and the maps parameter of the chart_1 widget.
1{
2 "label": "Choropleth Binding",
3 "state": {
4 "gridLayouts": [...],
5 "layouts": [],
6 "steps": {
7 "static_1": {
8 "datasets": [],
9 "dimensions": [],
10 "isFacet": false,
11 "isGlobal": false,
12 "selectMode": "single",
13 "type": "staticflex",
14 "useGlobal": false,
15 "values": [
16 {
17 "display": "Country",
18 "grouping": "Country__c",
19 "mapType": "World Countries"
20 },
21 {
22 "display": "State",
23 "grouping": "State__c",
24 "mapType": "US States"
25 }
26 ],
27 "visualizationParameters": {
28 "options": {}
29 }
30 },
31 "State__c_1": {
32 "datasets": [
33 {
34 "id": "0FbB000000001uGKAQ",
35 "label": "GUS Roster",
36 "name": "Roster",
37 "url": "/services/data/v38.0/wave/datasets/0FbB000000001uGKAQ"
38 }
39 ],
40 "isFacet": true,
41 "isGlobal": false,
42 "query": {
43 "measures": [
44 [
45 "count",
46 "*"
47 ]
48 ],
49 "groups": [
50 "{{coalesce(cell(static_1.selection, 0, \\"grouping\\"), cell(static_1.result, 0, \\"grouping\\")).asString()}}"
51 ]
52 },
53 "type": "aggregateflex",
54 "useGlobal": true,
55 "visualizationParameters": {
56 "visualizationType": "hbar",
57 "options": {}
58 }
59 }
60 },
61 "widgetStyle": {...},
62 "widgets": {
63 "pillbox_1": {
64 "parameters": {
65 "compact": false,
66 "exploreLink": false,
67 "step": "static_1"
68 },
69 "type": "pillbox"
70 },
71 "chart_1": {
72 "parameters": {
73 "legend": {
74 "showHeader": true,
75 "show": true,
76 "position": "right-top",
77 "inside": false
78 },
79 "highColor": "#1674D9",
80 "lowColor": "#C5DBF7",
81 "visualizationType": "choropleth",
82 "step": "State__c_1",
83 "theme": "wave",
84 "exploreLink": true,
85 "title": {
86 "label": "",
87 "align": "center",
88 "subtitleLabel": ""
89 },
90 "trellis": {
91 "enable": false,
92 "type": "x",
93 "chartsPerLine": 4
94 },
95 "map": "{{coalesce(cell(static_1.selection, 0, \\"mapType\\"), cell(static_1.result, 0, \\"mapType\\")).asString()}}"
96 },
97 "type": "chart"
98 }
99 }
100 },
101 "datasets": [...]
102}
j