You can bind queries from different datasets. For example, this dashboard contains two charts, each based on its own dataset.
When a selection is made in the Opportunities DS chart, that selection also filters the SalesOpp DS chart because of a selection interaction. The filters attribute of the Country_1 query contains a selection interaction based on the Account_BillingCount_1 query.
Here’s the full dashboard JSON for the queries and chart widgets, which contains the {{column(Account_BillingCount_1.selection, [\\"Account.BillingCountry\\"]).asObject()}} selection interaction described previously.
1{
2 "label": "Cross-Dataset Bindings",
3 "state": {
4 "gridLayouts": [...],
5 "layouts": [],
6 "steps": {
7 "Account_BillingCount_1": {
8 "datasets": [
9 {
10 "id": "0Fbx000000000LzCAI",
11 "label": "Opportunities",
12 "name": "opportunity1",
13 "url": "/services/data/v38.0/wave/datasets/0Fbx000000000LzCAI"
14 }
15 ],
16 "isFacet": true,
17 "isGlobal": false,
18 "query": {
19 "measures": [
20 [
21 "count",
22 "*"
23 ]
24 ],
25 "groups": [
26 "Account.BillingCountry"
27 ]
28 },
29 "type": "aggregateflex",
30 "useGlobal": true,
31 "visualizationParameters": {
32 "visualizationType": "hbar",
33 "options": {}
34 }
35 },
36 "Country_1": {
37 "datasets": [
38 {
39 "id": "0Fbx000000000NACAY",
40 "label": "SalesOpps",
41 "name": "SalesOpps",
42 "url": "/services/data/v38.0/wave/datasets/0Fbx000000000NACAY"
43 }
44 ],
45 "isFacet": true,
46 "isGlobal": false,
47 "query": {
48 "measures": [
49 [
50 "count",
51 "*"
52 ]
53 ],
54 "groups": [
55 "Country"
56 ],
57 "filters": [
58 [
59 "Country",
60 "{{column(Account_BillingCount_1.selection, [\\"Account.BillingCountry\\"]).asObject()}}"
61 ]
62 ]
63 },
64 "type": "aggregateflex",
65 "useGlobal": true,
66 "visualizationParameters": {
67 "visualizationType": "hbar",
68 "options": {}
69 }
70 }
71 },
72 "widgetStyle": {...},
73 "widgets": {
74 "text_1": {
75 "parameters": {
76 "fontSize": 20,
77 "text": "Opportunities DS",
78 "textAlignment": "center",
79 "textColor": "#000000"
80 },
81 "type": "text"
82 },
83 "text_2": {
84 "parameters": {
85 "fontSize": 20,
86 "text": "SalesOpp DS",
87 "textAlignment": "center",
88 "textColor": "#000000"
89 },
90 "type": "text"
91 },
92 "chart_2": {
93 "parameters": {
94 "legend": {
95 "showHeader": true,
96 "show": true,
97 "position": "right-top",
98 "inside": false
99 },
100 "showMeasureTitle": true,
101 "showTotal": true,
102 "visualizationType": "pie",
103 "step": "Country_1",
104 "exploreLink": true,
105 "inner": 70,
106 "title": {
107 "label": "",
108 "subtitleLabel": "",
109 "align": "center"
110 },
111 "theme": "wave",
112 "trellis": {
113 "enable": false,
114 "type": "x",
115 "chartsPerLine": 4
116 }
117 },
118 "type": "chart"
119 },
120 "chart_1": {
121 "parameters": {
122 "legend": {
123 "showHeader": true,
124 "show": true,
125 "position": "right-top",
126 "inside": false
127 },
128 "showMeasureTitle": true,
129 "showTotal": true,
130 "visualizationType": "pie",
131 "step": "Account_BillingCount_1",
132 "exploreLink": true,
133 "inner": 70,
134 "title": {
135 "label": "",
136 "subtitleLabel": "",
137 "align": "center"
138 },
139 "theme": "wave",
140 "trellis": {
141 "enable": false,
142 "type": "x",
143 "chartsPerLine": 4
144 }
145 },
146 "type": "chart"
147 }
148 }
149 },
150 "datasets": [
151 {
152 "id": "0Fbx000000000LzCAI",
153 "label": "Opportunities",
154 "name": "opportunity1",
155 "url": "/services/data/v38.0/wave/datasets/0Fbx000000000LzCAI"
156 },
157 {
158 "id": "0Fbx000000000NACAY",
159 "label": "SalesOpps",
160 "name": "SalesOpps",
161 "url": "/services/data/v38.0/wave/datasets/0Fbx000000000NACAY"
162 }
163 ]
164}
j