專案

一般

配置概況

下載 (4.3 KB)

工作單 #199 » P9801002-Unique Card Number Count.json

marlboro chu, 2025-06-30 02:03

 
{
"result" : {
"id" : 592,
"orgId" : 1,
"folderId" : 136,
"folderUid" : "bemeqa2prz7k0d",
"uid" : "demequun4z7cwb",
"name" : "P9801002-Unique Card Number Count",
"kind" : 1,
"type" : "stat",
"description" : "More descriptive of the data: how many different cards were involved.</font>",
"model" : {
"datasource" : {
"type" : "yesoreyeram-infinity-datasource",
"uid" : "aegaeyjq187b4e"
},
"description" : "More descriptive of the data: how many different cards were involved.</font>",
"fieldConfig" : {
"defaults" : {
"color" : {
"fixedColor" : "semi-dark-green",
"mode" : "fixed"
},
"mappings" : [ ],
"thresholds" : {
"mode" : "absolute",
"steps" : [ {
"color" : "green",
"value" : null
} ]
},
"unit" : "locale"
},
"overrides" : [ ]
},
"gridPos" : {
"h" : 3,
"w" : 5,
"x" : 5,
"y" : 1
},
"id" : 9801002,
"options" : {
"colorMode" : "value",
"graphMode" : "none",
"justifyMode" : "auto",
"orientation" : "auto",
"percentChangeColorMode" : "standard",
"reduceOptions" : {
"calcs" : [ "sum" ],
"fields" : "",
"values" : false
},
"showPercentChange" : false,
"textMode" : "auto",
"wideLayout" : true
},
"pluginVersion" : "11.4.0",
"targets" : [ {
"columns" : [ ],
"datasource" : {
"type" : "yesoreyeram-infinity-datasource",
"uid" : "aegaeyjq187b4e"
},
"filters" : [ ],
"format" : "table",
"global_query_id" : "",
"hide" : false,
"parser" : "backend",
"refId" : "A",
"root_selector" : "",
"source" : "url",
"type" : "json",
"url" : "/smartfds-adm-web/report/api/aggregation",
"url_options" : {
"body_content_type" : "application/json",
"body_type" : "raw",
"data" : "{\r\n\t\"size\": 0,\r\n\t\"query\": {\r\n\t\t\"bool\": {\r\n\t\t\t\"must\": [\r\n\t\t\t\t{ \"terms\": { \"operator_id\": ${operator_id:json} } },\r\n\t\t\t\t{ \"terms\": { \"institute_id\":${institute_id:json}}},\r\n\t\t\t\t{ \"range\": { \"create_datetime\": {\r\n\t\t\t\t\t\t\t\"lt\": ${__to},\r\n\t\t\t\t\t\t\t\"format\": \"epoch_millis\",\r\n\t\t\t\t\t\t\t\"gte\": ${__from}\r\n\t\t\t\t\t\t}\r\n\t\t\t\t\t}\r\n\t\t\t\t}\r\n\t\t\t]\r\n\t\t}\r\n\t},\r\n\t\"aggs\": {\r\n\t\t\"unique_txInfo__acctNumber\": {\r\n\t\t\t\"cardinality\": {\r\n\t\t\t\t\"field\": \"txInfo__acctNumber\"\r\n\t\t\t}\r\n\t\t}\r\n\t}\r\n}",
"method" : "GET",
"params" : [ {
"key" : "from_time",
"value" : "${__from}"
}, {
"key" : "to_time",
"value" : "${__to}"
}, {
"key" : "item_name",
"value" : "txInfo__acctNumber"
}, {
"key" : "operator_id",
"value" : "${operator_id}"
}, {
"key" : "institute_id",
"value" : "${institute_id}"
}, {
"key" : "merchant_id",
"value" : "${merchant_id}"
}, {
"key" : "auth_token",
"value" : "${auth_token}"
} ]
}
} ],
"title" : "A-02. Distinct Payment Cards Used",
"transformations" : [ {
"id" : "filterFieldsByName",
"options" : {
"include" : {
"names" : [ "unique_txInfo__acctNumber" ]
}
}
} ],
"type" : "stat"
},
"version" : 12,
"meta" : {
"folderName" : "R98-Library",
"folderUid" : "bemeqa2prz7k0d",
"connectedDashboards" : 4,
"created" : "2025-05-20T09:22:25+08:00",
"updated" : "2025-05-28T10:26:04+08:00",
"createdBy" : {
"avatarUrl" : "/avatar/ce6412d58e966caaa26cac12eb99734b",
"id" : 1,
"name" : "admin"
},
"updatedBy" : {
"avatarUrl" : "/avatar/ce6412d58e966caaa26cac12eb99734b",
"id" : 1,
"name" : "admin"
}
}
}
}
(8-8/30)