Sample Properties for a ReportPartElement

Note

See ReportPartElementProperties for the purpose of each field.

Sample for GROUP(OrderDate)


  1
  2
  3
  4
  5
  6
  7
  8
  9
 10
 11
 12
 13
 14
 15
 16
 17
 18
 19
 20
 21
 22
 23
 24
 25
 26
 27
 28
 29
 30
 31
 32
 33
 34
 35
 36
 37
 38
 39
 40
 41
 42
 43
 44
 45
 46
 47
 48
 49
 50
 51
 52
 53
 54
 55
 56
 57
 58
 59
 60
 61
 62
 63
 64
 65
 66
 67
 68
 69
 70
 71
 72
 73
 74
 75
 76
 77
 78
 79
 80
 81
 82
 83
 84
 85
 86
 87
 88
 89
 90
 91
 92
 93
 94
 95
 96
 97
 98
 99
100
101
102
103
104
105
106
107
108
109
110
111
112
{
   "name": "OrderDate",
   "other fields": "are not included in this sample",
   "properties": {
      "fieldItemVisible": true,
      "dataFormattings": {
         "function": "7f942ac7-08d8-41fa-9e89-bad96f07f102",
         "functionInfo": {
            "id": "7f942ac7-08d8-41fa-9e89-bad96f07f102",
            "name": "Group",
            "expression": null,
            "dataType": "Datetime",
            "formatDataType": "Datetime",
            "syntax": null,
            "expressionSyntax": null,
            "isOperator": false,
            "userDefined": false,
            "extendedProperties": {}
         },
         "format": {
            "formatId": "76875180-32c1-4180-b92f-03bdb14c4f6a",
            "format": "Year",
            "groupBy": "year",
            "formatDataType": null,
            "createNewHiddenPercenOfGroupField": false
         },
         "font": {
            "family": "Roboto",
            "size": 14,
            "bold": false,
            "italic": false,
            "underline": false,
            "color": "",
            "backgroundColor": ""
         },
         "width": {
            "value": null
         },
         "alignment": "alignLeft",
         "sort": "ASC",
         "color": {
            "textColor": {
               "rangePercent": null,
               "rangeValue": null,
               "value": null
            },
            "cellColor": {
               "rangePercent": null,
               "rangeValue": null,
               "value": null
            }
         },
         "alternativeText": {
            "rangePercent": null,
            "rangeValue": null,
            "value": null
         },
         "customURL": {
            "url": "",
            "option": "LINK_NEW_WINDOW"
         },
         "embeddedJavascript": {
            "script": ""
         },
         "subTotal": {
            "label": "",
            "function": "",
            "expression": "",
            "dataType": "",
            "format": {},
            "previewResult": ""
         },
         "grandTotal": {
            "label": "",
            "function": "",
            "expression": "",
            "dataType": "",
            "format": {},
            "previewResult": ""
         }
      },
      "headerFormating": {
         "font": {
            "family": null,
            "size": null,
            "bold": null,
            "italic": null,
            "underline": null,
            "color": null,
            "backgroundColor": null
         },
         "alignment": null,
         "wordWrap": null,
         "columnGroup": ""
      },
      "drillDown": {
         "subReport": {
            "selectedReport": null,
            "style": null,
            "reportPartUsed": null,
            "reportFilter": true,
            "mappingFields": [],
            "selectedIconValue": {
               "icon": null,
               "value": null
            },
            "viewSettingByLink": null
         }
      },
      "otherProps": {}
   }
}
Sample for SUM(Freight)


  1
  2
  3
  4
  5
  6
  7
  8
  9
 10
 11
 12
 13
 14
 15
 16
 17
 18
 19
 20
 21
 22
 23
 24
 25
 26
 27
 28
 29
 30
 31
 32
 33
 34
 35
 36
 37
 38
 39
 40
 41
 42
 43
 44
 45
 46
 47
 48
 49
 50
 51
 52
 53
 54
 55
 56
 57
 58
 59
 60
 61
 62
 63
 64
 65
 66
 67
 68
 69
 70
 71
 72
 73
 74
 75
 76
 77
 78
 79
 80
 81
 82
 83
 84
 85
 86
 87
 88
 89
 90
 91
 92
 93
 94
 95
 96
 97
 98
 99
