...
Code Block |
---|
"_comment": "W&S charts below-----------------------------------------------------------------------", "wstodaysCollection": { "chartName": "DSS_W&S_TODAYS_COLLECTION", "queries": [ { "module": "W&S", "indexName": "dss-collection_v2", "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must\":[{\"range\":{\"dataObject.paymentDetails.receiptDate\":{\"gte\":\"now-1d\/d\",\"lte\":\"now\"}}},{\"terms\":{\"dataObject.paymentDetails.businessService.keyword\":[\"WS\",\"WS.ONE_TIME_FEE\",\"SW.ONE_TIME_FEE\",\"SW\"]}}],\"must_not\":[{\"term\":{\"dataObject.tenantId.keyword\":\"pb.testing\"}},{\"term\":{\"dataObject.paymentStatus.keyword\":\"Cancelled\"}}]}},\"aggs\":{\"Total Collection\":{\"sum\":{\"field\":\"dataObject.paymentDetails.totalAmountPaid\"}}}}}}", "requestQueryMap": "{\"tenantId\" : \"dataObject.tenantId.keyword\", \"wardId\" : \"domainObject.ward.name.keyword\"}", "dateRefField": "dataObject.paymentDetails.receiptDate" } ], "chartType": "metric", "valueType": "amount", "action": "", "drillChart": "none", "aggregationPaths": [ "Total Collection" ], "insight": { }, "_comment": "W&S todays collections " }, "wstotalCollection": { "chartName": "DSS_W&S_TOTAL_COLLECTION", "queries": [ { "module": "W&S", "indexName": "dss-collection_v2", "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must_not\":[{\"term\":{\"dataObject.tenantId.keyword\":\"pb.testing\"}},{\"terms\":{\"dataObject.paymentDetails.bill.status.keyword\":[\"Cancelled\"]}}],\"must\":[{\"terms\":{\"dataObject.paymentDetails.businessService.keyword\":[\"WS\",\"WS.ONE_TIME_FEE\",\"SW.ONE_TIME_FEE\",\"SW\"]}}]}},\"aggs\":{\"Total Collection\":{\"sum\":{\"field\":\"dataObject.paymentDetails.totalAmountPaid\"}}}}}}", "requestQueryMap": "{\"tenantId\" : \"dataObject.tenantId.keyword\", \"wardId\" : \"domainObject.ward.name.keyword\"}", "dateRefField": "dataObject.paymentDetails.receiptDate" } ], "translateTenantCode": false, "chartType": "metric", "valueType": "amount", "action": "", "drillChart": "none", "aggregationPaths": [ "Total Collection" ], "insight": { "chartResponseMap" : "wstotalCollection", "action" : "differenceOfNumbers", "upwardIndicator" : "positive", "downwardIndicator" : "negative", "textMessage" : "$indicator$value% than last $insightInterval", "colorCode" : "#228B22", "insightInterval" : "year", "isRoundOff": true }, "_comment": "W&S total collections " }, "wstargetCollection": { "chartName": "DSS_W&S_TARGET_COLLECTION", "queries": [ { "module": "W&S", "requestQueryMap": "{\"module\" : \"businessService.keyword\", \"tenantId\" : \"tenantIdForMunicipalCorporation.keyword\"}", "dateRefField": "", "indexName": "dss-target_v1", "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must\":[{\"term\":{\"businessService.keyword\":\"W&S\"}}]}},\"aggs\":{\"Target Collection\":{\"sum\":{\"field\":\"budgetProposedForMunicipalCorporation\"}}}}}}" } ], "chartType": "metric", "valueType": "amount", "action": "", "drillChart": "none", "documentType": "_doc", "aggregationPaths": [ "Target Collection" ], "isDayUnit": false, "postAggregationTheory" : "repsonseToDifferenceOfDates", "insight": { "chartResponseMap" : "wstargetCollection", "action" : "differenceOfNumbers", "upwardIndicator" : "positive", "downwardIndicator" : "negative", "textMessage" : "$indicator$value% than last $insightInterval", "colorCode" : "#228B22", "insightInterval" : "year", "isRoundOff": true }, "_comment": " " }, "wstargetAchieved": { "chartName": "DSS_W&S_TARGET_ACHIEVED", "queries": [ { "module": "W&S", "requestQueryMap": "{\r\n \"module\" : \"businessService.keyword\", \n\"tenantId\" : \"tenantIdForMunicipalCorporation.keyword\"}", "dateRefField": "", "indexName": "dss-target_v1", "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must\":[{\"term\":{\"businessService.keyword\":\"W&S\"}}]}},\"aggs\":{\"Target Collection\":{\"sum\":{\"field\":\"budgetProposedForMunicipalCorporation\"}}}}}}" }, { "module": "W&S", "requestQueryMap": "{\"tenantId\" : \"dataObject.tenantId.keyword\", \"wardId\" : \"domainObject.ward.name.keyword\"}", "dateRefField": "dataObject.paymentDetails.receiptDate", "indexName": "dss-collection_v2", "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must_not\":[{\"term\":{\"dataObject.tenantId.keyword\":\"pb.testing\"}},{\"terms\":{\"dataObject.paymentDetails.bill.status.keyword\":[\"Cancelled\"]}}],\"must\":[{\"terms\":{\"dataObject.paymentDetails.businessService.keyword\":[\"WS\",\"WS.ONE_TIME_FEE\",\"SW.ONE_TIME_FEE\",\"SW\"]}}]}},\"aggs\":{\"Total Collection\":{\"sum\":{\"field\":\"dataObject.paymentDetails.totalAmountPaid\"}}}}}}" } ], "translateTenantCode": false, "chartType": "metric", "valueType": "percentage", "drillChart": "none", "documentType": "_doc", "action": "percentage", "aggregationPaths": [ "Total Collection", "Target Collection" ], "preActionTheory":{ "Target Collection":"repsonseToDifferenceOfDates" }, "isRoundOff": true, "insight": { "chartResponseMap" : "wstargetAchieved", "action" : "differenceOfNumbers", "upwardIndicator" : "positive", "downwardIndicator" : "negative", "textMessage" : "$indicator$value% than last $insightInterval", "colorCode" : "#228B22", "insightInterval" : "year", "isRoundOff": true }, "_comment": " " }, "wscumulativeCollections": { "chartName": "DSS_W&S_TOTAL_CUMULATIVE_COLLECTION", "queries": [ { "module": "W&S", "dateRefField": "dataObject.paymentDetails.receiptDate", "requestQueryMap": "{\"tenantId\" : \"dataObject.tenantId.keyword\", \"wardId\" : \"domainObject.ward.name.keyword\"}", "indexName": "dss-collection_v2", "aggrQuery": "{\"aggs\":{\"Water Collections\":{\"date_histogram\":{\"field\":\"dataObject.paymentDetails.receiptDate\",\"interval\":\"intervalvalue\"},\"aggs\":{\"Water\":{\"filter\":{\"bool\":{\"must_not\":[{\"term\":{\"dataObject.tenantId.keyword\":\"pb.testing\"}},{\"terms\":{\"dataObject.paymentStatus.keyword\":[\"Cancelled\"]}}],\"must\":[{\"terms\":{\"dataObject.paymentStatus.keyword\":[\"DEPOSITED\",\"NEW\"]}},{\"terms\":{\"dataObject.paymentDetails.businessService.keyword\":[\"WS\",\"WS.ONE_TIME_FEE\"]}}]}},\"aggs\":{\"Count\":{\"sum\":{\"field\":\"dataObject.paymentDetails.totalAmountPaid\"}}}}}},\"Sewerage Collections\":{\"date_histogram\":{\"field\":\"dataObject.paymentDetails.receiptDate\",\"interval\":\"intervalvalue\"},\"aggs\":{\"Sewerage\":{\"filter\":{\"bool\":{\"must_not\":[{\"term\":{\"dataObject.tenantId.keyword\":\"pb.testing\"}},{\"terms\":{\"dataObject.paymentStatus.keyword\":[\"Cancelled\"]}}],\"must\":[{\"terms\":{\"dataObject.paymentStatus.keyword\":[\"DEPOSITED\",\"NEW\"]}},{\"terms\":{\"dataObject.paymentDetails.businessService.keyword\":[\"SW.ONE_TIME_FEE\",\"SW\"]}}]}},\"aggs\":{\"Count\":{\"sum\":{\"field\":\"dataObject.paymentDetails.totalAmountPaid\"}}}}}}}}" } ], "translateTenantCode": false, "chartType": "line", "valueType": "numberamount", "action": "", "drillChart": "none", "documentType": "_doc", "aggregationPaths": [ "Water Collections", "Sewerage Collections" ], "isCumulative": true, "interval": "month", "insight": { }, "_comment": " " }, "wstopPerformingUlbs": { "chartName": "DSS_W&S_TOP_3_PERFORMING_ULBS", "queries": [ { "module": "W&S", "requestQueryMap": "{\"module\" : \"businessService.keyword\", \"tenantId\" : \"tenantIdForMunicipalCorporation.keyword\"}", "dateRefField": "", "indexName": "dss-target_v1", "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must\":[{\"term\":{\"businessService.keyword\":\"W&S\"}}]}},\"aggs\":{\"Target Collection\":{\"terms\":{\"field\":\"tenantIdForMunicipalCorporation.keyword\",\"size\":\"200\",\"order\":{\"Sum\":\"desc\"}},\"aggs\":{\"Sum\":{\"sum\":{\"field\":\"budgetProposedForMunicipalCorporation\"}}}}}}}}" }, { "module": "W&S", "requestQueryMap": "{\"tenantId\" : \"dataObject.tenantId.keyword\", \"wardId\" : \"domainObject.ward.name.keyword\"}", "dateRefField": "dataObject.paymentDetails.receiptDate", "indexName": "dss-collection_v2", "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must_not\":[{\"term\":{\"dataObject.tenantId.keyword\":\"pb.testing\"}},{\"terms\":{\"dataObject.paymentDetails.bill.status.keyword\":[\"Cancelled\"]}}],\"must\":[{\"terms\":{\"dataObject.paymentDetails.businessService.keyword\":[\"WS\",\"WS.ONE_TIME_FEE\",\"SW.ONE_TIME_FEE\",\"SW\"]}}]}},\"aggs\":{\"Total Collection\":{\"terms\":{\"field\":\"dataObject.tenantId.keyword\",\"size\":\"200\",\"order\":{\"Sum\":\"desc\"}},\"aggs\":{\"Sum\":{\"sum\":{\"field\":\"dataObject.paymentDetails.totalAmountPaid\"}}}}}}}}" } ], "translateTenantCode": false, "chartType": "perform", "valueType": "percentage", "drillChart": "none", "documentType": "_doc", "action": "percentage", "plotLabel": "DSS_TARGET_ACHIEVED", "order": "desc", "limit": 3, "isRoundOff": true, "aggregationPaths": [ "Total Collection","Target Collection" ], "preActionTheory":{ "Target Collection":"repsonseToDifferenceOfDates" }, "insight": { }, "_comment": " Top Performing Ulbs for target achieved" }, "wsbottomPerformingUlbs": { "chartName": "DSS_W&S_BOTTOM_3_PERFORMING_ULBS", "queries": [ { "module": "W&S", "requestQueryMap": "{\"module\" : \"businessService.keyword\", \"tenantId\" : \"tenantIdForMunicipalCorporation.keyword\"}", "dateRefField": "", "indexName": "dss-target_v1", "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must\":[{\"term\":{\"businessService.keyword\":\"W&S\"}}]}},\"aggs\":{\"Target Collection\":{\"terms\":{\"field\":\"tenantIdForMunicipalCorporation.keyword\",\"size\":\"200\",\"order\":{\"Sum\":\"asc\"}},\"aggs\":{\"Sum\":{\"sum\":{\"field\":\"budgetProposedForMunicipalCorporation\"}}}}}}}}" }, { "module": "W&S", "requestQueryMap": "{\"tenantId\" : \"dataObject.tenantId.keyword\", \"wardId\" : \"domainObject.ward.name.keyword\"}", "dateRefField": "dataObject.paymentDetails.receiptDate", "indexName": "dss-collection_v2", "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must_not\":[{\"term\":{\"dataObject.tenantId.keyword\":\"pb.testing\"}},{\"terms\":{\"dataObject.paymentDetails.bill.status.keyword\":[\"Cancelled\"]}}],\"must\":[{\"terms\":{\"dataObject.paymentDetails.businessService.keyword\":[\"WS\",\"WS.ONE_TIME_FEE\",\"SW.ONE_TIME_FEE\",\"SW\"]}}]}},\"aggs\":{\"Total Collection\":{\"terms\":{\"field\":\"dataObject.tenantId.keyword\",\"size\":\"200\",\"order\":{\"Sum\":\"asc\"}},\"aggs\":{\"Sum\":{\"sum\":{\"field\":\"dataObject.paymentDetails.totalAmountPaid\"}}}}}}}}" } ], "translateTenantCode": false, "chartType": "perform", "valueType": "percentage", "drillChart": "none", "documentType": "_doc", "action": "percentage", "plotLabel": "DSS_TARGET_ACHIEVED", "order": "asc", "limit": 3, "isRoundOff": true, "aggregationPaths": [ "Total Collection", "Target Collection" ], "preActionTheory":{ "Target Collection":"repsonseToDifferenceOfDates" }, "insight": { }, "_comment": " Bottom Performing Ulbs for target achieved" }, "wscollectionByUsage": { "chartName": "DSS_W&S_COLLECTION_BY_USAGE", "queries": [ { "module": "W&S", "dateRefField": "dataObject.paymentDetails.receiptDate", "requestQueryMap": "{\"tenantId\" : \"dataObject.tenantId.keyword\", \"wardId\" : \"domainObject.ward.name.keyword\"}", "indexName": "dss-collection_v2", "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must_not\":[{\"term\":{\"dataObject.tenantId.keyword\":\"pb.testing\"}},{\"terms\":{\"dataObject.paymentDetails.bill.status.keyword\":[\"Cancelled\"]}}],\"must\":[{\"terms\":{\"dataObject.paymentDetails.businessService.keyword\":[\"WS\",\"WS.ONE_TIME_FEE\",\"SW.ONE_TIME_FEE\",\"SW\"]}}]}},\"aggs\":{\"Collection by Usage\":{\"terms\":{\"field\":\"domainObject.propertyUsageType.keyword\"},\"aggs\":{\"total collection\":{\"sum\":{\"field\":\"dataObject.paymentDetails.bill.billDetails.amountPaidtotalAmountPaid\"}}}}}}}}" } ], "translateTenantCode": false, "chartType": "pie", "valueType": "numberamount", "action": "", "documentType": "_doc", "drillChart": "none", "aggregationPaths": [ "Collection by Usage" ], "insight": { }, "_comment": " " }, "wscollectionByChannel": { "chartName": "DSS_W&S_COLLECTION_BY_CHANNEL", "queries": [ { "module": "W&S", "dateRefField": "dataObject.paymentDetails.receiptDate", "requestQueryMap": "{\"tenantId\" : \"dataObject.tenantId.keyword\", \"wardId\" : \"domainObject.ward.name.keyword\"}", "indexName": "dss-collection_v2", "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must_not\":[{\"term\":{\"dataObject.tenantId.keyword\":\"pb.testing\"}},{\"terms\":{\"dataObject.paymentStatuspaymentDetails.bill.status.keyword\":[\"Cancelled\"]}}],\"must\":[{\"terms\":{\"dataObject.paymentDetails.paymentStatusbusinessService.keyword\":[\"DEPOSITEDWS\",\"NEWWS.ONE_TIME_FEE\"]}},{\"terms\":{\"dataObject.paymentDetails.businessService.keyword\":[\"WS\",\"WS.ONE_TIME_FEE\",\"SW.ONE_TIME_FEE\",\"SW\"]}}]}},\"aggs\":{\"Collection Channels\":{\"terms\":{\"field\":\"dataObject.paymentMode.keyword\"},\"aggs\":{\"totalcollection_frommode\":{\"sum\":{\"field\":\"dataObject.paymentDetails.bill.billDetails.amountPaidtotalAmountPaid\"}}}}}}}}" } ], "translateTenantCode": false, "chartType": "pie", "valueType": "numberamount", "action": "", "documentType": "_doc", "drillChart": "none", "aggregationPaths": [ "Collection Channels" ], "insight": { }, "_comment": " " }, "wsFinancialIndicatorDDR": { "chartName": "DSS_WS_KEY_FY_INDICATORS", "queries": [ { "module": "COMMON", "requestQueryMap": "{\"wardId\" : \"domainObject.ward.name.keyword\",\"module\" : \"dataObject.paymentDetails.businessService.keyword\", \"tenantId\" : \"dataObject.tenantId.keyword\", \"district\" : \"dataObject.tenantData.city.districtCode\" }", "dateRefField": "dataObject.paymentDetails.receiptDate", "indexName": "dss-collection_v2", "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must_not\":[{\"term\":{\"dataObject.tenantId.keyword\":\"pb.testing\"}},{\"terms\":{\"dataObject.paymentDetails.bill.status.keyword\":[\"Cancelled\"]}}],\"must\":[{\"terms\":{\"dataObject.paymentDetails.businessService.keyword\":[\"WS\",\"WS.ONE_TIME_FEE\",\"SW.ONE_TIME_FEE\",\"SW\"]}}]}},\"aggs\":{\"Ws_Total_Collection\":{\"sum\":{\"field\":\"dataObject.paymentDetails.totalAmountPaid\"}},\"Total_Transactions\":{\"value_count\":{\"field\":\"dataObject.transactionNumber.keyword\"}}}}}}" }, { "module": "COMMON", "requestQueryMap": "{\"module\" : \"businessService.keyword\", \"tenantId\" : \"tenantIdForMunicipalCorporation.keyword\"}", "dateRefField": "", "indexName": "dss-target_v1", "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must\":[{\"terms\":{\"businessService.keyword\":[\"W&S\"]}}]}},\"aggs\":{\"Ws_Target_Collection\":{\"sum\":{\"field\":\"budgetProposedForMunicipalCorporation\"}}}}}}" }, { "module": "COMMON", "indexName": "water-services", "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must_not\":[{\"term\":{\"Data.applicationStatus.keyword\":\"REJECTED\"}},{\"term\":{\"Data.tenantId.keyword\":\"pb.testing\"}}],\"must\":[{\"terms\":{\"Data.applicationStatus.keyword\":[\"CONNECTION_ACTIVATED\"]}}]}},\"aggs\":{\"Total_Connections\":{\"value_count\":{\"field\":\"Data.id.keyword\"}}}}}}", "requestQueryMap": "{\"tenantId\" : \"Data.tenantId.keyword\", \"wardId\" : \"Data.ward.name.keyword\"}", "dateRefField": "Data.connectionExecutionDate" }, { "module": "COMMON", "indexName": "sewerage-services", "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must_not\":[{\"term\":{\"Data.applicationStatus.keyword\":\"REJECTED\"}},{\"term\":{\"Data.tenantId.keyword\":\"pb.testing\"}}],\"must\":[{\"terms\":{\"Data.applicationStatus.keyword\":[\"CONNECTION_ACTIVATED\"]}}]}},\"aggs\":{\"Total_Connections\":{\"value_count\":{\"field\":\"Data.id.keyword\"}}}}}}", "requestQueryMap": "{\"tenantId\" : \"Data.tenantId.keyword\", \"wardId\" : \"Data.ward.name.keyword\"}", "dateRefField": "Data.connectionExecutionDate" } ], "isMdmsEnabled": true, "filterKeys": [ {"key": "tenantId", "column": "DDRs"} ], "chartType": "xtable", "valueType": "number", "drillChart": "wsFinancialIndicatorUlb", "action": "", "plotLabel": "DDRs", "isPostResponseHandler": true, "postAggregationTheory" : "repsonseToDifferenceOfDates", "documentType": "_doc", "aggregationPaths": [ "Ws_Target_Collection", "Ws_Total_CollectionConnections", "Total_Transactions", "Ws_Total_ConnectionsCollection" ], "computedFields": [ { "postAggregationTheory" : "repsonseToDifferenceOfDates", "actionName": "PercentageComputedFieldAdditiveComputedField", "fields" : ["Ws_Total_Collection","Target_Collection"], "newField" : "Target_AchievedCollection", "_comments": "fields are field names picked from its aggregation query to use post aggregation newField value with given new field name " }, ], { "pathDataTypeMappingpostAggregationTheory" : [ "", "actionName": "PercentageComputedField", { "fields" : ["Ws_Total_Collection": "amount","Target_Collection"], }, "newField" : "Target_Achieved", { "Total_Transactionscomments": "number"fields are field names picked from its },aggregation query to use post aggregation newField {value with given new field name "Target_Collection": "amount" }, ], { "Total_Connections"excludedColumns": "number"["Ws_Target_Collection"], },"pathDataTypeMapping": [ { "Ws_Target_AchievedCollection": "percentageamount" }, { "Total_Connections": "number" }, { "Total_Transactions": "number" }, { "Ws_Total_Collection": "amount" }, { "Target_Collection": "amount" }, { "Target_Achieved": "percentage" } ], "insight": { }, "_comment": "" }, "wsFinancialIndicatorUlb": { "chartName": "DSS_W&S_DEMAND_COLLECTION_BOUNDARY", "queries": [ { "module": "COMMON", "requestQueryMap": "{\"wardId\" : \"domainObject.ward.name.keyword\",\"module\" : \"dataObject.paymentDetails.businessService.keyword\", \"tenantId\" : \"dataObject.tenantId.keyword\", \"district\" : \"dataObject.tenantData.city.districtCode\" }", "dateRefField": "dataObject.paymentDetails.receiptDate", "indexName": "dss-collection_v2", "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must_not\":[{\"term\":{\"dataObject.tenantId.keyword\":\"pb.testing\"}},{\"terms\":{\"dataObject.paymentDetails.bill.status.keyword\":[\"Cancelled\"]}}],\"must\":[{\"terms\":{\"dataObject.paymentDetails.businessService.keyword\":[\"WS\",\"WS.ONE_TIME_FEE\",\"SW.ONE_TIME_FEE\",\"SW\"]}}]}},\"aggs\":{\"ULBs \":{\"terms\":{\"field\":\"dataObject.tenantId.keyword\",\"size\":200},\"aggs\":{\"Ws_Total_Collection\":{\"sum\":{\"field\":\"dataObject.paymentDetails.totalAmountPaid\"}},\"Total_Transactions\":{\"value_count\":{\"field\":\"dataObject.transactionNumber.keyword\"}}}}}}}}" }, { "module": "COMMON", "requestQueryMap": "{\"module\" : \"businessService.keyword\", \"tenantId\" : \"tenantIdForMunicipalCorporation.keyword\"}", "dateRefField": "", "indexName": "dss-target_v1", "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must\":[{\"terms\":{\"businessService.keyword\":[\"W&S\"]}}]}},\"aggs\":{\"ULBs \":{\"terms\":{\"field\":\"tenantIdForMunicipalCorporation.keyword\",\"size\":1000},\"aggs\":{\"Ws_Target_Collection\":{\"sum\":{\"field\":\"budgetProposedForMunicipalCorporation\"}}}}}}}}" }, { "module": "COMMON", "indexName": "water-services", "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must_not\":[{\"term\":{\"Data.applicationStatus.keyword\":\"REJECTED\"}}],\"must\":[{\"terms\":{\"Data.applicationStatus.keyword\":[\"CONNECTION_ACTIVATED\"]}}]}},\"aggs\":{\"ULB\":{\"terms\":{\"field\":\"Data.tenantId.keyword\",\"size\":2000},\"aggs\":{\"Total_Connections\":{\"value_count\":{\"field\":\"Data.id.keyword\"}}}}}}}}", "requestQueryMap": "{\"tenantId\" : \"Data.tenantId.keyword\", \"wardId\" : \"Data.ward.name.keyword\"}", "dateRefField": "Data.connectionExecutionDate" }, { "module": "COMMON", "indexName": "sewerage-services", "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must_not\":[{\"term\":{\"Data.applicationStatus.keyword\":\"REJECTED\"}}],\"must\":[{\"terms\":{\"Data.applicationStatus.keyword\":[\"CONNECTION_ACTIVATED\"]}}]}},\"aggs\":{\"ULB\":{\"terms\":{\"field\":\"Data.tenantId.keyword\",\"size\":2000},\"aggs\":{\"Total_Connections\":{\"value_count\":{\"field\":\"Data.id.keyword\"}}}}}}}}", "requestQueryMap": "{\"tenantId\" : \"Data.tenantId.keyword\", \"wardId\" : \"Data.ward.name.keyword\"}", "dateRefField": "Data.connectionExecutionDate" } ], "filterKeys": [ {"key": "tenantId", "column": "BoundaryULB"} ], "chartType": "xtable", "valueType": "number", "drillChart": "wsFinancialIndicatorWard", "documentType": "_doc", "action": "", "plotLabel": "BoundaryULB", "postAggregationTheory" : "repsonseToDifferenceOfDates", "aggregationPaths": [ "Ws_Target_Collection", "Ws_Total_CollectionConnections", "Total_Transactions", "Ws_Total_ConnectionsCollection" ], "computedFields": [ { "postAggregationTheory" : "repsonseToDifferenceOfDates", "actionName": "PercentageComputedFieldAdditiveComputedField", "fields" : ["Ws_Total_Collection","Target_Collection"], "newField" : "Target_AchievedCollection", "_comments": "fields are field names picked from its aggregation query to use post aggregation newField value with given new field name " }, ], { "pathDataTypeMappingpostAggregationTheory" : ["", {"actionName": "PercentageComputedField", "fields" : ["Ws_Total_Collection": "amount","Target_Collection"], }, "newField" : {"Target_Achieved", "Total_Transactionscomments": "number"fields are field names picked from its aggregation query to use post aggregation newField value with given new field name " } ], "excludedColumns":["Ws_Target_Collection"], "pathDataTypeMapping": [ { "Ws_Target_Collection": "amount" }, { "Total_Connections": "number" }, { "TargetTotal_AchievedTransactions": "percentagenumber" } ],, "insight": { }, "Ws_Total_commentCollection": "amount" }, "wsFinancialIndicatorWard": { "chartName "Target_Collection": "amount", "queries": [ }, { "moduleTarget_Achieved": "COMMONpercentage", } " ], "insight": { }, "_comment": "" }, "wsFinancialIndicatorWard": { "chartName": "", "queries": [ { "module": "COMMON", "requestQueryMap": "{\"wardId\" : \"domainObject.ward.name.keyword\",\"module\" : \"dataObject.paymentDetails.businessService.keyword\", \"tenantId\" : \"dataObject.tenantId.keyword\", \"district\" : \"dataObject.tenantData.city.districtCode\" }", "dateRefField": "dataObject.paymentDetails.receiptDate", "indexName": "dss-collection_v2", "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must_not\":[{\"term\":{\"dataObject.tenantId.keyword\":\"pb.testing\"}},{\"terms\":{\"dataObject.paymentDetails.bill.status.keyword\":[\"Cancelled\"]}}],\"must\":[{\"terms\":{\"dataObject.paymentDetails.businessService.keyword\":[\"WS\",\"WS.ONE_TIME_FEE\",\"SW.ONE_TIME_FEE\",\"SW\"]}}]}},\"aggs\":{\"Ward \":{\"terms\":{\"field\":\"domainObject.ward.name.keyword\",\"size\":200},\"aggs\":{\"Ws_Total_Collection\":{\"sum\":{\"field\":\"dataObject.paymentDetails.totalAmountPaid\"}},\"Total_Transactions\":{\"value_count\":{\"field\":\"dataObject.transactionNumber.keyword\"}}}}}}}}" }, { "module": "COMMON", "indexName": "water-services", "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must_not\":[{\"term\":{\"Data.applicationStatus.keyword\":\"REJECTED\"}}],\"must\":[{\"terms\":{\"Data.applicationStatus.keyword\":[\"CONNECTION_ACTIVATED\"]}}]}},\"aggs\":{\"Ward\":{\"terms\":{\"field\":\"Data.ward.name.keyword\",\"size\":2000},\"aggs\":{\"Total_Connections\":{\"value_count\":{\"field\":\"Data.id.keyword\"}}}}}}}}", "requestQueryMap": "{\"tenantId\" : \"Data.tenantId.keyword\", \"wardId\" : \"Data.ward.name.keyword\"}", "dateRefField": "Data.connectionExecutionDate" }, { "module": "COMMON", "indexName": "sewerage-services", "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must_not\":[{\"term\":{\"Data.applicationStatus.keyword\":\"REJECTED\"}}],\"must\":[{\"terms\":{\"Data.applicationStatus.keyword\":[\"CONNECTION_ACTIVATED\"]}}]}},\"aggs\":{\"Ward\":{\"terms\":{\"field\":\"Data.ward.name.keyword\",\"size\":2000},\"aggs\":{\"Total_Connections\":{\"value_count\":{\"field\":\"Data.id.keyword\"}}}}}}}}", "requestQueryMap": "{\"tenantId\" : \"Data.tenantId.keyword\", \"wardId\" : \"Data.ward.name.keyword\"}", "dateRefField": "Data.connectionExecutionDate" } ], "postAggregationTheory" : "repsonseToDifferenceOfDates", "chartType": "xtable", "valueType": "number", "drillChart": "none", "documentType": "_doc", "action": "", "plotLabel": "Ward", "aggregationPaths": [ "Ws_Total_CollectionConnections", "Total_Transactions", "Ws_Total_ConnectionsCollection" ], "pathDataTypeMapping": [ { "Ws_Total_CollectionConnections": "amountnumber" }, { "Total_Transactions": "number" }, { "Ws_Total_ConnectionsCollection": "numberamount" } ], "insight": { }, "_comment": "" }, "wsTaxHeadDDR": { "chartName": "DSS_W&S_TAX_HEAD_BOUNDARY", "queries": [ { "module": "W&S", "requestQueryMap": "{\"wardId\" : \"domainObject.ward.name.keyword\",\"module\" : \"dataObject.paymentDetails.businessService.keyword\", \"tenantId\" : \"dataObject.tenantId.keyword\", \"district\" : \"dataObject.tenantData.city.districtCode\" }", "dateRefField": "dataObject.paymentDetails.receiptDate", "indexName": "dss-collection_v2", "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must_not\":[{\"term\":{\"dataObject.tenantId.keyword\":\"pb.testing\"}},{\"terms\":{\"dataObject.paymentDetails.bill.status.keyword\":[\"Cancelled\"]}}],\"must\":[{\"terms\":{\"dataObject.paymentDetails.businessService.keyword\":[\"WS\",\"WS.ONE_TIME_FEE\",\"SW.ONE_TIME_FEE\",\"SW\"]}}]}},\"aggs\":{\"Ws_Total_Collection\":{\"sum\":{\"field\":\"dataObject.paymentDetails.bill.totalAmounttotalAmountPaid\"}},\"Penalty\":{\"nested\":{\"path\":\"dataObject.paymentDetails.bill.billDetails.billAccountDetails\"},\"aggs\":{\"aggrFilter\":{\"filter\":{\"terms\":{\"dataObject.paymentDetails.bill.billDetails.billAccountDetails.taxHeadCode.keyword\":[\"SW_TIME_PENALTY\",\"WS_TIME_PENALTY\"]}},\"aggs\":{\"amount\":{\"sum\":{\"field\":\"dataObject.paymentDetails.bill.billDetails.billAccountDetails.amount\"}}}}}},\"Interest\":{\"nested\":{\"path\":\"dataObject.paymentDetails.bill.billDetails.billAccountDetails\"},\"aggs\":{\"aggrFilter\":{\"filter\":{\"terms\":{\"dataObject.paymentDetails.bill.billDetails.billAccountDetails.taxHeadCode.keyword\":[\"SW_TIME_INTEREST\",\"WS_TIME_INTEREST\"]}},\"aggs\":{\"amount\":{\"sum\":{\"field\":\"dataObject.paymentDetails.bill.billDetails.billAccountDetails.amount\"}}}}}}}}}}" }, { "module": "W&S", "requestQueryMap": "{\"module\" : \"businessService.keyword\", \"tenantId\" : \"tenantIdForMunicipalCorporation.keyword\"}", "dateRefField": "", "indexName": "dss-target_v1", "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must\":[{\"terms\":{\"businessService.keyword\":[\"W&S\"]}}]}},\"aggs\":{\"Ws_Target_Collection\":{\"sum\":{\"field\":\"budgetProposedForMunicipalCorporation\"}}}}}}" } ], "translateTenantCode": false, "isMdmsEnabled": true, "filterKeys": [ {"key": "tenantId", "column": "DDRs"} ], "chartType": "tablextable", "valueType": "numberamount", "drillChart": "wsTaxHeadUlb", "action": "", "plotLabel": "DDRs", "postAggregationTheory" : "", "aggregationPaths": [ "Ws_Total_Collection", "Penalty", "Interest", "Ws_Target_Collection" ], "pathDataTypeMappingcomputedFields": [ { "Ws_Total_CollectionpostAggregationTheory" : "amountrepsonseToDifferenceOfDates", }, {"actionName": "AdditiveComputedField", "Penaltyfields" : ["amount"Ws_Target_Collection"], }, "newField" {: "Target_Collection", "Interest_comments": "amount"fields are field names picked from its },aggregation query to use post aggregation newField {value with given new field name "Target_Collection": "amount" } } ], "insight": { }excludedColumns":["Ws_Target_Collection"], "_commentpathDataTypeMapping": ""[ }, "wsTaxHeadUlb": { "chartNameWs_Total_Collection": "DSS_W&S_TAX_HEAD_BOUNDARY",amount" "queries": [ }, { "modulePenalty": "W&S",amount" }, { "requestQueryMap": "{\"wardId\" : \"domainObject.ward.name.keyword\",\"module\" : \"dataObject.paymentDetails.businessService.keyword\", \"tenantId\Interest" : \"dataObject.tenantId.keyword\", \"district\" : \"dataObject.tenantData.city.districtCode\" }","amount" }, "dateRefField": "dataObject.paymentDetails.receiptDate", { "indexNameWs_Target_Collection": "dss-collection_v2",amount" }, "aggrQuery { "Target_Collection": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must_not\":[{\"term\":{\"dataObject.tenantId.keyword\":\"pb.testing\"}},{\"terms\":{amount" } ], "insight": { }, "_comment": "" }, "wsTaxHeadUlb": { "chartName": "DSS_W&S_TAX_HEAD_BOUNDARY", "queries": [ { "module": "W&S", "requestQueryMap": "{\"wardId\" : \"domainObject.ward.name.keyword\",\"module\" : \"dataObject.paymentDetails.billbusinessService.status.keyword\":[\"Cancelled\"]}}],\"must\":[, \"tenantId\" : \"dataObject.tenantId.keyword\", \"district\" : \"dataObject.tenantData.city.districtCode\" }", "dateRefField": "dataObject.paymentDetails.receiptDate", "indexName": "dss-collection_v2", "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must_not\":[{\"term\":{\"dataObject.tenantId.keyword\":\"pb.testing\"}},{\"terms\":{\"dataObject.paymentDetails.bill.status.keyword\":[\"Cancelled\"]}}],\"must\":[{\"terms\":{\"dataObject.paymentDetails.businessService.keyword\":[\"WS\",\"WS.ONE_TIME_FEE\",\"SW.ONE_TIME_FEE\",\"SW\"]}}]}},\"aggs\":{\"ULBs \":{\"terms\":{\"field\":\"dataObject.tenantId.keyword\",\"size\":200},\"aggs\":{\"Ws_Total_Collection\":{\"sum\":{\"field\":\"dataObject.paymentDetails.bill.totalAmounttotalAmountPaid\"}},\"Penalty\":{\"nested\":{\"path\":\"dataObject.paymentDetails.bill.billDetails.billAccountDetails\"},\"aggs\":{\"aggrFilter\":{\"filter\":{\"terms\":{\"dataObject.paymentDetails.bill.billDetails.billAccountDetails.taxHeadCode.keyword\":[\"SW_TIME_PENALTY\",\"WS_TIME_PENALTY\"]}},\"aggs\":{\"amount\":{\"sum\":{\"field\":\"dataObject.paymentDetails.bill.billDetails.billAccountDetails.amount\"}}}}}},\"Interest\":{\"nested\":{\"path\":\"dataObject.paymentDetails.bill.billDetails.billAccountDetails\"},\"aggs\":{\"aggrFilter\":{\"filter\":{\"terms\":{\"dataObject.paymentDetails.bill.billDetails.billAccountDetails.taxHeadCode.keyword\":[\"SW_TIME_INTEREST\",\"WS_TIME_INTEREST\"]}},\"aggs\":{\"amount\":{\"sum\":{\"field\":\"dataObject.paymentDetails.bill.billDetails.billAccountDetails.amount\"}}}}}}}}}}}}" }, { "module": "W&S", "requestQueryMap": "{\"module\" : \"businessService.keyword\", \"tenantId\" : \"tenantIdForMunicipalCorporation.keyword\"}", "dateRefField": "", "indexName": "dss-target_v1", "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must\":[{\"terms\":{\"businessService.keyword\":[\"W&S\"]}}]}},\"aggs\":{\"ULBs \":{\"terms\":{\"field\":\"tenantIdForMunicipalCorporation.keyword\",\"size\":1000},\"aggs\":{\"Ws_Target_Collection\":{\"sum\":{\"field\":\"budgetProposedForMunicipalCorporation\"}}}}}}}}" } ], "translateTenantCode": false, "isMdmsEnabled": false, "filterKeys": [ {"key": "tenantId", "column": "ULB"} ], "chartType": "tablextable", "valueType": "numberamount", "drillChart": "wsTaxHeadWard", "action": "", "plotLabel": "ULB", "postAggregationTheory" : "", "aggregationPaths": [ "Ws_Total_Collection", "Penalty", "Interest", "Ws_Target_Collection" ], "pathDataTypeMappingcomputedFields": [ { "Ws_Total_CollectionpostAggregationTheory" : "amountrepsonseToDifferenceOfDates", }, "actionName": "AdditiveComputedField", {"fields" : ["Ws_Target_Collection"], "PenaltynewField" : "amount" }, "Target_Collection", "_comments": "fields are field names picked from its aggregation query to use post aggregation newField value with given new field name " } { ], "InterestexcludedColumns": "amount"["Ws_Target_Collection"], "pathDataTypeMapping": [ }, { "TargetWs_Total_Collection": "amount" }, ], { "insightPenalty": "amount" { }, { "_commentInterest": "amount" }, "wsTaxHeadWard": { "chartName "Ws_Target_Collection": "amount", "queries": [ }, { "moduleTarget_Collection": "W&S",amount" } ], "requestQueryMapinsight": "{\"wardId\" : \ }, "_comment": "" }, "wsTaxHeadWard": { "chartName": "", "queries": [ { "module": "W&S", "requestQueryMap": "{\"wardId\" : \"domainObject.ward.name.keyword\",\"module\" : \"dataObject.paymentDetails.businessService.keyword\", \"tenantId\" : \"dataObject.tenantId.keyword\", \"district\" : \"dataObject.tenantData.city.districtCode\" }", "dateRefField": "dataObject.paymentDetails.receiptDate", "indexName": "dss-collection_v2", "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must_not\":[{\"term\":{\"dataObject.tenantId.keyword\":\"pb.testing\"}},{\"terms\":{\"dataObject.paymentDetails.bill.status.keyword\":[\"Cancelled\"]}}],\"must\":[{\"terms\":{\"dataObject.paymentDetails.businessService.keyword\":[\"WS\",\"WS.ONE_TIME_FEE\",\"SW.ONE_TIME_FEE\",\"SW\"]}}]}},\"aggs\":{\"Ward \":{\"terms\":{\"field\":\"domainObject.ward.name.keyword\",\"size\":200},\"aggs\":{\"Ws_Total_Collection\":{\"sum\":{\"field\":\"dataObject.paymentDetails.bill.totalAmounttotalAmountPaid\"}},\"Penalty\":{\"nested\":{\"path\":\"dataObject.paymentDetails.bill.billDetails.billAccountDetails\"},\"aggs\":{\"aggrFilter\":{\"filter\":{\"terms\":{\"dataObject.paymentDetails.bill.billDetails.billAccountDetails.taxHeadCode.keyword\":[\"SW_TIME_PENALTY\",\"WS_TIME_PENALTY\"]}},\"aggs\":{\"amount\":{\"sum\":{\"field\":\"dataObject.paymentDetails.bill.billDetails.billAccountDetails.amount\"}}}}}},\"Interest\":{\"nested\":{\"path\":\"dataObject.paymentDetails.bill.billDetails.billAccountDetails\"},\"aggs\":{\"aggrFilter\":{\"filter\":{\"terms\":{\"dataObject.paymentDetails.bill.billDetails.billAccountDetails.taxHeadCode.keyword\":[\"SW_TIME_INTEREST\",\"WS_TIME_INTEREST\"]}},\"aggs\":{\"amount\":{\"sum\":{\"field\":\"dataObject.paymentDetails.bill.billDetails.billAccountDetails.amount\"}}}}}}}}}}}}" } ], "isMdmsEnabled": false, "translateTenantCode": false, "filterKeys": [ ], "chartType": "tablextable", "valueType": "numberamount", "drillChart": "none", "action": "", "plotLabel": "Ward", "postAggregationTheory" : "", "aggregationPaths": [ "Ws_Total_Collection", "Penalty", "Interest" ], "pathDataTypeMapping": [ { "Ws_Total_Collection": "amount" }, { "Penalty": "amount" }, { "Interest": "amount" } ], "insight": { }, "_comment": "" }, "wstotalConnectionwstotalApplications": { "chartName": "DSS_WS_CONNECTIONSTOTAL_APPLICATIONS", "queries": [ { "module": "WSW&S", "indexName": "water-services", "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must_not\":[{\"termterms\":{\"Data.applicationStatus.keyword\":[\"REJECTED\"}}],\"must\":[{\"terms\":{\"Data.applicationStatus.keyword\":[\"CONNECTION_ACTIVATED\"]}}]}},\"aggs\":{\"Total Water ConnectionApplications\":{\"value_count\":{\"field\":\"Data.id.keyword\"}}}}}}", "requestQueryMap": "{\"tenantId\" : \"Data.tenantId.keyword\", \"wardId\" : \"Data.ward.name.keyword\"}", "dateRefField": "Data.connectionExecutionDate@timestamp" }, { "module": "WSW&S", "indexName": "sewerage-services", "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must_not\":[{\"termterms\":{\"Data.applicationStatus.keyword\":[\"REJECTED\",\"CONNECTION_ACTIVATED\"]}}]}},\"mustaggs\":[{\"termsTotal Sewerage Applications\":{\"Data.applicationStatus.keyword\":[\"CONNECTION_ACTIVATED\"]}}]}},\"aggs\":{\"Total Sewerage Connection\":{\"value_value_count\":{\"field\":\"Data.id.keyword\"}}}}}}", "requestQueryMap": "{\"tenantId\" : \"Data.tenantId.keyword\", \"wardId\" : \"Data.ward.name.keyword\"}", "dateRefField": "Data.connectionExecutionDate@timestamp" } ], "translateTenantCode": false, "chartType": "metric", "valueType": "number", "action": "additive", "drillChart": "none", "aggregationPaths": [ "Total Water ConnectionApplications","Total Sewerage ConnectionApplications" ], "insight": { } "chartResponseMap" : "wstotalApplications", "_commentaction" : "differenceOfNumbers", " }, "wsSLAComplianceupwardIndicator" : {"positive", "chartNamedownwardIndicator" : "DSS_WS_SLA_COMPLIANCEnegative", "queriestextMessage" : [ "$indicator$value% than last $insightInterval", {"colorCode" : "#228B22", "moduleinsightInterval" : "WSyear", "indexNameisRoundOff": "water-services",true }, "aggrQuery_comment": "{\"aggs\" }, "wstotalConnection": {\"AGGR\ "chartName":{\"filter\":{\"bool\":{\"must_not\":[{\"term\":{\"Data.service.tenantId.keyword\":\"pb.testing\"}}]}}, "DSS_WS_ACTIVE_CONNECTIONS", "queries": [ { "module": "W&S", "indexName": "water-services", "aggrQuery": "{\"aggs\":{\"Closed With In SlaAGGR\":{\"filter\":{\"bool\":{\"must_not\":[{\"termsterm\":{\"Data.applicationStatus.keyword\":[\"CONNECTION_ACTIVATEDREJECTED\"]}}],{\"scriptmust\":[{\"scriptterms\":{\"source\":\"doc['Data.history.auditDetails.lastModifiedTime'].value - doc['Data.history.auditDetails.createdTime'].value < params.threshold\",\"lang\":\"painless\",\"params\":{\"threshold\":172800000}}}}applicationStatus.keyword\":[\"CONNECTION_ACTIVATED\"]}}]}},\"aggs\":{\"countTotal Water Connection\":{\"termsvalue_count\":{\"field\":\"Data.tenantIdid.keyword\"},\"aggs\":{\"tenant_count\":{\"value_count\":{\"field\":\"Data.tenantId.keyword\"}}}}}},\"Total Applications\":{\"terms\":{\"field\":}}}}}", "requestQueryMap": "{\"tenantId\" : \"Data.tenantId.keyword\"},\"aggs\":{\"tenant_count\":{\"value_count\":{\"field\":\"Data.tenantId.keyword\"}}}}}}}}", "requestQueryMap": "{\"wardId\" : \"Data.ward.name.keyword\",\"tenantId\" : \"Data.tenantId.keyword\" \r\n}", "dateRefField": "Data.history.auditDetails.createdTimeconnectionExecutionDate" }, { "module": "WSW&S", "indexName": "sewerage-services", "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must_not\":[{\"term\":{\"Data.service.tenantIdapplicationStatus.keyword\":\"pb.testingREJECTED\"}}]}},\"aggs\":{\"Closed With In Sla\":{\"filter\":{\"bool\":{\"must\":[{\"terms\":{\"Data.applicationStatus.keyword\":[\"CONNECTION_ACTIVATED\"]}}]}},{\"scriptaggs\":{\"scriptTotal Sewerage Connection\":{\"source\":\"doc['Data.history.auditDetails.lastModifiedTime'].value - doc['Data.history.auditDetails.createdTime'].value < params.threshold\",\"lang\":\"painless\",\"params\":{\"threshold\":172800000}}}}]}},\"aggs\":{\"count\":{\"terms\":{\"field\":\"Data.tenantId.keyword\"},\"aggs\":{\"tenantvalue_count\":{\"value_count\":{\"field\":\"Data.tenantIdid.keyword\"}}}}}},\"Total Applications\":{\"terms\":", "requestQueryMap": "{\"fieldtenantId\" : \"Data.tenantId.keyword\"}, \"aggswardId\" :{ \"tenant_count\":{\"value_count\":{\"field\":\"Data.tenantIdData.ward.name.keyword\"}}}}}}}}", "requestQueryMapdateRefField": "{\"wardId\" : \"Data.ward.name.keyword\",\"tenantId\" : \"Data.tenantId.keyword\" \r\n}", "dateRefField": "Data.history.auditDetails.createdTime"Data.connectionExecutionDate" } ], "translateTenantCode": false, "chartType": "metric", "valueType": "percentagenumber", "action": "percentageadditive", "drillChart": "none", "aggregationPaths": [ "ClosedTotal WithWater In SlaConnection", "Total ApplicationsSewerage Connection" ], "insight": { "chartResponseMap" : "wsSLACompliancewstotalConnection", "action" : "differenceOfNumbers", "upwardIndicator" : "positive", "downwardIndicator" : "negative", "textMessage" : "$indicator$value% than last $insightInterval", "colorCode" : "#228B22", "insightInterval" : "year", "isRoundOff": true }, "_comment": "WS SLA Compliance" }, "wsActiveMeteredWaterConnectionwsActiveWaterConnection": { "chartName": "DSS_WS_ACTIVE_METERED_WATER_CONNECTIONS", "queries": [ { "module": "WS", "indexName": "water-services", "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must_not\":[{\"term\":{\"Data.applicationStatus.keyword\":\"REJECTED\"}}],\"must\":[{\"terms\":{\"Data.applicationStatus.keyword\":[\"CONNECTION_ACTIVATED\"]}},{\"terms\":{\"Data.connectionType.keyword\":[\"Metered\"]}}]}},\"aggs\":{\"Active Metered Water Connections\":{\"value_count\":{\"field\":\"Data.id.keyword\"}}}}}}", "requestQueryMap": "{\"tenantId\" : \"Data.tenantId.keyword\", \"wardId\" : \"Data.ward.name.keyword\"}", "dateRefField": "Data.connectionExecutionDate" } ], "translateTenantCode": false, "chartType": "metric", "valueType": "number", "action": "", "drillChart": "none", "aggregationPaths": [ "Active Metered Water Connections" ], "insight": { "chartResponseMap" : "wsActiveMeteredWaterConnectionwsActiveWaterConnection", "action" : "differenceOfNumbers", "upwardIndicator" : "positive", "downwardIndicator" : "negative", "textMessage" : "$indicator$value% than last $insightInterval", "colorCode" : "#228B22", "insightInterval" : "year", "isRoundOff": true }, "_comment": "active metered water connections" }, "wsActiveNonMeteredWaterConnectionwsSLACompliance": { "chartName": "DSS_WS_ACTIVE_NON_METERED_WATER_CONNECTIONSSLA_COMPLIANCE", "queries": [ { "module": "WS", "indexName": "water-services", "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must_not\":[{\"term\":{\"Data.applicationStatustenantId.keyword\":\"REJECTEDpb.testing\"}}]}},\"mustaggs\":[{\"termsClosed With In Sla\":{\"Data.applicationStatus.keywordfilter\":[\"CONNECTION{\"bool\":{\"must\":[{\"terms\":{\"Data.applicationStatus.keyword\":[\"CONNECTION_ACTIVATED\",\"REJECTED\"]}},{\"script\":{\"termsscript\":{\"source\":\"doc['Data.connectionType.keyword.auditDetails.lastModifiedTime'].date.millis - doc['Data.auditDetails.createdTime'].date.millis < params.threshold\",\"lang\":\"painless\",\"params\":[{\"Non Meteredthreshold\"]:172800000}}}}]}},\"aggs\":{\"Active Non-Metered Water Connectionscount\":{\"value_countterms\":{\"field\":\"Data.idtenantId.keyword\"}}}}}}", "requestQueryMap": "{\"tenantId\" : ,\"aggs\":{\"tenant_count\":{\"value_count\":{\"field\":\"Data.tenantId.keyword\"}}}}}},\"Total Applications\"wardId:{\"terms\":{\"field\" : \"Data.wardtenantId.name.keyword\"}", "dateRefField": "Data.connectionExecutionDate" } ],,\"aggs\":{\"tenant_count\":{\"value_count\":{\"field\":\"Data.tenantId.keyword\"}}}}}}}}", "translateTenantCoderequestQueryMap": false, "chartType": "metric", "valueType": "number", "action": "","{\"wardId\" : \"Data.ward.name.keyword\",\"tenantId\" : \"Data.tenantId.keyword\" \r\n}", "drillChartdateRefField": "none",Data.history.auditDetails.createdTime" "aggregationPaths": [ }, "Active Non-Metered Water Connections" { ], "insightmodule": { "chartResponseMapWS", : "wsActiveNonMeteredWaterConnection", "actionindexName" : "differenceOfNumberssewerage-services", "upwardIndicatoraggrQuery" : "positive", "downwardIndicator" : "negative", "textMessage" : "$indicator$value% than last $insightInterval", "colorCode" : "#228B22", "insightInterval" : "year" }, "_comment": "active non-metered water connections" }, "wsActiveSewerageConnection": { "chartName": "DSS_WS_ACTIVE_SEWERAGE_CONNECTIONS", "queries": [ { "module": "WS", "indexName": "sewerage-services", "aggrQuery": "{{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must_not\":[{\"term\":{\"Data.tenantId.keyword\":\"pb.testing\"}}]}},\"aggs\":{\"Closed With In Sla\":{\"filter\":{\"bool\":{\"must\":[{\"terms\":{\"Data.applicationStatus.keyword\":[\"CONNECTION_ACTIVATED\",\"REJECTED\"]}},{\"script\":{\"script\":{\"source\":\"doc['Data.auditDetails.lastModifiedTime'].date.millis - doc['Data.auditDetails.createdTime'].date.millis < params.threshold\",\"lang\":\"painless\",\"params\":{\"threshold\":172800000}}}}]}},\"aggs\":{\"count\":{\"terms\":{\"field\":\"Data.tenantId.keyword\"},\"aggs\":{\"tenant_count\":{\"value_count\":{\"field\":\"Data.tenantId.keyword\"}}}}}},\"Total Applications\":{\"terms\":{\"field\":\"Data.tenantId.keyword\"},\"aggs\":{\"tenant_count\":{\"value_count\":{\"field\":\"Data.tenantId.keyword\"}}}}}}}}", "requestQueryMap": "{\"wardId\" : \"Data.ward.name.keyword\",\"tenantId\" : \"Data.tenantId.keyword\" \r\n}", "dateRefField": "Data.history.auditDetails.createdTime" } ], "translateTenantCode": false, "chartType": "metric", "valueType": "percentage", "action": "percentage", "drillChart": "none", "aggregationPaths": [ "Closed With In Sla", "Total Applications" ], "isRoundOff": true, "insight": { "chartResponseMap" : "wsSLACompliance", "action" : "differenceOfNumbers", "upwardIndicator" : "positive", "downwardIndicator" : "negative", "textMessage" : "$indicator$value% than last $insightInterval", "colorCode" : "#228B22", "insightInterval" : "year", "isRoundOff": true }, "_comment": "WS SLA Compliance" }, "wsActiveMeteredWaterConnection": { "chartName": "DSS_WS_ACTIVE_METERED_WATER_CONNECTIONS", "queries": [ { "module": "WS", "indexName": "water-services", "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must_not\":[{\"term\":{\"Data.applicationStatus.keyword\":\"REJECTED\"}}],\"must\":[{\"terms\":{\"Data.applicationStatus.keyword\":[\"CONNECTION_ACTIVATED\"]}},{\"terms\":{\"Data.connectionType.keyword\":[\"Metered\"]}}]}},\"aggs\":{\"Active Metered Water Connections\":{\"value_count\":{\"field\":\"Data.id.keyword\"}}}}}}", "requestQueryMap": "{\"tenantId\" : \"Data.tenantId.keyword\", \"wardId\" : \"Data.ward.name.keyword\"}", "dateRefField": "Data.connectionExecutionDate" } ], "translateTenantCode": false, "chartType": "metric", "valueType": "number", "action": "", "drillChart": "none", "aggregationPaths": [ "Active Metered Water Connections" ], "insight": { "chartResponseMap" : "wsActiveMeteredWaterConnection", "action" : "differenceOfNumbers", "upwardIndicator" : "positive", "downwardIndicator" : "negative", "textMessage" : "$indicator$value% than last $insightInterval", "colorCode" : "#228B22", "insightInterval" : "year", "isRoundOff": true }, "_comment": "active metered water connections" }, "wsActiveNonMeteredWaterConnection": { "chartName": "DSS_WS_ACTIVE_NON_METERED_WATER_CONNECTIONS", "queries": [ { "module": "WS", "indexName": "water-services", "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must_not\":[{\"term\":{\"Data.applicationStatus.keyword\":\"REJECTED\"}}],\"must\":[{\"terms\":{\"Data.applicationStatus.keyword\":[\"CONNECTION_ACTIVATED\"]}},{\"terms\":{\"Data.connectionType.keyword\":[\"Non Metered\"]}}]}},\"aggs\":{\"Active Non-Metered Water Connections\":{\"value_count\":{\"field\":\"Data.id.keyword\"}}}}}}", "requestQueryMap": "{\"tenantId\" : \"Data.tenantId.keyword\", \"wardId\" : \"Data.ward.name.keyword\"}", "dateRefField": "Data.connectionExecutionDate" } ], "translateTenantCode": false, "chartType": "metric", "valueType": "number", "action": "", "drillChart": "none", "aggregationPaths": [ "Active Non-Metered Water Connections" ], "insight": { "chartResponseMap" : "wsActiveNonMeteredWaterConnection", "action" : "differenceOfNumbers", "upwardIndicator" : "positive", "downwardIndicator" : "negative", "textMessage" : "$indicator$value% than last $insightInterval", "colorCode" : "#228B22", "insightInterval" : "year", "isRoundOff": true }, "_comment": "active non-metered water connections" }, "wsActiveSewerageConnection": { "chartName": "DSS_WS_ACTIVE_SEWERAGE_CONNECTIONS", "queries": [ { "module": "WS", "indexName": "sewerage-services", "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must_not\":[{\"term\":{\"Data.applicationStatus.keyword\":\"REJECTED\"}}],\"must\":[{\"terms\":{\"Data.applicationStatus.keyword\":[\"CONNECTION_ACTIVATED\"]}}]}},\"aggs\":{\"Active Sewerage Connections\":{\"value_count\":{\"field\":\"Data.id.keyword\"}}}}}}", "requestQueryMap": "{\"tenantId\" : \"Data.tenantId.keyword\", \"wardId\" : \"Data.ward.name.keyword\"}", "dateRefField": "Data.connectionExecutionDate" } ], "translateTenantCode": false, "chartType": "metric", "valueType": "number", "action": "", "drillChart": "none", "aggregationPaths": [ "Active Sewerage Connections" ], "insight": { "chartResponseMap" : "wsActiveSewerageConnection", "action" : "differenceOfNumbers", "upwardIndicator" : "positive", "downwardIndicator" : "negative", "textMessage" : "$indicator$value% than last $insightInterval", "colorCode" : "#228B22", "insightInterval" : "year", "isRoundOff": true }, "_comment": "active sewerage connections " }, "wscumulativeCollectionsv2": { "chartName": "DSS_W&S_CUMULATIVE_COLLECTION", "queries": [ { "module": "W&S", "dateRefField": "dataObject.paymentDetails.receiptDate", "requestQueryMap": "{\"tenantId\" : \"Data.tenantId.keyword\", \"wardId\" : \"domainObject.ward.name.keyword\"}", "indexName": "dss-collection_v2", "aggrQuery": "{\"aggs\":{\"Water Collections\":{\"date_histogram\":{\"field\":\"dataObject.paymentDetails.receiptDate\",\"interval\":\"intervalvalue\"},\"aggs\":{\"Water\":{\"filter\":{\"bool\":{\"must_not\":[{\"term\":{\"dataObject.tenantId.keyword\":\"pb.testing\"}},{\"terms\":{\"dataObject.paymentStatus.keyword\":[\"Cancelled\"]}}],\"must\":[{\"terms\":{\"dataObject.paymentStatus.keyword\":[\"DEPOSITED\",\"NEW\"]}},{\"terms\":{\"dataObject.paymentDetails.businessService.keyword\":[\"WS\",\"WS.ONE_TIME_FEE\"]}}]}},\"aggs\":{\"Count\":{\"sum\":{\"field\":\"dataObject.paymentDetails.bill.billDetails.amountPaid\"}}}}}},\"Sewerage Collections\":{\"date_histogram\":{\"field\":\"dataObject.paymentDetails.receiptDate\",\"interval\":\"intervalvalue\"},\"aggs\":{\"AGGRSewerage\":{\"filter\":{\"bool\":{\"must_not\":[{\"term\":{\"DatadataObject.applicationStatustenantId.keyword\":\"REJECTEDpb.testing\"}}],\"must\":[{\"terms\":{\"DatadataObject.applicationStatuspaymentStatus.keyword\":[\"CONNECTION_ACTIVATEDCancelled\"]}}]}},\"aggsmust\":[{\"Active Sewerage Connectionsterms\":{\"value_countdataObject.paymentStatus.keyword\":[\"DEPOSITED\",\"NEW\"]}},{\"fieldterms\":{\"DatadataObject.paymentDetails.idbusinessService.keyword\":[\"SW.ONE_TIME_FEE\"]}}}]}}}", "requestQueryMap": ",\"aggs\":{\"tenantIdCount\" : {\"Data.tenantId.keywordsum\", :{\"wardIdfield\" : \"DatadataObject.paymentDetails.wardbill.namebillDetails.keywordamountPaid\"}}}}}}}}", "dateRefField": "Data.connectionExecutionDate" } ], "translateTenantCode": false, "chartType": "metricline", "valueType": "numberamount", "action": "", "drillChart": "none", "aggregationPathsdocumentType": [ "Active Sewerage Connections" ]"_doc", "insightaggregationPaths": {[ "chartResponseMap"Water : Collections"wsActiveSewerageConnection", "action" : "differenceOfNumbers",Sewerage Collections" "upwardIndicator" : "positive"], "downwardIndicatorisCumulative" : "negative"true, "textMessageinterval" : "$indicator$value% than last $insightIntervalmonth", "colorCodeinsight" : "#228B22", { "insightInterval" : "year" }, "_comment": "active sewerage connections " }, "wscumulativeConnections": { "chartName": "DSS_W&S_CUMULATIVE_CONNECTION", "queries": [ { "module": "W&S", "dateRefField": "Data.connectionExecutionDate", "requestQueryMap": "{\"tenantId\" : \"Data.tenantId.keyword\", \"wardId\" : \"Data.ward.name.keyword\"}", "indexName": "water-services", "aggrQuery": "{\"aggs\":{\"Water Connections\":{\"date_histogram\":{\"field\":\"Data.connectionExecutionDate\",\"interval\":\"intervalvalue\"},\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must_not\":[{\"term\":{\"Data.applicationStatus.keyword\":\"REJECTED\"}}],\"must\":[{\"terms\":{\"Data.applicationStatus.keyword\":[\"CONNECTION_ACTIVATED\"]}}]}},\"aggs\":{\"Total Connections\":{\"value_count\":{\"field\":\"Data.id.keyword\"}}}}}}}}" }, { "module": "W&S", "dateRefField": "Data.connectionExecutionDate", "requestQueryMap": "{\"tenantId\" : \"Data.tenantId.keyword\", \"wardId\" : \"Data.ward.name.keyword\"}", "indexName": "sewerage-services", "aggrQuery": "{\"aggs\":{\"Sewerage Connections\":{\"date_histogram\":{\"field\":\"Data.connectionExecutionDate\",\"interval\":\"intervalvalue\"},\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must_not\":[{\"term\":{\"Data.applicationStatus.keyword\":\"REJECTED\"}}],\"must\":[{\"terms\":{\"Data.applicationStatus.keyword\":[\"CONNECTION_ACTIVATED\"]}}]}},\"aggs\":{\"Total Connections\":{\"value_count\":{\"field\":\"Data.id.keyword\"}}}}}}}}" } ], "translateTenantCode": false, "chartType": "line", "valueType": "number", "action": "", "drillChart": "none", "documentType": "_doc", "aggregationPaths": [ "Water Connections", "Sewerage Connections" ], "isCumulative": true, "interval": "month", "insight": { }, "_comment": " " }, "wsWaterConsumersByUsageType": { "chartName": "DSS_W&S_WATER_CONNECTION_BY_USAGE", "queries": [ { "module": "W&S", "indexName": "water-services", "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must_not\":[{\"term\":{\"Data.applicationStatus.keyword\":\"REJECTED\"}}],\"must\":[{\"terms\":{\"Data.applicationStatus.keyword\":[\"CONNECTION_ACTIVATED\"]}}]}},\"aggs\":{\"Water Consumers by Usage Type\":{\"terms\":{\"field\":\"Data.propertyUsageType.keyword\"},\"aggs\":{\"Total Connection\":{\"value_count\":{\"field\":\"Data.id.keyword\"}}}}}}}}", "requestQueryMap": "{\"tenantId\" : \"Data.tenantId.keyword\", \"wardId\" : \"Data.ward.name.keyword\"}", "dateRefField": "Data.connectionExecutionDate" } ], "translateTenantCode": false, "chartType": "pie", "valueType": "number", "action": "", "documentType": "_doc", "drillChart": "none", "aggregationPaths": [ "Water Consumers by Usage Type" ], "insight": { }, "_comment": " " }, "wsSewerageConsumersByUsageType": { "chartName": "DSS_W&S_SEWERAGE_CONNECTION_BY_USAGE", "queries": [ { "module": "W&S", "indexName": "sewerage-services", "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must_not\":[{\"term\":{\"Data.applicationStatus.keyword\":\"REJECTED\"}}],\"must\":[{\"terms\":{\"Data.applicationStatus.keyword\":[\"CONNECTION_ACTIVATED\"]}}]}},\"aggs\":{\"Sewerage Consumers by Usage Type\":{\"terms\":{\"field\":\"Data.propertyUsageType.keyword\"},\"aggs\":{\"Total Connection\":{\"value_count\":{\"field\":\"Data.id.keyword\"}}}}}}}}", "requestQueryMap": "{\"tenantId\" : \"Data.tenantId.keyword\", \"wardId\" : \"Data.ward.name.keyword\"}", "dateRefField": "Data.connectionExecutionDate" } ], "translateTenantCode": false, "chartType": "pie", "valueType": "number", "action": "", "documentType": "_doc", "drillChart": "none", "aggregationPaths": [ "Sewerage Consumers by Usage Type" ], "insight": { }, "_comment": " " }, "wsConsumersByChannel": { "chartName": "DSS_W&S_CONNECTION_BY_CHANNEL", "queries": [ { "module": "W&S", "indexName": "water-services", "requestQueryMap": "{\"tenantId\" : \"Data.tenantId.keyword\", \"wardId\" : \"Data.ward.name.keyword\"}", "dateRefField": "Data.connectionExecutionDate", "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must_not\":[{\"term\":{\"Data.applicationStatus.keyword\":\"REJECTED\"}}],\"must\":[{\"terms\":{\"Data.applicationStatus.keyword\":[\"CONNECTION_ACTIVATED\"]}}]}},\"aggs\":{\"W & S Consumers by Channel\":{\"terms\":{\"field\":\"Data.channel.keyword\"},\"aggs\":{\"Total Connection\":{\"value_count\":{\"field\":\"Data.id.keyword\"}}}}}}}}" }, { "module": "W&S", "indexName": "sewerage-services", "requestQueryMap": "{\"tenantId\" : \"Data.tenantId.keyword\", \"wardId\" : \"Data.ward.name.keyword\"}", "dateRefField": "Data.connectionExecutionDate", "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must_not\":[{\"term\":{\"Data.applicationStatus.keyword\":\"REJECTED\"}}],\"must\":[{\"terms\":{\"Data.applicationStatus.keyword\":[\"CONNECTION_ACTIVATED\"]}}]}},\"aggs\":{\"W & S Consumers by Channel\":{\"terms\":{\"field\":\"Data.channel.keyword\"},\"aggs\":{\"Total Connection\":{\"value_count\":{\"field\":\"Data.id.keyword\"}}}}}}}}" } ], "translateTenantCode": false, "chartType": "pie", "valueType": "number", "action": "", "documentType": "_doc", "drillChart": "none", "aggregationPaths": [ "W & S Consumers by Channel" ], "insight": { }, "_comment": " " }, "wsConnectionAgeingDDR": { "chartName": "DSS_W&S_CONNECTION_AGEING", "queries": [ { "module": "W&S", "requestQueryMap": "{\"tenantId\" : \"Data.tenantId.keyword\", \"wardId\" : \"Data.ward.name.keyword\" }", "dateRefField": "Data.@timestamp", "indexName": "water-services", "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must_not\":[{\"term\":{\"Data.tenantId.keyword\":\"pb.testing\"}},{\"termterms\":{\"Data.applicationStatus.keyword\":[\"REJECTED\",\"CONNECTION_ACTIVATED\"]}}]}},\"aggs\":{\"Pending_from_0_to_3_days\":{\"date_range\":{\"field\":\"Data.@timestamp\",\"ranges\":[{\"from\":\"now-3d\/d\",\"to\":\"now\"}],\"format\":\"dd-MM-yyyy\"}},\"Pending_from_3_to_7_days\":{\"date_range\":{\"field\":\"Data.@timestamp\",\"ranges\":[{\"from\":\"now-7d\/d\",\"to\":\"now-3d\"}],\"format\":\"dd-MM-yyyy\"}},\"Pending_from_7_to_15_days\":{\"date_range\":{\"field\":\"Data.@timestamp\",\"ranges\":[{\"from\":\"now-15d\",\"to\":\"now-7d\"}],\"format\":\"dd-MM-yyyy\"}},\"Pending_from_more_than_15_days\":{\"date_range\":{\"field\":\"Data.@timestamp\",\"ranges\":[{\"from\":\"now-2y\",\"to\":\"now-15d\"}],\"format\":\"dd-MM-yyyy\"}}}}}}" }, { "module": "W&S", "requestQueryMap": "{\"tenantId\" : \"Data.tenantId.keyword\", \"wardId\" : \"Data.ward.name.keyword\" }", "dateRefField": "Data.@timestamp", "indexName": "sewerage-services", "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must_not\":[{\"term\":{\"Data.tenantId.keyword\":\"pb.testing\"}},{\"termterms\":{\"Data.applicationStatus.keyword\":[\"REJECTED\",\"CONNECTION_ACTIVATED\"]}}]}},\"aggs\":{\"Pending_from_0_to_3_days\":{\"date_range\":{\"field\":\"Data.@timestamp\",\"ranges\":[{\"from\":\"now-3d\/d\",\"to\":\"now\"}],\"format\":\"dd-MM-yyyy\"}},\"Pending_from_3_to_7_days\":{\"date_range\":{\"field\":\"Data.@timestamp\",\"ranges\":[{\"from\":\"now-7d\/d\",\"to\":\"now-3d\"}],\"format\":\"dd-MM-yyyy\"}},\"Pending_from_7_to_15_days\":{\"date_range\":{\"field\":\"Data.@timestamp\",\"ranges\":[{\"from\":\"now-15d\",\"to\":\"now-7d\"}],\"format\":\"dd-MM-yyyy\"}},\"Pending_from_more_than_15_days\":{\"date_range\":{\"field\":\"Data.@timestamp\",\"ranges\":[{\"from\":\"now-2y\",\"to\":\"now-15d\"}],\"format\":\"dd-MM-yyyy\"}}}}}}" } ], "isMdmsEnabled": true, "filterKeys": [ {"key": "tenantId", "column": "DDRs"} ], "chartType": "xtable", "valueType": "number", "drillChart": "wsConnectionAgeingUlb", "action": "", "plotLabel": "DDRs", "isPostResponseHandler": true, "aggregationPaths": [ "Pending_from_0_to_3_days", "Pending_from_3_to_7_days", "Pending_from_7_to_15_days", "Pending_from_more_than_15_days" ], "computedFields": [ { "postAggregationTheory" : "", "actionName": "AdditiveComputedField", "fields" : [ "Pending_from_0_to_3_days","Pending_from_3_to_7_days","Pending_from_7_to_15_days","Pending_from_more_than_15_days"], "newField" : "Total_Pending_Applications", "_comments": "fields are field names picked from its aggregation query to use post aggregation newField value with given new field name " } ], "insight": { }, "_comment": "" }, "wsConnectionAgeingUlb": { "chartName": "DSS_W&S_CONNECTION_AGEING", "queries": [ { "module": "W&S", "requestQueryMap": "{\"tenantId\" : \"Data.tenantId.keyword\", \"wardId\" : \"Data.ward.name.keyword\" }", "dateRefField": "Data.@timestamp", "indexName": "water-services", "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must_not\":[{\"term\":{\"Data.tenantId.keyword\":\"pb.testing\"}},{\"termterms\":{\"Data.applicationStatus.keyword\":[\"REJECTED\",\"CONNECTION_ACTIVATED\"]}}]}},\"aggs\":{\"ULB\":{\"terms\":{\"field\":\"Data.tenantId.keyword\",\"size\":170},\"aggs\":{\"Pending_from_0_to_3_days\":{\"date_range\":{\"field\":\"Data.@timestamp\",\"ranges\":[{\"from\":\"now-3d\/d\",\"to\":\"now\"}]}},\"Pending_from_3_to_7_days\":{\"date_range\":{\"field\":\"Data.@timestamp\",\"ranges\":[{\"from\":\"now-1w\",\"to\":\"now-3d\/d\"}]}},\"Pending_from_7_to_15_days\":{\"date_range\":{\"field\":\"Data.@timestamp\",\"ranges\":[{\"from\":\"now-15d\",\"to\":\"now-1w\"}]}},\"Pending_from_more_than_15_days\":{\"date_range\":{\"field\":\"Data.@timestamp\",\"ranges\":[{\"from\":\"now-2y\",\"to\":\"now-15d\"}]}}}}}}}}" }, { "module": "W&S", "requestQueryMap": "{\"tenantId\" : \"Data.tenantId.keyword\", \"wardId\" : \"Data.ward.name.keyword\" }", "dateRefField": "Data.@timestamp", "indexName": "sewerage-services", "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must_not\":[{\"term\":{\"Data.tenantId.keyword\":\"pb.testing\"}},{\"termterms\":{\"Data.applicationStatus.keyword\":[\"REJECTED\",\"CONNECTION_ACTIVATED\"]}}]}},\"aggs\":{\"ULB\":{\"terms\":{\"field\":\"Data.tenantId.keyword\",\"size\":170},\"aggs\":{\"Pending_from_0_to_3_days\":{\"date_range\":{\"field\":\"Data.@timestamp\",\"ranges\":[{\"from\":\"now-3d\/d\",\"to\":\"now\"}]}},\"Pending_from_3_to_7_days\":{\"date_range\":{\"field\":\"Data.@timestamp\",\"ranges\":[{\"from\":\"now-1w\",\"to\":\"now-3d\/d\"}]}},\"Pending_from_7_to_15_days\":{\"date_range\":{\"field\":\"Data.@timestamp\",\"ranges\":[{\"from\":\"now-15d\",\"to\":\"now-1w\"}]}},\"Pending_from_more_than_15_days\":{\"date_range\":{\"field\":\"Data.@timestamp\",\"ranges\":[{\"from\":\"now-2y\",\"to\":\"now-15d\"}]}}}}}}}}" } ], "isMdmsEnabled": false, "filterKeys": [ {"key": "tenantId", "column": "ULB"} ], "chartType": "xtable", "valueType": "number", "drillChart": "wsConnectionAgeingWard", "action": "", "plotLabel": "ULB", "isPostResponseHandler": true, "postAggregationTheory" : "", "aggregationPaths": [ "Pending_from_0_to_3_days", "Pending_from_3_to_7_days", "Pending_from_7_to_15_days", "Pending_from_more_than_15_days" ], "computedFields": [ { "postAggregationTheory" : "", "actionName": "AdditiveComputedField", "fields" : [ "Pending_from_0_to_3_days","Pending_from_3_to_7_days","Pending_from_7_to_15_days","Pending_from_more_than_15_days"], "newField" : "Total_Pending_Applications", "_comments": "fields are field names picked from its aggregation query to use post aggregation newField value with given new field name " } ], "insight": { }, "_comment": "" }, "wsConnectionAgeingWard": { "chartName": "", "queries": [ { "module": "W&S", "requestQueryMap": "{\"tenantId\" : \"Data.tenantId.keyword\", \"wardId\" : \"Data.ward.name.keyword\" }", "dateRefField": "Data.@timestamp", "indexName": "water-services", "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must_not\":[{\"term\":{\"Data.tenantId.keyword\":\"pb.testing\"}},{\"termterms\":{\"Data.applicationStatus.keyword\":[\"REJECTED\",\"CONNECTION_ACTIVATED\"]}}]}},\"aggs\":{\"Ward\":{\"terms\":{\"field\":\"Data.ward.name.keyword\",\"size\":170},\"aggs\":{\"Pending_from_0_to_3_days\":{\"date_range\":{\"field\":\"Data.@timestamp\",\"ranges\":[{\"from\":\"now-3d\/d\",\"to\":\"now\"}]}},\"Pending_from_3_to_7_days\":{\"date_range\":{\"field\":\"Data.@timestamp\",\"ranges\":[{\"from\":\"now-1w\",\"to\":\"now-3d\/d\"}]}},\"Pending_from_7_to_15_days\":{\"date_range\":{\"field\":\"Data.@timestamp\",\"ranges\":[{\"from\":\"now-15d\",\"to\":\"now-1w\"}]}},\"Pending_from_more_than_15_days\":{\"date_range\":{\"field\":\"Data.@timestamp\",\"ranges\":[{\"from\":\"now-2y\",\"to\":\"now-15d\"}]}}}}}}}}" }, { "module": "W&S", "requestQueryMap": "{\"tenantId\" : \"Data.tenantId.keyword\", \"wardId\" : \"Data.ward.name.keyword\" }", "dateRefField": "Data.@timestamp", "indexName": "sewerage-services", "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must_not\":[{\"term\":{\"Data.tenantId.keyword\":\"pb.testing\"}},{\"termterms\":{\"Data.applicationStatus.keyword\":[\"REJECTED\",\"CONNECTION_ACTIVATED\"]}}]}},\"aggs\":{\"Ward\":{\"terms\":{\"field\":\"Data.ward.name.keyword\",\"size\":170},\"aggs\":{\"Pending_from_0_to_3_days\":{\"date_range\":{\"field\":\"Data.@timestamp\",\"ranges\":[{\"from\":\"now-3d\/d\",\"to\":\"now\"}]}},\"Pending_from_3_to_7_days\":{\"date_range\":{\"field\":\"Data.@timestamp\",\"ranges\":[{\"from\":\"now-1w\",\"to\":\"now-3d\/d\"}]}},\"Pending_from_7_to_15_days\":{\"date_range\":{\"field\":\"Data.@timestamp\",\"ranges\":[{\"from\":\"now-15d\",\"to\":\"now-1w\"}]}},\"Pending_from_more_than_15_days\":{\"date_range\":{\"field\":\"Data.@timestamp\",\"ranges\":[{\"from\":\"now-2y\",\"to\":\"now-15d\"}]}}}}}}}}" } ], "isMdmsEnabled": false, "filterKeys": [ ], "chartType": "xtable", "valueType": "number", "drillChart": "none", "action": "", "plotLabel": "Ward", "isPostResponseHandler": true, "postAggregationTheory" : "", "aggregationPaths": [ "Pending_from_0_to_3_days", "Pending_from_3_to_7_days", "Pending_from_7_to_15_days", "Pending_from_more_than_15_days" ], "computedFields": [ { "postAggregationTheory" : "", "actionName": "AdditiveComputedField", "fields" : [ "Pending_from_0_to_3_days","Pending_from_3_to_7_days","Pending_from_7_to_15_days","Pending_from_more_than_15_days"], "newField" : "Total_Pending_Applications", "_comments": "fields are field names picked from its aggregation query to use post aggregation newField value with given new field name " } ], "insight": { }, "_comment": "" } |
...
Code Block |
---|
{ "name": "DSS_W&S_DASHBOARD", "id": "ws", "isActive": "", "style": "linear", "visualizations": [ { "row": 1, "name": "DSS_REVENUE", "vizArray": [ { "id": 211, "name": "DSS_STATE_WS_OVERVIEW", "dimensions": { "height": 350, "width": 5 }, "vizType": "metric-collection", "noUnit": true, "isCollapsible": false, "label": "DSS_OVERVIEW", "charts": [ { "id": "wstodaysCollection", "name": "DSS_W&S_TODAYS_COLLECTION", "code": "", "chartType": "metric", "filter": {"title": "TODAY"}, "headers": [] }, { "id": "wstotalCollection", "name": "DSS_W&S_TOTAL_COLLECTION", "code": "", "chartType": "metric", "filter": "", "headers": [] }, { "id": "wstargetCollection", "name": "DSS_W&S_TARGET_COLLECTION", "code": "", "chartType": "metric", "filter": "", "headers": [] }, { "id": "wstargetAchieved", "name": "DSS_W&S_TARGET_ACHIEVED", "code": "", "chartType": "metric", "filter": "", "headers": [] } ] }, { "id": 212, "name": "DSS_W&S_TOTAL_CUMULATIVE_COLLECTION", "dimensions": { "height": 350, "width": 7 }, "vizType": "chart", "noUnit": true, "isCollapsible": false, "charts": [ { "id": "wscumulativeCollections", "name": "Monthly", "code": "", "chartType": "line", "filter": "", "headers": [] } ] } ] }, { "row": 2, "name": "DSS_REVENUE", "vizArray": [ { "id": 221, "name": "DSS_W&S_TOP_3_PERFORMING_ULBS", "dimensions": { "height": 250, "width": 4 }, "vizType": "performing-metric", "noUnit": false, "isCollapsible": false, "label": "", "charts": [ { "id": "wstopPerformingUlbs", "name": "DSS_W&S_TOP_3_PERFORMING_ULBS", "code": "", "chartType": "bar", "filter": "", "headers": [] } ] }, { "id": 222, "name": "DSS_W&S_BOTTOM_3_PERFORMING_ULBS", "dimensions": { "height": 250, "width": 4 }, "vizType": "performing-metric", "noUnit": false, "isCollapsible": false, "charts": [ { "id": "wsbottomPerformingUlbs", "name": "DSS_W&S_BOTTOM_3_PERFORMING_ULBS", "code": "", "chartType": "bar", "filter": "", "headers": [] } ] } ] }, { "row": 3, "name": "DSS_REVENUE", "vizArray": [ { "id": 223, "name": "DSS_W&S_COLLECTION_BY_USAGE", "dimensions": { "height": 250, "width": 4 }, "vizType": "chart", "noUnit": true, "isCollapsible": false, "charts": [ { "id": "wscollectionByUsage", "name": "DSS_W&S_COLLECTION_BY_USAGE", "code": "", "chartType": "donut", "filter": "", "headers": [] } ] }, { "id": 224, "name": "DSS_W&S_COLLECTION_BY_CHANNEL", "dimensions": { "height": 250, "width": 4 }, "vizType": "chart", "noUnit": true, "isCollapsible": false, "charts": [ { "id": "wscollectionByChannel", "name": "DSS_W&S_COLLECTION_BY_CHANNEL", "code": "", "chartType": "donut", "filter": "", "headers": [] } ] } ] }, { "row": 4, "name": "DSS_REVENUE", "vizArray": [ { "id": 231, "name": "DSS_WS_KEY_FY_INDICATORS", "dimensions": { "height": 350, "width": 12 }, "vizType": "chart", "noUnit": false, "isCollapsible": false, "charts": [ { "id": "wsFinancialIndicatorDDR", "name": "DSS_W&S_DEMAND_COLLECTION_BOUNDARY", "code": "", "chartType": "table", "filter": "", "headers": [], "tabName": "Boundary" } ] } ] }, { "row": 5, "name": "DSS_REVENUE", "vizArray": [ { "id": 231, "name": "DSS_W&S_TAX_HEAD_BOUNDARY", "dimensions": { "height": 350, "width": 12 }, "vizType": "chart", "label": "", "noUnit": false, "isCollapsible": true, "charts": [ { "id": "wsTaxHeadDDR", "name": "DSS_W&S_TAX_HEAD_BOUNDARY", "code": "", "chartType": "table", "filter": "", "headers": [], "tabName": "Boundary" } ] } ] }, { "row": 7, "name": "DSS_SERVICE", "vizArray": [ { "id": 231, "name": "DSS_STATE_WS_OVERVIEW", "dimensions": { "height": 350, "width": 12 }, "row": 7, "namevizType": "DSS_SERVICEmetric-collection", "vizArraylabel": "", [ {"noUnit": false, "idisCollapsible": 231true, "namecharts": "DSS_OVERVIEW", [ "dimensions": { "heightid": 350"wstotalApplications", "widthname": 12"DSS_WS_TOTAL_APPLICATIONS", }, "vizType"code": "metric-collection", "labelchartType": "metric", "noUnitfilter": false,"", "isCollapsibleheaders": true,[] "charts": [ }, { "id": "wstotalConnectionwsSLACompliance", "name": "DSS_WS_CONNECTIONSSLA_COMPLIANCE", "code": "", "chartType": "metric", "filter": "", "headers": [] }, { "id": "wsSLACompliancewstotalConnection", "name": "DSS_WS_SLAACTIVE_COMPLIANCECONNECTIONS", "code": "", "chartType": "metric", "filter": "", "headers": [] }, { "id": "wsActiveMeteredWaterConnection", "name": "DSS_WS_ACTIVE_METERED_WATER_CONNECTIONS", "code": "", "chartType": "metric", "filter": "", "headers": [] }, { "id": "wsActiveNonMeteredWaterConnection", "name": "DSS_WS_ACTIVE_NON_METERED_WATER_CONNECTIONS", "code": "", "chartType": "metric", "filter": "", "headers": [] }, { "id": "wsActiveSewerageConnection", "name": "DSS_WS_ACTIVE_SEWERAGE_CONNECTIONS", "code": "", "chartType": "metric", "filter": "", "headers": [] } ] }, { "id": 232, "name": "DSS_W&S_CUMULATIVE_CONNECTION", "dimensions": { "height": 350, "width": 7 }, "vizType": "chart", "isCollapsible": false, "charts": [ { "id": "wscumulativeConnections", "name": "Monthly", "code": "", "chartType": "line", "filter": "", "headers": [] } ] } ] }, { "row": 8, "name": "DSS_SERVICE", "vizArray": [ { "id": 231, "name": "DSS_W&S_WATER_CONNECTION_BY_USAGE", "dimensions": { "height": 350, "width": 12 }, "vizType": "chart", "label": "", "noUnit": false, "isCollapsible": true, "charts": [ { "id": "wsWaterConsumersByUsageType", "name": "", "code": "", "chartType": "donut", "filter": "", "headers": [] } ] }, { "id": 232, "name": "DSS_W&S_SEWERAGE_CONNECTION_BY_USAGE", "dimensions": { "height": 350, "width": 12 }, "vizType": "chart", "label": "", "noUnit": false, "isCollapsible": true, "charts": [ { "id": "wsSewerageConsumersByUsageType", "name": "", "code": "", "chartType": "donut", "filter": "", "headers": [] } ] }, { "id": 233, "name": "DSS_W&S_CONNECTION_BY_CHANNEL", "dimensions": { "height": 350, "width": 12 }, "vizType": "chart", "label": "", "noUnit": false, "isCollapsible": true, "charts": [ { "id": "wsConsumersByChannel", "name": "", "code": "", "chartType": "donut", "filter": "", "headers": [] } ] } ] }, { "row": 9, "name": "DSS_SERVICE", "vizArray": [ { "id": 231, "name": "DSS_W&S_CONNECTION_AGEING", "dimensions": { "height": 350, "width": 12 }, "vizType": "chart", "label": "", "noUnit": false, "isCollapsible": true, "charts": [ { "id": "wsConnectionAgeingDDR", "name": "DSS_W&S_CONNECTION_AGEING", "code": "", "chartType": "table", "filter": "", "headers": [], "tabName": "Boundary" } ] } ] } ] } |
Click here for the complete configuration
...
Today’s Collection : This represents the today’s collection amount for Water and Sewerage Application Fee + Consumption Charges.
Total Collection : This represents the total collection amount for Water and Sewerage Application Fee + Consumption Charges.
Target Collection : This represents the target collection amount for the Water and Sewerage connections.
Target Achievement : This represents the target achieved in percentage. This is calculated by formula- (Total Collection/Target Collection)*100%SLA Compliance : This represents the total SLA achieved in percentage.
...
Total Cumulative Collection:
...
line - this graph/chart is data representation on date histograms or date groupings.
...
Top ULB By Performance:
This graph represents the ULB’s based on the Target achieved in bar chart representation with the % of target achieved in descending order.
...
On click of any district name will enter into drill down charts, which will represents that specific District data.
...
On click of the ULB will navigate to wards under that specific ULB and each ward shows the specific data regarding that ward.
...
Overview graph contains multiple data information as below in the selected time period.
Connections Total Applications : This represents the total active water and sewerage connectionsnumber of applications for new, modify, and disconnections requests.
SLA Compliance : This represents the total SLA achieved in percentage.
Total Active Connections : This represents the total active water and sewerage connections.
Water-Metered Connections : This represents the total active metered water connections.
Water-Non Metered Connections : This represents the total active non-metered water connections.
Sewerage Connections : This represents the total active sewerage connections.
...
line - this graph/chart is data representation on date histograms or date groupings.
...
Water Connections by Usage Type:
This graph shows the active Water connections based on the usage/property type.
...
Sewerage Connections by Usage Type:
This graph shows the active Sewerage connections based on the usage/property type.
...
W&S Connections by Channel Type:
This graph shows the active water and sewerage connections by channel type(eg-online, counter, etc).
...
W&S Connection Ageing:
This tabular chart representation graph shows W&S applications that have been submitted and have been pending to be worked on. The information like Pending from 0 to 3 days, Pending from 3 to 7 days, Pending from 7 to 15 days, Pending for more than 15 days, and Total Pending Applications is shown in the chart. And this table shows the data in district level and also has the drill down chart for each district to ulb and from ulb to ward level data for the same.
...