Wave Analytics ダッシュボード JSON リファレンス
jWave デザイナダッシュボードの JSON の例
各 Wave デザイナダッシュボードの JSON には、複数レベルのプロパティが含まれます。プロパティを設定する場所を理解するため、JSON の構造を確認してください。
例
1{
2 "label": "Opportunity Overview",
3 "description": "Sample Wave designer dashboard with multiple layouts.",
4 "state": {
5 "gridLayouts": [
6 {
7 "name": "Default",
8 "numColumns": 12,
9 "pages": [
10 {
11 "widgets": [
12 {
13 "colspan": 3,
14 "column": 3,
15 "name": "container_1",
16 "row": 1,
17 "rowspan": 6,
18 "widgetStyle": {
19 "backgroundColor": "#FFFFFF",
20 "borderColor": "#9687BB",
21 "borderEdges": [
22 "top"
23 ],
24 "borderRadius": 0,
25 "borderWidth": 8
26 }
27 },
28 {
29 "colspan": 12,
30 "column": 0,
31 "name": "text_2",
32 "row": 0,
33 "rowspan": 1,
34 "widgetStyle": {
35 "backgroundColor": "#FFFFFF",
36 "borderColor": "#77B0AD",
37 "borderEdges": [],
38 "borderRadius": 0,
39 "borderWidth": 8
40 }
41 },
42 {
43 "colspan": 3,
44 "column": 0,
45 "name": "container_4",
46 "row": 1,
47 "rowspan": 6,
48 "widgetStyle": {
49 "backgroundColor": "#FFFFFF",
50 "borderColor": "#77B0AD",
51 "borderEdges": [
52 "top"
53 ],
54 "borderRadius": 0,
55 "borderWidth": 8
56 }
57 },
58 {
59 "colspan": 3,
60 "column": 0,
61 "name": "text_1",
62 "row": 1,
63 "rowspan": 1,
64 "widgetStyle": {
65 "borderEdges": []
66 }
67 },
68 {
69 "colspan": 3,
70 "column": 3,
71 "name": "text_3",
72 "row": 1,
73 "rowspan": 1,
74 "widgetStyle": {
75 "borderEdges": []
76 }
77 },
78 {
79 "colspan": 3,
80 "column": 0,
81 "name": "number_1",
82 "row": 2,
83 "rowspan": 2,
84 "widgetStyle": {
85 "borderEdges": []
86 }
87 },
88 {
89 "colspan": 3,
90 "column": 3,
91 "name": "number_2",
92 "row": 2,
93 "rowspan": 2,
94 "widgetStyle": {
95 "borderEdges": []
96 }
97 },
98 {
99 "colspan": 3,
100 "column": 0,
101 "name": "chart_1",
102 "row": 4,
103 "rowspan": 3,
104 "widgetStyle": {
105 "borderEdges": []
106 }
107 },
108 {
109 "colspan": 3,
110 "column": 3,
111 "name": "chart_2",
112 "row": 4,
113 "rowspan": 3,
114 "widgetStyle": {
115 "borderEdges": []
116 }
117 },
118 {
119 "colspan": 6,
120 "column": 6,
121 "name": "chart_5",
122 "row": 1,
123 "rowspan": 6,
124 "widgetStyle": {
125 "borderEdges": []
126 }
127 }
128 ]
129 }
130 ],
131 "selectors": [],
132 "style": {
133 "alignmentX": "left",
134 "alignmentY": "top",
135 "backgroundColor": "#F2F6FA",
136 "cellSpacingX": 8,
137 "cellSpacingY": 8,
138 "documentId": "",
139 "fit": "original"
140 },
141 "version": 1
142 },
143 {
144 "name": "Tablet",
145 "numColumns": 8,
146 "selectors": [
147 "minWidth(600)",
148 "maxWidth(900)",
149 "orientation(portrait)"
150 ],
151 "pages": [
152 {
153 "widgets": [
154 {
155 "colspan": 7,
156 "column": 0,
157 "name": "text_2",
158 "row": 0,
159 "rowspan": 1,
160 "widgetStyle": {
161 "backgroundColor": "#FFFFFF",
162 "borderColor": "#77B0AD",
163 "borderEdges": [],
164 "borderRadius": 0,
165 "borderWidth": 8
166 }
167 },
168 {
169 "colspan": 3,
170 "column": 0,
171 "name": "text_1",
172 "row": 1,
173 "rowspan": 1,
174 "widgetStyle": {
175 "borderEdges": []
176 }
177 },
178 {
179 "colspan": 3,
180 "column": 0,
181 "name": "number_1",
182 "row": 2,
183 "rowspan": 2,
184 "widgetStyle": {
185 "borderEdges": []
186 }
187 },
188 {
189 "colspan": 3,
190 "column": 0,
191 "name": "chart_1",
192 "row": 4,
193 "rowspan": 3,
194 "widgetStyle": {
195 "borderEdges": []
196 }
197 },
198 {
199 "colspan": 4,
200 "column": 0,
201 "name": "container_4",
202 "row": 1,
203 "rowspan": 6,
204 "widgetStyle": {
205 "backgroundColor": "#FFFFFF",
206 "borderColor": "#77B0AD",
207 "borderEdges": [
208 "top"
209 ],
210 "borderRadius": 0,
211 "borderWidth": 8
212 }
213 },
214 {
215 "colspan": 3,
216 "column": 4,
217 "name": "text_3",
218 "row": 1,
219 "rowspan": 1,
220 "widgetStyle": {
221 "borderEdges": []
222 }
223 },
224 {
225 "colspan": 3,
226 "column": 4,
227 "name": "number_2",
228 "row": 2,
229 "rowspan": 2,
230 "widgetStyle": {
231 "borderEdges": []
232 }
233 },
234 {
235 "colspan": 3,
236 "column": 4,
237 "name": "chart_2",
238 "row": 4,
239 "rowspan": 3,
240 "widgetStyle": {
241 "borderEdges": []
242 }
243 },
244 {
245 "colspan": 4,
246 "column": 4,
247 "name": "container_1",
248 "row": 1,
249 "rowspan": 6,
250 "widgetStyle": {
251 "backgroundColor": "#FFFFFF",
252 "borderColor": "#9687BB",
253 "borderEdges": [
254 "top"
255 ],
256 "borderRadius": 0,
257 "borderWidth": 8
258 }
259 },
260 {
261 "colspan": 8,
262 "column": 0,
263 "name": "chart_5",
264 "row": 7,
265 "rowspan": 6,
266 "widgetStyle": {
267 "borderEdges": []
268 }
269 }
270 ]
271 }
272 ],
273 "version": 1,
274 "style": {
275 "backgroundColor": "#C5D3E0",
276 "cellSpacingX": 4,
277 "cellSpacingY": 4,
278 "documentId": "",
279 "fit": "original",
280 "alignmentX": "left",
281 "alignmentY": "top"
282 },
283 "maxWidth": 500
284 }
285 ],
286 "layouts": [],
287 "steps": {
288 "LeadSource_6": {
289 "datasets": [
290 {
291 "id": "0Fbx000000000LzCAI",
292 "label": "Opportunities",
293 "name": "opportunity1",
294 "url": "/services/data/v38.0/wave/datasets/0Fbx000000000LzCAI"
295 }
296 ],
297 "isFacet": true,
298 "isGlobal": false,
299 "query": {
300 "measures": [
301 [
302 "sum",
303 "Amount"
304 ]
305 ],
306 "groups": [
307 "LeadSource"
308 ]
309 },
310 "type": "aggregate",
311 "useGlobal": true,
312 "visualizationParameters": {
313 "visualizationType": "hbar",
314 "options": {}
315 }
316 },
317 "LeadSource_7": {
318 "datasets": [
319 {
320 "id": "0Fbx000000000LzCAI",
321 "label": "Opportunities",
322 "name": "opportunity1",
323 "url": "/services/data/v38.0/wave/datasets/0Fbx000000000LzCAI"
324 }
325 ],
326 "isFacet": true,
327 "isGlobal": false,
328 "query": {
329 "measures": [
330 [
331 "sum",
332 "Amount"
333 ]
334 ],
335 "groups": [
336 "LeadSource"
337 ]
338 },
339 "type": "aggregate",
340 "useGlobal": true,
341 "visualizationParameters": {
342 "visualizationType": "hbar",
343 "options": {}
344 }
345 },
346 "CreatedDate_Year_CreatedDate_Month_9": {
347 "datasets": [
348 {
349 "id": "0Fbx000000000LzCAI",
350 "label": "Opportunities",
351 "name": "opportunity1",
352 "url": "/services/data/v38.0/wave/datasets/0Fbx000000000LzCAI"
353 }
354 ],
355 "isFacet": true,
356 "isGlobal": false,
357 "query": {
358 "measures": [
359 [
360 "sum",
361 "Amount",
362 "A",
363 {
364 "display": "Sum of Amount"
365 }
366 ],
367 [
368 "sum",
369 "Amount",
370 "B",
371 {
372 "display": "Running Total",
373 "format": "currencydollars"
374 }
375 ]
376 ],
377 "columns": [
378 {
379 "query": {
380 "measures": [
381 [
382 "sum",
383 "Amount"
384 ]
385 ],
386 "groups": [
387 [
388 "CreatedDate_Year",
389 "CreatedDate_Month"
390 ]
391 ]
392 }
393 },
394 {
395 "query": {
396 "measures": [
397 [
398 "sum",
399 "Amount"
400 ]
401 ],
402 "groups": [
403 [
404 "CreatedDate_Year",
405 "CreatedDate_Month"
406 ]
407 ],
408 "formula": "avg(A) over ([-1..0] partition by all order by ('CreatedDate_Year~~~CreatedDate_Month'))"
409 },
410 "format": "currencydollars",
411 "header": "Running Total"
412 }
413 ],
414 "groups": [
415 [
416 "CreatedDate_Year",
417 "CreatedDate_Month"
418 ]
419 ]
420 },
421 "selectMode": "single",
422 "type": "aggregate",
423 "useGlobal": true,
424 "visualizationParameters": {
425 "visualizationType": "hbar",
426 "options": {}
427 }
428 },
429 "Account_Industry_4": {
430 "datasets": [
431 {
432 "id": "0Fbx000000000LzCAI",
433 "label": "Opportunities",
434 "name": "opportunity1",
435 "url": "/services/data/v38.0/wave/datasets/0Fbx000000000LzCAI"
436 }
437 ],
438 "isFacet": true,
439 "isGlobal": false,
440 "query": {
441 "measures": [
442 [
443 "sum",
444 "Amount"
445 ]
446 ],
447 "groups": [
448 "Account.Industry"
449 ]
450 },
451 "type": "aggregate",
452 "useGlobal": true,
453 "visualizationParameters": {
454 "visualizationType": "pie",
455 "options": {}
456 }
457 },
458 "Amount_3": {
459 "datasets": [
460 {
461 "id": "0Fbx000000000LzCAI",
462 "label": "Opportunities",
463 "name": "opportunity1",
464 "url": "/services/data/v38.0/wave/datasets/0Fbx000000000LzCAI"
465 }
466 ],
467 "isFacet": true,
468 "isGlobal": false,
469 "query": {
470 "measures": [
471 [
472 "sum",
473 "Amount"
474 ]
475 ]
476 },
477 "type": "aggregate",
478 "useGlobal": true,
479 "visualizationParameters": {
480 "visualizationType": "hbar",
481 "options": {}
482 }
483 }
484 },
485 "widgetStyle": {
486 "backgroundColor": "#FFFFFF",
487 "borderColor": "#77B0AD",
488 "borderEdges": [
489 "top"
490 ],
491 "borderRadius": 0,
492 "borderWidth": 8
493 },
494 "widgets": {
495 "container_1": {
496 "parameters": {
497 "alignmentX": "left",
498 "alignmentY": "top",
499 "documentId": "",
500 "fit": "original"
501 },
502 "type": "container"
503 },
504 "number_2": {
505 "parameters": {
506 "compact": true,
507 "exploreLink": true,
508 "measureField": "sum_Amount",
509 "numberColor": "#335779",
510 "numberSize": 32,
511 "step": "LeadSource_6",
512 "textAlignment": "center",
513 "titleColor": "#335779",
514 "titleSize": 16
515 },
516 "type": "number"
517 },
518 "number_1": {
519 "parameters": {
520 "compact": true,
521 "exploreLink": true,
522 "measureField": "sum_Amount",
523 "numberColor": "#335779",
524 "numberSize": 32,
525 "step": "Amount_3",
526 "textAlignment": "center",
527 "titleColor": "#335779",
528 "titleSize": 16
529 },
530 "type": "number"
531 },
532 "text_1": {
533 "parameters": {
534 "fontSize": 20,
535 "text": "Industry",
536 "textAlignment": "center",
537 "textColor": "#000000"
538 },
539 "type": "text"
540 },
541 "container_4": {
542 "parameters": {
543 "alignmentX": "left",
544 "alignmentY": "top",
545 "documentId": "",
546 "fit": "original"
547 },
548 "type": "container"
549 },
550 "text_3": {
551 "parameters": {
552 "fontSize": 20,
553 "text": "Lead Source",
554 "textAlignment": "center",
555 "textColor": "#000000"
556 },
557 "type": "text"
558 },
559 "text_2": {
560 "parameters": {
561 "fontSize": 20,
562 "text": "Opportunity Overview Dashboard",
563 "textAlignment": "center",
564 "textColor": "#000000"
565 },
566 "type": "text"
567 },
568 "chart_5": {
569 "parameters": {
570 "autoFitMode": "fit",
571 "showValues": true,
572 "barSize": 25,
573 "legend": {
574 "showHeader": true,
575 "show": true,
576 "position": "bottom-center",
577 "inside": false
578 },
579 "axisMode": "multi",
580 "visualizationType": "stackhbar",
581 "exploreLink": true,
582 "title": {
583 "label": "",
584 "align": "center",
585 "subtitleLabel": ""
586 },
587 "trellis": {
588 "enable": false,
589 "type": "x",
590 "chartsPerLine": 4
591 },
592 "measureAxis2": {
593 "showTitle": true,
594 "showAxis": true,
595 "title": ""
596 },
597 "measureAxis1": {
598 "showTitle": true,
599 "showAxis": true,
600 "title": ""
601 },
602 "normalize": false,
603 "step": "CreatedDate_Year_CreatedDate_Month_9",
604 "theme": "wave",
605 "autoFit": false,
606 "dimensionAxis": {
607 "showTitle": true,
608 "showAxis": true,
609 "title": ""
610 }
611 },
612 "type": "chart"
613 },
614 "chart_2": {
615 "parameters": {
616 "legend": {
617 "showHeader": true,
618 "show": true,
619 "position": "right-top",
620 "inside": false
621 },
622 "showMeasureTitle": false,
623 "showTotal": true,
624 "visualizationType": "pie",
625 "step": "LeadSource_7",
626 "theme": "wave",
627 "exploreLink": true,
628 "title": {
629 "label": "",
630 "align": "center",
631 "subtitleLabel": ""
632 },
633 "trellis": {
634 "enable": false,
635 "type": "x",
636 "chartsPerLine": 4
637 },
638 "inner": 50
639 },
640 "type": "chart"
641 },
642 "chart_1": {
643 "parameters": {
644 "autoFitMode": "fit",
645 "showValues": true,
646 "barSize": 25,
647 "legend": {
648 "showHeader": true,
649 "show": true,
650 "position": "right-top",
651 "inside": false
652 },
653 "axisMode": "multi",
654 "visualizationType": "hbar",
655 "exploreLink": true,
656 "title": {
657 "label": "",
658 "align": "center",
659 "subtitleLabel": ""
660 },
661 "trellis": {
662 "enable": false,
663 "type": "x",
664 "chartsPerLine": 4
665 },
666 "measureAxis2": {
667 "showTitle": true,
668 "showAxis": true,
669 "title": ""
670 },
671 "measureAxis1": {
672 "showTitle": false,
673 "showAxis": true,
674 "title": ""
675 },
676 "step": "Account_Industry_4",
677 "theme": "wave",
678 "autoFit": false,
679 "dimensionAxis": {
680 "showTitle": true,
681 "showAxis": true,
682 "title": "Industries"
683 }
684 },
685 "type": "chart"
686 }
687 }
688 },
689 "datasets": [
690 {
691 "id": "0Fbx000000000LzCAI",
692 "label": "Opportunities",
693 "name": "opportunity1",
694 "url": "/services/data/v38.0/wave/datasets/0Fbx000000000LzCAI"
695 }
696 ]
697}この JSON ファイルは、Wave デザイナで作成された次のダッシュボードを定義します。 
このダッシュボードには次のウィジェットが表示されます。
- ファセットされた 2 つの数値ウィジェット: number_1 (ステップ Amount_3 に基づく) と number_2 (ステップ LeadSource_6 に基づく)。
- ファセットされた 3 つのグラフウィジェット: 1 つの棒グラフ chart_5 (ステップ Account_Industry_4 に基づく)、1 つの円グラフ chart_2 (ステップ LeadSource_7 に基づく)、および 1 つの積み上げ棒グラフ chart_5 (ステップ CreatedDate_Year_CreatedDate_Month_9 に基づく)。これらのステップは同じ 0Fbx000000000LzCAI データセットを参照します。
- 2 つのコンテナウィジェット (container_1 と container_4)。各コンテナウィジェットで数値ウィジェットとグラフをグループ化します。
- 2 つのテキストウィジェット (text_1 と text_3)。コンテナのラベルを提供します。