100
101
102
103
104
105
106
107
108
{
   "name": "Sum (Freight)",
   "other fields": "are not included in this sample",
   "properties": {
      "fieldItemVisible": true,
      "dataFormattings": {
         "function": "902a9168-fc01-4a35-92fb-ea67942d099d",
         "functionInfo": {
            "id": "902a9168-fc01-4a35-92fb-ea67942d099d",
            "name": "Sum",
            "expression": null,
            "dataType": "Money",
            "formatDataType": "Money",
            "syntax": null,
            "expressionSyntax": null,
            "isOperator": false,
            "userDefined": false,
            "extendedProperties": {}
         },
         "format": {
            "createNewHiddenPercenOfGroupField": false
         },
         "font": {
            "family": "Roboto",
            "size": 14,
            "bold": false,
            "italic": false,
            "underline": false,
            "color": "",
            "backgroundColor": ""
         },
         "width": {
            "value": null
         },
         "alignment": "alignLeft",
         "sort": "ASC",
         "color": {
            "textColor": {
               "rangePercent": null,
               "rangeValue": null,
               "value": null
            },
            "cellColor": {
               "rangePercent": null,
               "rangeValue": null,
               "value": null
            }
         },
         "alternativeText": {
            "rangePercent": null,
            "rangeValue": null,
            "value": null
         },
         "customURL": {
            "url": "",
            "option": "LINK_NEW_WINDOW"
         },
         "embeddedJavascript": {
            "script": ""
         },
         "subTotal": {
            "label": "",
            "function": "",
            "expression": "",
            "dataType": "",
            "format": {},
            "previewResult": ""
         },
         "grandTotal": {
            "label": "",
            "function": "",
            "expression": "",
            "dataType": "",
            "format": {},
            "previewResult": ""
         }
      },
      "headerFormating": {
         "font": {
            "family": null,
            "size": null,
            "bold": null,
            "italic": null,
            "underline": null,
            "color": null,
            "backgroundColor": null
         },
         "alignment": null,
         "wordWrap": null,
         "columnGroup": ""
      },
      "drillDown": {
         "subReport": {
            "selectedReport": null,
            "style": null,
            "reportPartUsed": null,
            "reportFilter": true,
            "mappingFields": [],
            "selectedIconValue": {
               "icon": null,
               "value": null
            },
            "viewSettingByLink": null
         }
      },
      "otherProps": {}
   }
}
Sample for SUM(Freight) with Gauge Static Threshold setting


  • “902a9168-fc01-4a35-92fb-ea67942d099d” is the id for SUM function
  • Get the list of functions from POST report/function/{function_mode}/{data_type}/(tenant_id)
  • The Gauge metric settings are also highlighted:
    • Scale from 4000 to 8000
    • Unit label shows “USD”
    • Static threshold levels: less than 5000, between 5000 and 7000, greater than 7000
  1
  2
  3
  4
  5
  6
  7
  8
  9
 10
 11
 12
 13
 14
 15
 16
 17
 18
 19
 20
 21
 22
 23
 24
 25
 26
 27
 28
 29
 30
 31
 32
 33
 34
 35
 36
 37
 38
 39
 40
 41
 42
 43
 44
 45
 46
 47
 48
 49
 50
 51
 52
 53
 54
 55
 56
 57
 58
 59
 60
 61
 62
 63
 64
 65
 66
 67
 68
 69
 70
 71
 72
 73
 74
 75
 76
 77
 78
 79
 80
 81
 82
 83
 84
 85
 86
 87
 88
 89
 90
 91
 92
 93
 94
 95
 96
 97
 98
 99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
{
   "name": "Sum (Freight)",
   "properties": {
      "fieldItemVisible": true,
      "dataFormattings": {
         "function": "902a9168-fc01-4a35-92fb-ea67942d099d",
         "functionInfo": {
            "id": "902a9168-fc01-4a35-92fb-ea67942d099d",
            "name": "Sum",
            "expression": null,
            "dataType": "Money",
            "formatDataType": "Money",
            "syntax": null,
            "expressionSyntax": null,
            "isOperator": false,
            "userDefined": false,
            "extendedProperties": {}
         },
         "format": {
            "createNewHiddenPercenOfGroupField": false
         },
         "font": {
            "family": "Roboto",
            "size": 14,
            "bold": false,
            "italic": false,
            "underline": false,
            "color": "",
            "backgroundColor": ""
         },
         "width": {
            "value": null
         },
         "alignment": "alignLeft",
         "sort": "ASC",
         "color": {
            "textColor": {
               "rangePercent": null,
               "rangeValue": null,
               "value": null
            },
            "cellColor": {
               "rangePercent": null,
               "rangeValue": null,
               "value": null
            }
         },
         "alternativeText": {
            "rangePercent": null,
            "rangeValue": null,
            "value": null
         },
         "customURL": {
            "url": "",
            "option": "LINK_NEW_WINDOW"
         },
         "embeddedJavascript": {
            "script": ""
         },
         "subTotal": {
            "label": "",
            "function": "",
            "expression": "",
            "dataType": "",
            "format": {},
            "previewResult": ""
         },
         "grandTotal": {
            "label": "",
            "function": "",
            "expression": "",
            "dataType": "",
            "format": {},
            "previewResult": ""
         }
      },
      "headerFormating": {
         "font": {
            "family": null,
            "size": null,
            "bold": null,
            "italic": null,
            "underline": null,
            "color": null,
            "backgroundColor": null
         },
         "alignment": null,
         "wordWrap": null,
         "columnGroup": ""
      },
      "drillDown": {
         "subReport": {
            "selectedReport": null,
            "style": null,
            "reportPartUsed": null,
            "reportFilter": true,
            "mappingFields": [],
            "selectedIconValue": {
               "icon": null,
               "value": null
            },
            "viewSettingByLink": null
         }
      },
      "otherProps": {},
      "metric": {
         "scale": {
            "from": 4000,
            "to": 8000
         },
         "unitLabel": "USD",
         "thresholds": {
            "setting": "static",
            "levels": [
               {
                  "name": "low",
                  "color": "#55BF3B",
                  "operator": "less than",
                  "value": null,
                  "valueUpper": 5000,
                  "element": null,
                  "elementUpper": null
               },
               {
                  "name": "target",
                  "color": "#DDDF0D",
                  "operator": "between",
                  "value": 5000,
                  "valueUpper": 7000,
                  "element": null,
                  "elementUpper": null
               },
               {
                  "name": "high",
                  "color": "#DF5353",
                  "operator": "greater than",
                  "value": 7000,
                  "valueUpper": null,
                  "element": null,
                  "elementUpper": null
               }
            ]
         },
         "supplementaryKPI": {
            "valueType": "",
            "unitLabel": "",
            "value": null,
            "element": null
         }
      }
   },
   "position": 1,
   "field": {
      "fieldId": "61b3c4ad-cbd4-49b0-9385-540568397e05",
      "fieldName": "Freight",
      "fieldNameAlias": "Sum (Freight)",
      "dataFieldType": "Money",
      "querySourceId": "af773c7b-878e-461b-9345-27ee6592db1a",
      "querySourceType": "Table",
      "sourceAlias": "Orders",
      "relationshipId": "00000000-0000-0000-0000-000000000000",
      "visible": true,
      "calculatedTree": null,
      "isCalculated": false,
      "hasAggregatedFunction": false
   }
}
Sample for SUM(UnitsInStock) with Gauge Dynamic Threshold setting


  1
  2
  3
  4
  5
  6
  7
  8
  9
 10
 11
 12
 13
 14
 15
 16
 17
 18
 19
 20
 21
 22
 23
 24
 25
 26
 27
 28
 29
 30
 31
 32
 33
 34
 35
 36
 37
 38
 39
 40
 41
 42
 43
 44
 45
 46
 47
 48
 49
 50
 51
 52
 53
 54
 55
 56
 57
 58
 59
 60
 61
 62
 63
 64
 65
 66
 67
 68
 69
 70
 71
 72
 73
 74
 75
 76
 77
 78
 79
 80
 81
 82
 83
 84
 85
 86
 87
 88
 89
 90
 91
 92
 93
 94
 95
 96
 97
 98
 99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
{
   "type": 2,
   "title": {
      "text": "",
      "properties": {},
      "settings": {
         "font": {
            "family": "",
            "size": 14,
            "bold": true,
            "italic": false,
            "underline": false,
            "color": "",
            "highlightColor": ""
         },
         "alignment": {
            "alignment": ""
         }
      },
      "elements": []
   },
   "description": {
      "text": "",
      "properties": {},
      "settings": {
         "font": {
            "family": "",
            "size": 14,
            "bold": false,
            "italic": false,
            "underline": false,
            "color": "",
            "highlightColor": ""
         },
         "alignment": {
            "alignment": ""
         }
      },
      "elements": []
   },
   "activeSerie": null,
   "labels": {
      "elements": [
         {
            "name": "SupplierID",
            "properties": {
               "fieldItemVisible": true,
               "dataFormattings": {
                  "function": "7f942ac7-08d8-41fa-9e89-bad96f07f102",
                  "functionInfo": {
                     "id": "7f942ac7-08d8-41fa-9e89-bad96f07f102",
                     "name": "Group",
                     "expression": null,
                     "dataType": "Numeric",
                     "formatDataType": "Numeric",
                     "syntax": null,
                     "expressionSyntax": null,
                     "isOperator": false,
                     "userDefined": false,
                     "extendedProperties": {}
                  },
                  "format": {},
                  "font": {
                     "family": "Roboto",
                     "size": 14,
                     "bold": false,
                     "italic": false,
                     "underline": false,
                     "color": "",
                     "backgroundColor": ""
                  },
                  "width": {
                     "value": null
                  },
                  "alignment": "alignLeft",
                  "sort": "ASC",
                  "color": {
                     "textColor": {
                        "rangePercent": null,
                        "rangeValue": null,
                        "value": null
                     },
                     "cellColor": {
                        "rangePercent": null,
                        "rangeValue": null,
                        "value": null
                     }
                  },
                  "alternativeText": {
                     "rangePercent": null,
                     "rangeValue": null,
                     "value": null
                  },
                  "customURL": {
                     "url": "",
                     "option": "LINK_NEW_WINDOW"
                  },
                  "embeddedJavascript": {
                     "script": ""
                  },
                  "subTotal": {
                     "label": "",
                     "function": "",
                     "expression": "",
                     "dataType": "",
                     "format": {},
                     "previewResult": ""
                  },
                  "grandTotal": {
                     "label": "",
                     "function": "",
                     "expression": "",
                     "dataType": "",
                     "format": {},
                     "previewResult": ""
                  }
               },
               "headerFormating": {
                  "font": {
                     "family": null,
                     "size": null,
                     "bold": null,
                     "italic": null,
                     "underline": null,
                     "color": null,
                     "backgroundColor": null
                  },
                  "alignment": null,
                  "wordWrap": null,
                  "columnGroup": ""
               },
               "drillDown": {
                  "subReport": {
                     "selectedReport": null,
                     "style": null,
                     "reportPartUsed": null,
                     "reportFilter": true,
                     "mappingFields": [],
                     "selectedIconValue": {
                        "icon": null,
                        "value": null
                     },
                     "viewSettingByLink": null
                  }
               },
               "otherProps": {}
            },
            "position": 1,
            "field": {
               "fieldId": "a79ccaa4-d294-4b02-aed8-70f7ea1ee303",
               "fieldName": "SupplierID",
               "fieldNameAlias": "SupplierID",
               "dataFieldType": "Numeric",
               "querySourceId": "59c2e0a9-138a-4d29-b12d-bf98f99f6cc3",
               "querySourceType": "Table",
               "sourceAlias": "Products",
               "relationshipId": null,
               "visible": true,
               "calculatedTree": null,
               "schemaName": "dbo",
               "querySourceName": "Products",
               "databaseName": "Northwind",
               "isCalculated": false,
               "hasAggregatedFunction": false
            }
         }
      ],
      "name": "labels"
   },
   "values": {
      "elements": [
         {
            "name": "Sum (UnitsInStock)",
            "properties": {
               "fieldItemVisible": true,
               "dataFormattings": {
                  "function": "902a9168-fc01-4a35-92fb-ea67942d099d",
                  "functionInfo": {
                     "id": "902a9168-fc01-4a35-92fb-ea67942d099d",
                     "name": "Sum",
                     "expression": null,
                     "dataType": "Numeric",
                     "formatDataType": "Numeric",
                     "syntax": null,
                     "expressionSyntax": null,
                     "isOperator": false,
                     "userDefined": false,
                     "extendedProperties": {}
                  },
                  "format": {},
                  "font": {
                     "family": "Roboto",
                     "size": 14,
                     "bold": false,
                     "italic": false,
                     "underline": false,
                     "color": "",
                     "backgroundColor": ""
                  },
                  "width": {
                     "value": null
                  },
                  "alignment": "alignLeft",
                  "sort": "ASC",
                  "color": {
                     "textColor": {
                        "rangePercent": null,
                        "rangeValue": null,
                        "value": null
                     },
                     "cellColor": {
                        "rangePercent": null,
                        "rangeValue": null,
                        "value": null
                     }
                  },
                  "alternativeText": {
                     "rangePercent": null,
                     "rangeValue": null,
                     "value": null
                  },
                  "customURL": {
                     "url": "",
                     "option": "LINK_NEW_WINDOW"
                  },
                  "embeddedJavascript": {
                     "script": ""
                  },
                  "subTotal": {
                     "label": "",
                     "function": "",
                     "expression": "",
                     "dataType": "",
                     "format": {},
                     "previewResult": ""
                  },
                  "grandTotal": {
                     "label": "",
                     "function": "",
                     "expression": "",
                     "dataType": "",
                     "format": {},
                     "previewResult": ""
                  }
               },
               "headerFormating": {
                  "font": {
                     "family": null,
                     "size": null,
                     "bold": null,
                     "italic": null,
                     "underline": null,
                     "color": null,
                     "backgroundColor": null
                  },
                  "alignment": null,
                  "wordWrap": null,
                  "columnGroup": ""
               },
               "drillDown": {
                  "subReport": {
                     "selectedReport": null,
                     "style": null,
                     "reportPartUsed": null,
                     "reportFilter": true,
                     "mappingFields": [],
                     "selectedIconValue": {
                        "icon": null,
                        "value": null
                     },
                     "viewSettingByLink": null
                  }
               },
               "otherProps": {},
               "metric": {
                  "scale": {
                     "from": null,
                     "to": null
                  },
                  "unitLabel": "",
                  "thresholds": {
                     "setting": "dynamic",
                     "levels": [
                        {
                           "name": "low",
                           "color": "#ff0000",
                           "operator": "less than",
                           "value": null,
                           "valueUpper": null,
                           "element": null,
                           "elementUpper": {
                              "name": "Sum (UnitsOnOrder)",
                              "properties": {
                                 "fieldItemVisible": true,
                                 "dataFormattings": {
                                    "function": "902a9168-fc01-4a35-92fb-ea67942d099d",
                                    "functionInfo": {
                                       "id": "902a9168-fc01-4a35-92fb-ea67942d099d",
                                       "name": "Sum",
                                       "expression": null,
                                       "dataType": "Numeric",
                                       "formatDataType": "Numeric",
                                       "syntax": null,
                                       "expressionSyntax": null,
                                       "isOperator": false,
                                       "userDefined": false,
                                       "extendedProperties": {}
                                    },
                                    "format": {},
                                    "font": {
                                       "family": "Roboto",
                                       "size": 14,
                                       "bold": false,
                                       "italic": false,
                                       "underline": false,
                                       "color": "",
                                       "backgroundColor": ""
                                    },
                                    "width": {
                                       "value": null
                                    },
                                    "alignment": "alignLeft",
                                    "sort": "ASC",
                                    "color": {
                                       "textColor": {
                                          "rangePercent": null,
                                          "rangeValue": null,
                                          "value": null
                                       },
                                       "cellColor": {
                                          "rangePercent": null,
                                          "rangeValue": null,
                                          "value": null
                                       }
                                    },
                                    "alternativeText": {
                                       "rangePercent": null,
                                       "rangeValue": null,
                                       "value": null
                                    },
                                    "customURL": {
                                       "url": "",
                                       "option": "LINK_NEW_WINDOW"
                                    },
                                    "embeddedJavascript": {
                                       "script": ""
                                    },
                                    "subTotal": {
                                       "label": "",
                                       "function": "",
                                       "expression": "",
                                       "dataType": "",
                                       "format": {},
                                       "previewResult": ""
                                    },
                                    "grandTotal": {
                                       "label": "",
                                       "function": "",
                                       "expression": "",
                                       "dataType": "",
                                       "format": {},
                                       "previewResult": ""
                                    }
                                 },
                                 "headerFormating": {
                                    "font": {
                                       "family": null,
                                       "size": null,
                                       "bold": null,
                                       "italic": null,
                                       "underline": null,
                                       "color": null,
                                       "backgroundColor": null
                                    },
                                    "alignment": null,
                                    "wordWrap": null,
                                    "columnGroup": ""
                                 },
                                 "drillDown": {
                                    "subReport": {
                                       "selectedReport": null,
                                       "style": null,
                                       "reportPartUsed": null,
                                       "reportFilter": true,
                                       "mappingFields": [],
                                       "selectedIconValue": {
                                          "icon": null,
                                          "value": null
                                       },
                                       "viewSettingByLink": null
                                    }
                                 },
                                 "otherProps": {}
                              },
                              "position": 1,
                              "field": {
                                 "fieldId": "9baea98a-8cf8-46d9-8bcc-89a3374da404",
                                 "fieldName": "UnitsOnOrder",
                                 "fieldNameAlias": "Sum (UnitsOnOrder)",
                                 "dataFieldType": "Numeric",
                                 "querySourceId": "59c2e0a9-138a-4d29-b12d-bf98f99f6cc3",
                                 "querySourceType": "Table",
                                 "sourceAlias": "Products",
                                 "relationshipId": null,
                                 "visible": true,
                                 "calculatedTree": null,
                                 "schemaName": "dbo",
                                 "querySourceName": "Products",
                                 "databaseName": "Northwind",
                                 "isCalculated": false,
                                 "hasAggregatedFunction": false
                              }
                           }
                        },
                        {
                           "name": "target",
                           "color": "#008000",
                           "operator": "less than",
                           "value": null,
                           "valueUpper": null,
                           "element": {
                              "name": "Sum (UnitsOnOrder)",
                              "properties": {
                                 "fieldItemVisible": true,
                                 "dataFormattings": {
                                    "function": "902a9168-fc01-4a35-92fb-ea67942d099d",
                                    "functionInfo": {
                                       "id": "902a9168-fc01-4a35-92fb-ea67942d099d",
                                       "name": "Sum",
                                       "expression": null,
                                       "dataType": "Numeric",
                                       "formatDataType": "Numeric",
                                       "syntax": null,
                                       "expressionSyntax": null,
                                       "isOperator": false,
                                       "userDefined": false,
                                       "extendedProperties": {}
                                    },
                                    "format": {},
                                    "font": {
                                       "family": "Roboto",
                                       "size": 14,
                                       "bold": false,
                                       "italic": false,
                                       "underline": false,
                                       "color": "",
                                       "backgroundColor": ""
                                    },
                                    "width": {
                                       "value": null
                                    },
                                    "alignment": "alignLeft",
                                    "sort": "ASC",
                                    "color": {
                                       "textColor": {
                                          "rangePercent": null,
                                          "rangeValue": null,
                                          "value": null
                                       },
                                       "cellColor": {
                                          "rangePercent": null,
                                          "rangeValue": null,
                                          "value": null
                                       }
                                    },
                                    "alternativeText": {
                                       "rangePercent": null,
                                       "rangeValue": null,
                                       "value": null
                                    },
                                    "customURL": {
                                       "url": "",
                                       "option": "LINK_NEW_WINDOW"
                                    },
                                    "embeddedJavascript": {
                                       "script": ""
                                    },
                                    "subTotal": {
                                       "label": "",
                                       "function": "",
                                       "expression": "",
                                       "dataType": "",
                                       "format": {},
                                       "previewResult": ""
                                    },
                                    "grandTotal": {
                                       "label": "",
                                       "function": "",
                                       "expression": "",
                                       "dataType": "",
                                       "format": {},
                                       "previewResult": ""
                                    }
                                 },
                                 "headerFormating": {
                                    "font": {
                                       "family": null,
                                       "size": null,
                                       "bold": null,
                                       "italic": null,
                                       "underline": null,
                                       "color": null,
                                       "backgroundColor": null
                                    },
                                    "alignment": null,
                                    "wordWrap": null,
                                    "columnGroup": ""
                                 },
                                 "drillDown": {
                                    "subReport": {
                                       "selectedReport": null,
                                       "style": null,
                                       "reportPartUsed": null,
                                       "reportFilter": true,
                                       "mappingFields": [],
                                       "selectedIconValue": {
                                          "icon": null,
                                          "value": null
                                       },
                                       "viewSettingByLink": null
                                    }
                                 },
                                 "otherProps": {}
                              },
                              "position": 1,
                              "field": {
                                 "fieldId": "9baea98a-8cf8-46d9-8bcc-89a3374da404",
                                 "fieldName": "UnitsOnOrder",
                                 "fieldNameAlias": "Sum (UnitsOnOrder)",
                                 "dataFieldType": "Numeric",
                                 "querySourceId": "59c2e0a9-138a-4d29-b12d-bf98f99f6cc3",
                                 "querySourceType": "Table",
                                 "sourceAlias": "Products",
                                 "relationshipId": null,
                                 "visible": true,
                                 "calculatedTree": null,
                                 "schemaName": "dbo",
                                 "querySourceName": "Products",
                                 "databaseName": "Northwind",
                                 "isCalculated": false,
                                 "hasAggregatedFunction": false
                              },
                              "isDeleted": false,
                              "isSelected": false
                           },
                           "elementUpper": null
                        },
                        {
                           "name": "high",
                           "color": "#000000",
                           "operator": "greater than",
                           "value": null,
                           "valueUpper": null,
                           "element": null,
                           "elementUpper": null
                        }
                     ]
                  },
                  "supplementaryKPI": {
                     "valueType": "",
                     "unitLabel": "",
                     "value": null,
                     "element": null
                  }
               }
            },
            "position": 1,
            "field": {
               "fieldId": "bbd3b5a1-4be2-40c3-be9f-89e19a9487df",
               "fieldName": "UnitsInStock",
               "fieldNameAlias": "Sum (UnitsInStock)",
               "dataFieldType": "Numeric",
               "querySourceId": "59c2e0a9-138a-4d29-b12d-bf98f99f6cc3",
               "querySourceType": "Table",
               "sourceAlias": "Products",
               "relationshipId": null,
               "visible": true,
               "calculatedTree": null,
               "schemaName": "dbo",
               "querySourceName": "Products",
               "databaseName": "Northwind",
               "isCalculated": false,
               "hasAggregatedFunction": false
            }
         }
      ],
      "name": "values"
   },
   "separators": {
      "elements": [],
      "name": "separators"
   },
   "properties": {
      "staticProperties": {},
      "chartType": "SolidGauge",
      "optionByType": {
         "izUseSeparator": true,
         "izUsePagination": true,
         "izItemPerRow": 2
      },
      "view": {
         "showLabels": false,
         "dataRefreshInterval": {
            "enable": false,
            "updateInterval": 0,
            "isAll": true,
            "latestRecord": 0
         }
      },
      "printing": {
         "izPageBreakAfterSeparator": false
      }
   }
}