Analytics ダッシュボード JSON リファレンス
jAnalytics ダッシュボードの JSON の例
各 Analytics ダッシュボードの JSON には、複数レベルのプロパティが含まれます。ダッシュボードの基本的な JSON 構造については、このセクションのサンプルの JSON を確認してください。
例
サンプルの JSON は、このダッシュボードを定義しています。
Account Analysis ダッシュボードは次のオブジェクトで構成されています。
- レイアウト:
- デフォルト、次のページが含まれます。
- ページ 1
- ページ 2
- モバイル
- デフォルト、次のページが含まれます。
- ウィジェット:
- ステップ lens_1 に基づく値テーブル table_1 (ページ 2 にのみ存在するためこのスクリーンショットには表示されていません)。
- グローバル検索条件パネル filterpanel_1
- リンク link_1
- ステップ Amount_by_Acct_Owner_1 に基づく横棒グラフ chart_1
- ステップ:
- Amount_by_Acct_Owner_1
- Account_Owner_Name_1
- lens_1
- データセット 0FbB000000017QxKAI
1{
2 "label": "Account Analysis",
3 "mobileDisabled": false,
4 "state": {
5 "dataSourceLinks": [],
6 "filters": [
7 {
8 "dataset": {
9 "id": "0FbB000000017QxKAI",
10 "name": "opportunity",
11 "url": "/services/data/v41.0/wave/datasets/0FbB000000017QxKAI"
12 },
13 "fields": [
14 "Account.Owner.Name"
15 ],
16 "label": "Account.Owner.Name",
17 "locked": false,
18 "operator": "in",
19 "value": [
20 "Annie Kelly",
21 "Bill Johnson",
22 "Chan Lao",
23 "Ellen Bruxton",
24 "Erin Baker",
25 "Frank Tom",
26 "Jason Hunt",
27 "Jennifer McCarthy",
28 "Leslie Pham",
29 "Michelle Nguyen",
30 "Nathan Sinha",
31 "Norman Truman",
32 "Priya Anand",
33 "Rob Wilkens",
34 "Sam Gunderson",
35 "Valerie Thom",
36 "Walker Chan",
37 "Wang Lee"
38 ]
39 },
40 {
41 "dataset": {
42 "id": "0FbB000000017QxKAI",
43 "name": "opportunity",
44 "url": "/services/data/v41.0/wave/datasets/0FbB000000017QxKAI"
45 },
46 "fields": [
47 "Close Date"
48 ],
49 "label": "Close Date",
50 "locked": false,
51 "operator": ">=<=",
52 "value": [
53 [
54 1451635200000,
55 1564642800000
56 ]
57 ]
58 }
59 ],
60 "gridLayouts": [
61 {
62 "name": "Default",
63 "numColumns": 9,
64 "pages": [
65 {
66 "label": "Page 1",
67 "name": "41f040d6-48a6-4dc7-9166-eb985df7e9d8",
68 "widgets": [
69 {
70 "colspan": 9,
71 "column": 0,
72 "name": "filterpanel_1",
73 "row": 0,
74 "rowspan": 3,
75 "widgetStyle": {
76 "borderEdges": []
77 }
78 },
79 {
80 "colspan": 9,
81 "column": 0,
82 "name": "chart_1",
83 "row": 3,
84 "rowspan": 5,
85 "widgetStyle": {
86 "borderEdges": []
87 }
88 },
89 {
90 "colspan": 2,
91 "column": 0,
92 "name": "link_1",
93 "row": 8,
94 "rowspan": 1,
95 "widgetStyle": {
96 "borderEdges": []
97 }
98 }
99 ]
100 },
101 {
102 "label": "Page 2",
103 "name": "ac750443-1729-47fb-8d60-a35703076bf7",
104 "widgets": [
105 {
106 "colspan": 9,
107 "column": 0,
108 "name": "filterpanel_1",
109 "row": 0,
110 "rowspan": 3,
111 "widgetStyle": {
112 "borderEdges": []
113 }
114 },
115 {
116 "colspan": 9,
117 "column": 0,
118 "name": "table_1",
119 "row": 3,
120 "rowspan": 7,
121 "widgetStyle": {
122 "borderEdges": []
123 }
124 }
125 ]
126 }
127 ],
128 "rowHeight": "normal",
129 "selectors": [],
130 "style": {
131 "alignmentX": "left",
132 "alignmentY": "top",
133 "backgroundColor": "#44A2F5",
134 "cellSpacingX": 4,
135 "cellSpacingY": 4,
136 "fit": "original",
137 "gutterColor": "#A3B8CC"
138 },
139 "version": 1
140 },
141 {
142 "name": "Mobile",
143 "numColumns": 2,
144 "pages": [
145 {
146 "label": "Page 1",
147 "name": "41f040d6-48a6-4dc7-9166-eb985df7e9d8",
148 "widgets": [
149 {
150 "colspan": 2,
151 "column": 0,
152 "name": "filterpanel_1",
153 "row": 0,
154 "rowspan": 2,
155 "widgetStyle": {
156 "borderEdges": []
157 }
158 },
159 {
160 "colspan": 2,
161 "column": 0,
162 "name": "chart_1",
163 "row": 2,
164 "rowspan": 10,
165 "widgetStyle": {
166 "borderEdges": []
167 }
168 }
169 ]
170 }
171 ],
172 "rowHeight": "normal",
173 "selectors": [
174 "maxWidth(599)"
175 ],
176 "style": {
177 "alignmentX": "left",
178 "alignmentY": "top",
179 "backgroundColor": "#2EC2BA",
180 "cellSpacingX": 4,
181 "cellSpacingY": 4,
182 "fit": "original",
183 "gutterColor": "#091A3E"
184 },
185 "version": 1
186 }
187 ],
188 "layouts": [],
189 "steps": {
190 "Amount_by_Acct_Owner_1": {
191 "broadcastFacet": true,
192 "datasets": [
193 {
194 "id": "0FbB000000017QxKAI",
195 "label": "Opportunities",
196 "name": "opportunity",
197 "url": "/services/data/v41.0/wave/datasets/0FbB000000017QxKAI"
198 }
199 ],
200 "isGlobal": false,
201 "label": "Amount by Acct Owner",
202 "query": {
203 "measures": [
204 [
205 "count",
206 "*"
207 ]
208 ],
209 "groups": [
210 "Account.Owner.Name"
211 ],
212 "order": [
213 [
214 "count",
215 {
216 "ascending": false
217 }
218 ]
219 ]
220 },
221 "receiveFacet": true,
222 "selectMode": "multi",
223 "type": "aggregateflex",
224 "useGlobal": true,
225 "visualizationParameters": {
226 "options": {},
227 "parameters": {
228 "autoFitMode": "none",
229 "showValues": true,
230 "bins": {
231 "breakpoints": {
232 "high": 100,
233 "low": 0
234 },
235 "bands": {
236 "high": {
237 "color": "#008000",
238 "label": ""
239 },
240 "low": {
241 "color": "#B22222",
242 "label": ""
243 },
244 "medium": {
245 "color": "#ffa500",
246 "label": ""
247 }
248 }
249 },
250 "legend": {
251 "showHeader": true,
252 "show": true,
253 "customSize": "auto",
254 "position": "right-top",
255 "inside": false
256 },
257 "axisMode": "multi",
258 "tooltip": {
259 "showBinLabel": true,
260 "measures": "",
261 "showPercentage": false,
262 "showDimensions": true,
263 "showMeasures": true,
264 "customizeTooltip": false,
265 "dimensions": ""
266 },
267 "visualizationType": "hbar",
268 "title": {
269 "fontSize": 14,
270 "subtitleFontSize": 11,
271 "label": "",
272 "align": "center",
273 "subtitleLabel": ""
274 },
275 "binValues": false,
276 "trellis": {
277 "flipLabels": false,
278 "showGridLines": true,
279 "size": [
280 100,
281 100
282 ],
283 "enable": false,
284 "type": "x",
285 "chartsPerLine": 4
286 },
287 "measureAxis2": {
288 "sqrtScale": false,
289 "showTitle": true,
290 "showAxis": true,
291 "title": "",
292 "customDomain": {
293 "showDomain": false
294 }
295 },
296 "measureAxis1": {
297 "sqrtScale": false,
298 "showTitle": true,
299 "showAxis": true,
300 "title": "",
301 "customDomain": {
302 "showDomain": false
303 }
304 },
305 "theme": "wave",
306 "dimensionAxis": {
307 "showTitle": true,
308 "customSize": "auto",
309 "showAxis": true,
310 "title": "",
311 "icons": {
312 "useIcons": false,
313 "iconProps": {
314 "fit": "cover",
315 "column": "",
316 "type": "round"
317 }
318 }
319 }
320 },
321 "type": "chart",
322 "visualizationType": "hbar"
323 }
324 },
325 "Account_Owner_Name_1": {
326 "broadcastFacet": true,
327 "datasets": [
328 {
329 "id": "0FbB000000017QxKAI",
330 "label": "Opportunities",
331 "name": "opportunity",
332 "url": "/services/data/v41.0/wave/datasets/0FbB000000017QxKAI"
333 }
334 ],
335 "isGlobal": false,
336 "query": {
337 "measures": [
338 [
339 "count",
340 "*"
341 ],
342 [
343 "avg",
344 "Amount"
345 ]
346 ],
347 "groups": [
348 "Account.Owner.Name"
349 ],
350 "order": [
351 [
352 "count",
353 {
354 "ascending": false
355 }
356 ]
357 ]
358 },
359 "receiveFacet": true,
360 "selectMode": "single",
361 "type": "aggregateflex",
362 "useGlobal": true,
363 "visualizationParameters": {
364 "parameters": {
365 "autoFitMode": "none",
366 "showPoints": false,
367 "legend": {
368 "showHeader": true,
369 "show": true,
370 "customSize": "auto",
371 "position": "right-top",
372 "inside": false
373 },
374 "axisMode": "multi",
375 "tooltip": {
376 "showBinLabel": true,
377 "measures": "",
378 "showPercentage": false,
379 "showDimensions": true,
380 "showMeasures": true,
381 "customizeTooltip": false,
382 "dimensions": ""
383 },
384 "visualizationType": "line",
385 "dashLine": {
386 "measures": "",
387 "showDashLine": false
388 },
389 "title": {
390 "fontSize": 14,
391 "subtitleFontSize": 11,
392 "label": "",
393 "align": "center",
394 "subtitleLabel": ""
395 },
396 "trellis": {
397 "flipLabels": false,
398 "showGridLines": true,
399 "size": [
400 100,
401 100
402 ],
403 "enable": false,
404 "type": "x",
405 "chartsPerLine": 4
406 },
407 "fillArea": true,
408 "showZero": true,
409 "measureAxis2": {
410 "sqrtScale": false,
411 "showTitle": true,
412 "showAxis": true,
413 "title": "",
414 "customDomain": {
415 "showDomain": false
416 }
417 },
418 "measureAxis1": {
419 "sqrtScale": false,
420 "showTitle": true,
421 "showAxis": true,
422 "title": "",
423 "customDomain": {
424 "showDomain": false
425 }
426 },
427 "theme": "wave",
428 "dimensionAxis": {
429 "showTitle": true,
430 "customSize": "auto",
431 "showAxis": true,
432 "title": "",
433 "icons": {
434 "useIcons": false,
435 "iconProps": {
436 "fit": "cover",
437 "column": "",
438 "type": "round"
439 }
440 }
441 },
442 "drawArea": {
443 "measure": "",
444 "showDrawArea": false,
445 "bounding1": "",
446 "bounding2": ""
447 }
448 },
449 "type": "chart",
450 "options": {}
451 }
452 },
453 "lens_1": {
454 "datasets": [
455 {
456 "id": "0FbB000000017QxKAI",
457 "label": "Opportunities",
458 "name": "opportunity",
459 "url": "/services/data/v41.0/wave/datasets/0FbB000000017QxKAI"
460 }
461 ],
462 "isFacet": true,
463 "isGlobal": false,
464 "label": "lens_1",
465 "query": {
466 "values": [
467 "Name",
468 "Owner.Name",
469 "StageName",
470 "Amount",
471 "CloseDate",
472 "ForecastCategoryName",
473 "Account.Owner.Name"
474 ]
475 },
476 "selectMode": "none",
477 "type": "grain",
478 "useGlobal": true,
479 "visualizationParameters": {
480 "options": {},
481 "parameters": {
482 "borderColor": "#e0e5ee",
483 "borderWidth": 1,
484 "cell": {
485 "backgroundColor": "#ffffff",
486 "fontColor": "#16325c",
487 "fontSize": 12
488 },
489 "columns": [],
490 "customBulkActions": [],
491 "header": {
492 "backgroundColor": "#f4f6f9",
493 "fontColor": "#16325c",
494 "fontSize": 12
495 },
496 "innerMajorBorderColor": "#a8b7c7",
497 "innerMinorBorderColor": "#e0e5ee",
498 "maxColumnWidth": 300,
499 "minColumnWidth": 40,
500 "mode": "variable",
501 "numberOfLines": 1,
502 "totals": true,
503 "verticalPadding": 8
504 },
505 "type": "table",
506 "visualizationType": "valuestable"
507 }
508 }
509 },
510 "widgetStyle": {
511 "backgroundColor": "#FFFFFF",
512 "borderColor": "#E6ECF2",
513 "borderEdges": [],
514 "borderRadius": 0,
515 "borderWidth": 1
516 },
517 "widgets": {
518 "table_1": {
519 "parameters": {
520 "columnProperties": {
521 "Amount": {
522 "type": "bar",
523 "parameters": {}
524 }
525 }
526 "borderColor": "#e0e5ee",
527 "borderWidth": 1,
528 "cell": {
529 "backgroundColor": "#ffffff",
530 "fontColor": "#16325c",
531 "fontSize": 12
532 },
533 "columns": [],
534 "customBulkActions": [],
535 "exploreLink": true,
536 "header": {
537 "backgroundColor": "#f4f6f9",
538 "fontColor": "#16325c",
539 "fontSize": 12
540 },
541 "innerMajorBorderColor": "#a8b7c7",
542 "innerMinorBorderColor": "#e0e5ee",
543 "maxColumnWidth": 300,
544 "minColumnWidth": 40,
545 "mode": "variable",
546 "numberOfLines": 1,
547 "showRowIndexColumn": true,
548 "step": "lens_1",
549 "totals": true,
550 "verticalPadding": 8,
551 "evenRowColor": null,
552 "oddRowColor": null
553 },
554 "type": "table"
555 },
556 "filterpanel_1": {
557 "parameters": {
558 "filterItemOptions": {
559 "backgroundColor": "#FFFFFF",
560 "borderColor": "#E6ECF2",
561 "borderRadius": 4,
562 "propertyColor": "#54698D",
563 "valueColor": "#16325C",
564 "borderWidth": 1
565 },
566 "itemsPerRow": 2,
567 "title": {
568 "separatorColor": "#E6ECF2",
569 "text": {
570 "align": "left",
571 "color": "#091A3E",
572 "fontSize": 16,
573 "label": "Filters"
574 },
575 "visible": true
576 }
577 },
578 "type": "filterpanel"
579 },
580 "link_1": {
581 "parameters": {
582 "destinationLink": {
583 "name": "ac750443-1729-47fb-8d60-a35703076bf7"
584 },
585 "destinationType": "page",
586 "fontSize": 12,
587 "includeState": false,
588 "text": "Opp Details",
589 "textAlignment": "center",
590 "textColor": "#44A2F5"
591 },
592 "type": "link"
593 },
594 "chart_1": {
595 "parameters": {
596 "autoFitMode": "none",
597 "showValues": true,
598 "bins": {
599 "breakpoints": {
600 "high": 100,
601 "low": 0
602 },
603 "bands": {
604 "high": {
605 "color": "#008000",
606 "label": ""
607 },
608 "low": {
609 "color": "#B22222",
610 "label": ""
611 },
612 "medium": {
613 "color": "#ffa500",
614 "label": ""
615 }
616 }
617 },
618 "legend": {
619 "showHeader": true,
620 "show": true,
621 "customSize": "auto",
622 "position": "right-top",
623 "inside": false
624 },
625 "axisMode": "multi",
626 "tooltip": {
627 "showBinLabel": true,
628 "measures": "",
629 "showPercentage": false,
630 "showDimensions": true,
631 "showMeasures": true,
632 "customizeTooltip": false,
633 "dimensions": ""
634 },
635 "visualizationType": "hbar",
636 "exploreLink": true,
637 "title": {
638 "fontSize": 14,
639 "subtitleFontSize": 11,
640 "label": "",
641 "align": "center",
642 "subtitleLabel": ""
643 },
644 "binValues": false,
645 "trellis": {
646 "flipLabels": false,
647 "showGridLines": true,
648 "size": [
649 100,
650 100
651 ],
652 "enable": false,
653 "type": "x",
654 "chartsPerLine": 4
655 },
656 "measureAxis2": {
657 "sqrtScale": false,
658 "showTitle": true,
659 "showAxis": true,
660 "title": "",
661 "customDomain": {
662 "showDomain": false
663 }
664 },
665 "measureAxis1": {
666 "sqrtScale": false,
667 "showTitle": true,
668 "showAxis": true,
669 "title": "",
670 "customDomain": {
671 "showDomain": false
672 }
673 },
674 "theme": "wave",
675 "step": "Amount_by_Acct_Owner_1",
676 "dimensionAxis": {
677 "showTitle": true,
678 "customSize": "auto",
679 "showAxis": true,
680 "title": "",
681 "icons": {
682 "useIcons": false,
683 "iconProps": {
684 "fit": "cover",
685 "column": "",
686 "type": "round"
687 }
688 }
689 }
690 },
691 "type": "chart"
692 }
693 }
694 },
695 "datasets": [
696 {
697 "id": "0FbB000000017QxKAI",
698 "label": "Opportunities",
699 "name": "opportunity",
700 "url": "/services/data/v41.0/wave/datasets/0FbB000000017QxKAI"
701 }
702 ]
703}