...
Code Block |
---|
"_comment": "National Dashboard-WS configs start here-------------------------------", "nssWsTodaysCollection": { "chartName": "NSS_WS_TODAYS_COLLECTION", "queries": [ { "module": "WS", "indexName": "ws-national-dashboard", "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must\":[{\"range\":{\"date\":{\"gt\":\"now-1d\/d\",\"lte\":\"now\"}}}]}},\"aggs\":{\"Todays Collection\":{\"sum\":{\"field\":\"todaysCollectionForPaymentChannelType\"}}}}}}", "requestQueryMap": "{\"module\" : \"module.keyword\", \"state\" : \"state.keyword\", \"ulb\" : \"ulb.keyword\"}", "dateRefField": "date" } ], "chartType": "metric", "valueType": "amount", "drillChart": "none", "documentType": "nss", "action": "", "aggregationPaths": [ "Todays Collection" ], "insight": { }, "_comment": " NSS W&S today's collections" }, "nssWsTotalCollection": { "chartName": "NSS_WS_TOTAL_COLLECTION", "queries": [ { "module": "WS", "requestQueryMap": "{\"module\" : \"module.keyword\", \"ulb\" : \"ulb.keyword\",\"state\" : \"state.keyword\"}", "dateRefField": "date", "indexName": "ws-national-dashboard", "aggrQuery": "{\"aggs\":{\"Total Collection\":{\"sum\":{\"field\":\"todaysCollectionForPaymentChannelType\"}}}}" } ], "translateTenantCode": false, "chartType": "metric", "valueType": "amount", "action": "", "drillChart": "none", "aggregationPaths": [ "Total Collection" ], "insight": { "chartResponseMap" : "nssWsTotalCollection", "action" : "differenceOfNumbers", "upwardIndicator" : "positive", "downwardIndicator" : "negative", "textMessage" : "$indicator$value% than last $insightInterval", "colorCode" : "#228B22", "insightInterval" : "year" }, "_comment": "W&S total collections " }, "nssWsTargetCollection": { "chartName": "NSS_WS_TARGET_COLLECTION", "queries": [ { "module": "WS", "requestQueryMap": "{\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\"}", "dateRefField": "date", "indexName": "master-national-dashboard", "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"term\":{\"module.keyword\":\"WS\"}},\"aggs\":{\"Target Collection\":{\"terms\":{\"field\":\"state.keyword\",\"size\":\"200\",\"order\":{\"Sum\":\"desc\"}},\"aggs\":{\"Sum\":{\"sum\":{\"field\":\"budgetProposedForMunicipalCorporation\"}}}}}}}}" } ], "chartType": "metric", "valueType": "amount", "action": "", "drillChart": "none", "documentType": "nss", "aggregationPaths": [ "Target Collection" ], "isDayUnit": true, "postAggregationTheory" : "repsonseToDifferenceOfDates", "insight": { "chartResponseMap" : "nssWsTargetCollection", "action" : "differenceOfNumbers", "upwardIndicator" : "positive", "downwardIndicator" : "negative", "textMessage" : "$indicator$value% than last $insightInterval", "colorCode" : "#228B22", "insightInterval" : "year" }, "_comment": "NSS W&S Target Collection " }, "nssWsTargetAchieved": { "chartName": "NSS_WS_TARGET_ACHIEVED", "queries": [ { "module": "COMMON", "requestQueryMap": "{\"module\" : \"module.keyword\", \"ulb\" : \"ulb.keyword\",\"state\" : \"state.keyword\"}", "dateRefField": "date", "indexName": "ws-national-dashboard", "aggrQuery": "{\"aggs\":{\"Total Collection\":{\"sum\":{\"field\":\"todaysCollectionForPaymentChannelType\"}}}}" }, { "module": "WS", "requestQueryMap": "{\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\"}", "dateRefField": "date", "indexName": "master-national-dashboard", "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"term\":{\"module.keyword\":\"WS\"}},\"aggs\":{\"Target Collection\":{\"terms\":{\"field\":\"state.keyword\",\"size\":\"200\",\"order\":{\"Sum\":\"desc\"}},\"aggs\":{\"Sum\":{\"sum\":{\"field\":\"budgetProposedForMunicipalCorporation\"}}}}}}}}" } ], "chartType": "metric", "valueType": "percentage", "drillChart": "none", "documentType": "nss", "action": "percentage", "aggregationPaths": [ "Total Collection", "Target Collection" ], "insight": { "chartResponseMap" : "nssWsTargetAchieved", "action" : "differenceOfNumbers", "upwardIndicator" : "positive", "downwardIndicator" : "negative", "textMessage" : "$indicator$value% than last $insightInterval", "colorCode" : "#228B22", "insightInterval" : "year" }, "_comment": " " }, "nssWsCumulativeCollections": { "chartName": "NSS_WS_TOTAL_CUMULATIVE_COLLECTION", "queries": [ { "module": "WS", "dateRefField": "date", "requestQueryMap": "{\"ulb\" : \"ulb.keyword\",\"ward\" : \"ward.keyword\"}", "indexName": "ws-national-dashboard", "aggrQuery": "{\"aggs\":{\"Water Collections\":{\"date_histogram\":{\"field\":\"date\",\"interval\":\"intervalvalue\"},\"aggs\":{\"Water\":{\"filter\":{\"bool\":{\"must\":[{\"terms\":{\"connectionType.keyword\":[\"WATER.NONMETERED\",\"WATER.METERED\"]}}]}},\"aggs\":{\"Sum\":{\"sum\":{\"field\":\"todaysCollectionForConnectionType\"}}}}}},\"Sewerage Collections\":{\"date_histogram\":{\"field\":\"date\",\"interval\":\"intervalvalue\"},\"aggs\":{\"Sewerage\":{\"filter\":{\"bool\":{\"must\":[{\"terms\":{\"connectionType.keyword\":[\"SEWERAGE\"]}}]}},\"aggs\":{\"Count\":{\"sum\":{\"field\":\"todaysCollectionForConnectionType\"}}}}}}}}" } ], "translateTenantCode": false, "chartType": "line", "valueType": "number", "action": "", "drillChart": "none", "documentType": "_doc", "aggregationPaths": [ "Water Collections", "Sewerage Collections" ], "isCumulative": true, "interval": "month", "insight": { }, "_comment": " " }, "nssWsTopPerformingUlbs": { "chartName": "NSS_WS_TOP_3_PERFORMING_STATES", "queries": [ { "module": "COMMON", "requestQueryMap": "{\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\"}", "dateRefField": "date", "indexName": "master-national-dashboard", "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"term\":{\"module.keyword\":\"WS\"}},\"aggs\":{\"Target Collection\":{\"terms\":{\"field\":\"state.keyword\",\"size\":\"200\",\"order\":{\"Sum\":\"desc\"}},\"aggs\":{\"Sum\":{\"sum\":{\"field\":\"budgetProposedForMunicipalCorporation\"}}}}}}}}" }, { "module": "WS", "requestQueryMap": "{\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\"}", "dateRefField": "date", "indexName": "ws-national-dashboard", "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{}},\"aggs\":{\"Total Collection\":{\"terms\":{\"field\":\"state.keyword\",\"size\":\"200\",\"order\":{\"Sum\":\"desc\"}},\"aggs\":{\"Sum\":{\"sum\":{\"field\":\"todaysCollectionForPaymentChannelType\"}}}}}}}}" } ], "chartType": "perform", "valueType": "percentage", "drillChart": "none", "documentType": "_doc", "action": "percentage", "plotLabel": "NSS_WS_TOP_3_PERFORMING_STATES", "order": "desc", "limit": 3, "aggregationPaths": [ "Total Collection","Target Collection" ], "insight": { }, "_comment": " Top Performing Ulbs for target achieved" }, "nssWsBottomPerformingUlbs": { "chartName": "NSS_WS_BOTTOM_3_PERFORMING_STATES", "queries": [ { "module": "COMMON", "requestQueryMap": "{\"state\" : \"state.keyword\",\"module\" : \"module.keyword\", \"ulb\" : \"ulb.keyword\"}", "dateRefField": "date", "indexName": "master-national-dashboard", "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"term\":{\"module.keyword\":\"WS\"}},\"aggs\":{\"Target Collection\":{\"terms\":{\"field\":\"state.keyword\",\"size\":\"200\",\"order\":{\"Sum\":\"asc\"}},\"aggs\":{\"Sum\":{\"sum\":{\"field\":\"budgetProposedForMunicipalCorporation\"}}}}}}}}" }, { "module": "WS", "requestQueryMap": "{\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\"}", "dateRefField": "date", "indexName": "ws-national-dashboard", "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{}},\"aggs\":{\"Total Collection\":{\"terms\":{\"field\":\"state.keyword\",\"size\":\"200\",\"order\":{\"Sum\":\"asc\"}},\"aggs\":{\"Sum\":{\"sum\":{\"field\":\"todaysCollectionForPaymentChannelType\"}}}}}}}}" } ], "chartType": "perform", "valueType": "percentage", "drillChart": "none", "documentType": "_doc", "action": "percentage", "plotLabel": "NSS_WS_BOTTOM_3_PERFORMING_STATES", "order": "asc", "limit": 3, "aggregationPaths": [ "Total Collection", "Target Collection" ], "insight": { }, "_comment": " Bottom Performing States for target achieved" }, "nssWsCollectionByUsage": { "chartName": "NSS_WS_COLLECTION_BY_USAGE", "queries": [ { "module": "WS", "dateRefField": "date", "requestQueryMap": "{\"tenantId\" : \"tenantId.keyword\",\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\",\"ward\" : \"ward.keyword\"}", "indexName": "ws-national-dashboard", "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{}},\"aggs\":{\"Collection by Usage Type\":{\"terms\":{\"field\":\"usageType.keyword\",\"size\":200},\"aggs\":{\"Amount Paid\":{\"sum\":{\"field\":\"todaysCollectionForUsageType\"}}}}}}}}" } ], "translateTenantCode": true, "chartType": "pie", "valueType": "number", "action": "", "documentType": "_doc", "drillChart": "none", "aggregationPaths": [ "Collection by Usage Type" ], "insight": { }, "_comment": " " }, "nssWsCollectionByChannel": { "chartName": "NSS_WS_COLLECTION_BY_CHANNEL", "queries": [ { "module": "WS", "dateRefField": "date", "requestQueryMap": "{\"tenantId\" : \"tenantId.keyword\",\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\",\"ward\" : \"ward.keyword\"}", "indexName": "ws-national-dashboard", "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{}},\"aggs\":{\"Collection by Channel Type\":{\"terms\":{\"field\":\"paymentChannelType.keyword\",\"size\":200},\"aggs\":{\"Amount Paid\":{\"sum\":{\"field\":\"todaysCollectionForPaymentChannelType\"}}}}}}}}" } ], "translateTenantCode": true, "chartType": "pie", "valueType": "number", "action": "", "documentType": "_doc", "drillChart": "none", "aggregationPaths": [ "Collection by Channel Type" ], "insight": { }, "_comment": " " }, "nssWsFinancialIndicatorState": { "chartName": "NSS_WS_KEY_FY_INDICATORS", "queries": [ { "module": "COMMON", "requestQueryMap": "{\"state\" : \"state.keyword\",\"module\" : \"module.keyword\"}", "dateRefField": "date", "indexName": "master-national-dashboard", "aggrQuery": "{\"aggs\":{\"state \":{\"terms\":{\"field\":\"state.keyword\",\"size\":200},\"aggs\":{\"Target_Collection\":{\"filter\":{\"term\":{\"module.keyword\":\"WS\"}},\"aggs\":{\"sum\":{\"sum\":{\"field\":\"budgetProposedForMunicipalCorporation\"}}}}}}}}" }, { "module": "WS", "dateRefField": "date", "requestQueryMap": "{\"state\" : \"state.keyword\",\"ward\" : \"ward.keyword\"}", "indexName": "ws-national-dashboard", "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{}},\"aggs\":{\"State\":{\"terms\":{\"field\":\"state.keyword\",\"size\":\"200\",\"order\":{\"Total_Connections\":\"desc\"}},\"aggs\":{\"Total_Connections\":{\"sum\":{\"field\":\"connectionsCreatedForConnectionType\"}},\"Ws_Total_Collection\":{\"sum\":{\"field\":\"todaysCollectionForPaymentChannelType\"}},\"Total_Transactions\":{\"avg\":{\"field\":\"transactions\"}}}}}}}}" } ], "filterKeys": [ { "key": "state","column": "State" } ], "isPostResponseHandler": true, "postAggregationTheory": "repsonseToDifferenceOfDates", "chartType": "xtable", "valueType": "number", "drillChart": "nssWsFinancialIndicatorTenant", "documentType": "_doc", "action": "", "plotLabel": "State", "aggregationPaths": [ "Target_Collection", "Ws_Total_Collection", "Total_Transactions", "Total_Connections" ], "computedFields": [ { "postAggregationTheory" : "", "actionName": "PercentageComputedField", "fields" : ["Ws_Total_Collection","Target_Collection"], "newField" : "Target_Achieved", "_comments": "fields are field names picked from its aggregation query to use post aggregation newField value with given new field name " } ], "pathDataTypeMapping": [ { "Ws_Total_Collection": "amount" }, { "Total_Transactions": "number" }, { "Total_Connections": "number" }, { "Target_Collection": "amount" }, { "Target_Achieved": "percentage" } ], "insight": { }, "_comment": " " }, "nssWsFinancialIndicatorTenant": { "chartName": "NSS_WS_DEMAND_COLLECTION_BOUNDARY", "queries": [ { "module": "COMMON", "requestQueryMap": "{\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\",\"module\" : \"module.keyword\"}", "dateRefField": "date", "indexName": "master-national-dashboard", "aggrQuery": "{\"aggs\":{\"state \":{\"terms\":{\"field\":\"ulb.keyword\",\"size\":200},\"aggs\":{\"Target_Collection\":{\"filter\":{\"term\":{\"module.keyword\":\"WS\"}},\"aggs\":{\"sum\":{\"sum\":{\"field\":\"budgetProposedForMunicipalCorporation\"}}}}}}}}" }, { "module": "WS", "dateRefField": "date", "requestQueryMap": "{\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\",\"ward\" : \"ward.keyword\"}", "indexName": "ws-national-dashboard", "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{}},\"aggs\":{\"ULB\":{\"terms\":{\"field\":\"ulb.keyword\",\"size\":\"200\",\"order\":{\"Total_Connections\":\"desc\"}},\"aggs\":{\"Total_Connections\":{\"sum\":{\"field\":\"connectionsCreatedForConnectionType\"}},\"Ws_Total_Collection\":{\"sum\":{\"field\":\"todaysCollectionForPaymentChannelType\"}},\"Total_Transactions\":{\"avg\":{\"field\":\"transactions\"}}}}}}}}" } ], "filterKeys": [ { "key": "ulb","column": "ULB" } ], "postAggregationTheory": "repsonseToDifferenceOfDates", "chartType": "xtable", "valueType": "number", "drillChart": "nssWsFinancialIndicatorWard", "documentType": "_doc", "action": "", "plotLabel": "ULB", "aggregationPaths": [ "Target_Collection", "Ws_Total_Collection", "Total_Transactions", "Total_Connections" ], "computedFields": [ { "postAggregationTheory" : "", "actionName": "PercentageComputedField", "fields" : ["Ws_Total_Collection","Target_Collection"], "newField" : "Target_Achieved", "_comments": "fields are field names picked from its aggregation query to use post aggregation newField value with given new field name " } ], "pathDataTypeMapping": [ { "Ws_Total_Collection": "amount" }, { "Total_Transactions": "number" }, { "Total_Connections": "number" }, { "Target_Collection": "amount" }, { "Target_Achieved": "percentage" } ], "insight": {}, "_comment": "" }, "nssWsFinancialIndicatorWard": { "chartName": "", "queries": [ { "module": "COMMON", "requestQueryMap": "{\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\",\"ward\" : \"ward.keyword\"}", "dateRefField": "date", "indexName": "master-national-dashboard", "aggrQuery": "{\"aggs\":{\"state \":{\"terms\":{\"field\":\"ward.keyword\",\"size\":200},\"aggs\":{\"Target_Collection\":{\"filter\":{\"term\":{\"module.keyword\":\"WS\"}},\"aggs\":{\"sum\":{\"sum\":{\"field\":\"budgetProposedForMunicipalCorporation\"}}}}}}}}" }, { "module": "WS", "dateRefField": "date", "requestQueryMap": "{\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\",\"ward\" : \"ward.keyword\"}", "indexName": "ws-national-dashboard", "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{}},\"aggs\":{\"Ward\":{\"terms\":{\"field\":\"ward.keyword\",\"size\":\"200\",\"order\":{\"Total_Connections\":\"desc\"}},\"aggs\":{\"Total_Connections\":{\"sum\":{\"field\":\"connectionsCreatedForConnectionType\"}},\"Ws_Total_Collection\":{\"sum\":{\"field\":\"todaysCollectionForPaymentChannelType\"}},\"Total_Transactions\":{\"avg\":{\"field\":\"transactions\"}}}}}}}}" } ], "isMdmsEnabled": false, "filterKeys": [ ], "postAggregationTheory": "repsonseToDifferenceOfDates", "chartType": "xtable", "valueType": "number", "drillChart": "", "documentType": "_doc", "action": "", "plotLabel": "Ward", "aggregationPaths": [ "Target_Collection", "Ws_Total_Collection", "Total_Transactions", "Total_Connections" ], "computedFields": [ { "postAggregationTheory" : "", "actionName": "PercentageComputedField", "fields" : ["Ws_Total_Collection","Target_Collection"], "newField" : "Target_Achieved", "_comments": "fields are field names picked from its aggregation query to use post aggregation newField value with given new field name " } ], "pathDataTypeMapping": [ { "Ws_Total_Collection": "amount" }, { "Total_Transactions": "number" }, { "Total_Connections": "number" }, { "Target_Collection": "amount" }, { "Target_Achieved": "percentage" } ], "insight": { }, "_comment": "" }, "nssWsTaxHeadState": { "chartName": "NSS_WS_TAX_HEAD_BOUNDARY", "queries": [ { "module": "WS", "dateRefField": "date", "requestQueryMap": "{\"state\" : \"state.keyword\",\"ward\" : \"ward.keyword\"}", "indexName": "ws-national-dashboard", "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{}},\"aggs\":{\"State \":{\"terms\":{\"field\":\"state.keyword\",\"size\":200},\"aggs\":{\"Interest\":{\"filter\":{\"terms\":{\"taxHeads.keyword\":[\"INTEREST\"]}},\"aggs\":{\"amount\":{\"sum\":{\"field\":\"todaysCollectionForTaxHeads\"}}}},\"Late_Charges\":{\"filter\":{\"terms\":{\"taxHeads.keyword\":[\"LATE.CHARGES\"]}},\"aggs\":{\"amount\":{\"sum\":{\"field\":\"todaysCollectionForTaxHeads\"}}}},\"Arrear_Charges\":{\"filter\":{\"terms\":{\"taxHeads.keyword\":[\"ARREAR.CHARGES\"]}},\"aggs\":{\"amount\":{\"sum\":{\"field\":\"todaysCollectionForTaxHeads\"}}}},\"Advance\":{\"filter\":{\"terms\":{\"taxHeads.keyword\":[\"ADVANCE\"]}},\"aggs\":{\"amount\":{\"sum\":{\"field\":\"todaysCollectionForTaxHeads\"}}}},\"Current_Charges\":{\"filter\":{\"terms\":{\"taxHeads.keyword\":[\"CURRENT.CHARGES\"]}},\"aggs\":{\"amount\":{\"sum\":{\"field\":\"todaysCollectionForTaxHeads\"}}}},\"Ws_Total_Collection\":{\"sum\":{\"field\":\"todaysCollectionForTaxHeads\"}}}}}}}}" } ], "isMdmsEnabled": false, "filterKeys": [ {"key": "state", "column": "State"} ], "chartType": "table", "valueType": "number", "drillChart": "nssWsTaxHeadTenant", "action": "", "plotLabel": "State", "postAggregationTheory" : "", "aggregationPaths": [ "Ws_Total_Collection", "Late_Charges", "Interest", "Advance", "Current_Charges", "Arrear_Charges" ], "pathDataTypeMapping": [ { "Ws_Total_Collection": "amount" }, { "Late_Charges": "amount" }, { "Interest": "amount" }, { "Advance": "amount" }, { "Current_Charges": "amount" }, { "Arrear_Charges": "amount" } ], "insight": { }, "_comment": "" }, "nssWsTaxHeadTenant": { "chartName": "NSS_WS_TAX_HEAD_BOUNDARY", "queries": [ { "module": "WS", "dateRefField": "date", "requestQueryMap": "{\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\",\"ward\" : \"ward.keyword\"}", "indexName": "ws-national-dashboard", "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{}},\"aggs\":{\"ULB \":{\"terms\":{\"field\":\"ulb.keyword\",\"size\":200},\"aggs\":{\"Interest\":{\"filter\":{\"terms\":{\"taxHeads.keyword\":[\"INTEREST\"]}},\"aggs\":{\"amount\":{\"sum\":{\"field\":\"todaysCollectionForTaxHeads\"}}}},\"Late_Charges\":{\"filter\":{\"terms\":{\"taxHeads.keyword\":[\"LATE.CHARGES\"]}},\"aggs\":{\"amount\":{\"sum\":{\"field\":\"todaysCollectionForTaxHeads\"}}}},\"Arrear_Charges\":{\"filter\":{\"terms\":{\"taxHeads.keyword\":[\"ARREAR.CHARGES\"]}},\"aggs\":{\"amount\":{\"sum\":{\"field\":\"todaysCollectionForTaxHeads\"}}}},\"Advance\":{\"filter\":{\"terms\":{\"taxHeads.keyword\":[\"ADVANCE\"]}},\"aggs\":{\"amount\":{\"sum\":{\"field\":\"todaysCollectionForTaxHeads\"}}}},\"Current_Charges\":{\"filter\":{\"terms\":{\"taxHeads.keyword\":[\"CURRENT.CHARGES\"]}},\"aggs\":{\"amount\":{\"sum\":{\"field\":\"todaysCollectionForTaxHeads\"}}}},\"Ws_Total_Collection\":{\"sum\":{\"field\":\"todaysCollectionForTaxHeads\"}}}}}}}}" } ], "translateTenantCode": false, "isMdmsEnabled": false, "filterKeys": [ {"key": "ulb", "column": "ULB"} ], "chartType": "table", "valueType": "number", "drillChart": "nssWsTaxHeadWard", "action": "", "plotLabel": "ULB", "postAggregationTheory" : "", "aggregationPaths": [ "Ws_Total_Collection", "Late_Charges", "Interest", "Advance", "Current_Charges", "Arrear_Charges" ], "pathDataTypeMapping": [ { "Ws_Total_Collection": "amount" }, { "Late_Charges": "amount" }, { "Interest": "amount" }, { "Advance": "amount" }, { "Current_Charges": "amount" }, { "Arrear_Charges": "amount" } ], "insight": { }, "_comment": "" }, "nssWsTaxHeadWard": { "chartName": "", "queries": [ { "module": "WS", "dateRefField": "date", "requestQueryMap": "{\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\",\"ward\" : \"ward.keyword\"}", "indexName": "ws-national-dashboard", "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{}},\"aggs\":{\"Ward \":{\"terms\":{\"field\":\"ward.keyword\",\"size\":200},\"aggs\":{\"Interest\":{\"filter\":{\"terms\":{\"taxHeads.keyword\":[\"INTEREST\"]}},\"aggs\":{\"amount\":{\"sum\":{\"field\":\"todaysCollectionForTaxHeads\"}}}},\"Late_Charges\":{\"filter\":{\"terms\":{\"taxHeads.keyword\":[\"LATE.CHARGES\"]}},\"aggs\":{\"amount\":{\"sum\":{\"field\":\"todaysCollectionForTaxHeads\"}}}},\"Arrear_Charges\":{\"filter\":{\"terms\":{\"taxHeads.keyword\":[\"ARREAR.CHARGES\"]}},\"aggs\":{\"amount\":{\"sum\":{\"field\":\"todaysCollectionForTaxHeads\"}}}},\"Advance\":{\"filter\":{\"terms\":{\"taxHeads.keyword\":[\"ADVANCE\"]}},\"aggs\":{\"amount\":{\"sum\":{\"field\":\"todaysCollectionForTaxHeads\"}}}},\"Current_Charges\":{\"filter\":{\"terms\":{\"taxHeads.keyword\":[\"CURRENT.CHARGES\"]}},\"aggs\":{\"amount\":{\"sum\":{\"field\":\"todaysCollectionForTaxHeads\"}}}},\"Ws_Total_Collection\":{\"sum\":{\"field\":\"todaysCollectionForTaxHeads\"}}}}}}}}" } ], "isMdmsEnabled": false, "translateTenantCode": false, "filterKeys": [ ], "chartType": "table", "valueType": "number", "drillChart": "none", "action": "", "plotLabel": "Ward", "postAggregationTheory" : "", "aggregationPaths": [ "Ws_Total_Collection", "Late_Charges", "Interest", "Advance", "Current_Charges", "Arrear_Charges" ], "pathDataTypeMapping": [ { "Ws_Total_Collection": "amount" }, { "Late_Charges": "amount" }, { "Interest": "amount" }, { "Advance": "amount" }, { "Current_Charges": "amount" }, { "Arrear_Charges": "amount" } ], "insight": { }, "_comment": "" }, "nssWsTotalConnectionnssWsTotalApplications": { "chartName": "NSS_WS_TOTAL_COLLECTIONSAPPLICATIONS", "queries": [ { "module": "WS", "dateRefField": "date", "requestQueryMap": "{\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\",\"ward\" : \"ward.keyword\"}", "indexName": "ws-national-dashboard", "aggrQuery": "{\"aggs\":{\"ConnectionsAGGR\":{\"filter\":{\"bool\":{}},\"aggs\":{\"intermediateAggr\":{\"terms\":{\"field\":\"date\"},\"aggs\":{\"applications\":{\"avg\":{\"field\":\"todaysTotalApplications\"}}}},\"CountTotal Applications\":{\"sum_bucket\":{\"fieldbuckets_path\":\"connectionsCreatedForConnectionTypeintermediateAggr.applications\"}}}}}}" } ], "translateTenantCode": false, "chartType": "metric", "valueType": "number", "action": "", "drillChart": "none", "aggregationPaths": [ "ConnectionsTotal Applications" ], "insight": { }, "_commentchartResponseMap" : " nssWsTotalApplications", }, "nssWsSLACompliance": { "chartName"action" : "NSS_WS_SLA_COMPLIANCEdifferenceOfNumbers", "queries": [ "upwardIndicator" {: "positive", "moduledownwardIndicator" : "WSnegative", "dateRefFieldtextMessage" : "date$indicator$value% than last $insightInterval", "colorCode" : "#228B22", "insightInterval" : "year" }, "_comment": " " }, "nssWsTotalConnection": { "chartName": "NSS_WS_ACTIVE_CONNECTIONS", "queries": [ { "module": "WS", "dateRefField": "date", "requestQueryMap": "{\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\",\"ward\" : \"ward.keyword\"}", "indexName": "ws-national-dashboard", "aggrQuery": "{\"aggs\":{\"Connections\":{\"filter\":{\"bool\":{}},\"aggs\":{\"Count\":{\"sum\":{\"field\":\"connectionsCreatedForConnectionType\"}}}}}}" } ], "translateTenantCode": false, "chartType": "metric", "valueType": "number", "action": "", "drillChart": "none", "aggregationPaths": [ "Connections" ], "insight": { }, "_comment": " " }, "nssWsSLACompliance": { "chartName": "NSS_WS_SLA_COMPLIANCE", "queries": [ { "module": "WS", "dateRefField": "date", "requestQueryMap": "{\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\",\"ward\" : \"ward.keyword\"}", "indexName": "ws-national-dashboard", "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must_not\":[{\"term\":{\"ulb.keyword\":\"pb.testing\"}}]}},\"aggs\":{\"SLA Compliance\":{\"avg\":{\"field\":\"slaCompliance\"}}}}}}" } ], "translateTenantCode": false, "chartType": "metric", "valueType": "percentage", "action": "", "drillChart": "none", "aggregationPaths": [ "SLA Compliance" ], "insight": { "chartResponseMap" : "nssWsSLACompliance", "action" : "differenceOfNumbers", "upwardIndicator" : "positive", "downwardIndicator" : "negative", "textMessage" : "$indicator$value% than last $insightInterval", "colorCode" : "#228B22", "insightInterval" : "year" }, "_comment": "WS SLA Compliance" }, "nssWsActiveMeteredWaterConnection": { "chartName": "NSS_WS_ACTIVE_METERED_WATER_CONNECTIONS", "queries": [ { "module": "WS", "indexName": "ws-national-dashboard", "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must\":[{\"terms\":{\"connectionType.keyword\":[\"WATER.METERED\"]}}]}},\"aggs\":{\"Active Metered Water Connections\":{\"sum\":{\"field\":\"connectionsCreatedForConnectionType\"}}}}}}", "requestQueryMap": "{\"module\" : \"module.keyword\", \"ulb\" : \"ulb.keyword\",\"state\" : \"state.keyword\",\"ward\" : \"ward.keyword\"}", "dateRefField": "date" } ], "translateTenantCode": false, "chartType": "metric", "valueType": "number", "action": "", "drillChart": "none", "aggregationPaths": [ "Active Metered Water Connections" ], "insight": { "chartResponseMap" : "nssWsActiveMeteredWaterConnection", "action" : "differenceOfNumbers", "upwardIndicator" : "positive", "downwardIndicator" : "negative", "textMessage" : "$indicator$value% than last $insightInterval", "colorCode" : "#228B22", "insightInterval" : "year" }, "_comment": "active metered water connections" }, "nssWsActiveNonMeteredWaterConnection": { "chartName": "NSS_WS_ACTIVE_NON_METERED_WATER_CONNECTIONS", "queries": [ { "module": "WS", "indexName": "ws-national-dashboard", "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must\":[{\"terms\":{\"connectionType.keyword\":[\"WATER.NONMETERED\"]}}]}},\"aggs\":{\"Active Non-Metered Water Connections\":{\"sum\":{\"field\":\"connectionsCreatedForConnectionType\"}}}}}}", "requestQueryMap": "{\"module\" : \"module.keyword\", \"ulb\" : \"ulb.keyword\",\"state\" : \"state.keyword\",\"ward\" : \"ward.keyword\"}", "dateRefField": "date" } ], "translateTenantCode": false, "chartType": "metric", "valueType": "number", "action": "", "drillChart": "none", "aggregationPaths": [ "Active Non-Metered Water Connections" ], "insight": { "chartResponseMap" : "nssWsActiveNonMeteredWaterConnection", "action" : "differenceOfNumbers", "upwardIndicator" : "positive", "downwardIndicator" : "negative", "textMessage" : "$indicator$value% than last $insightInterval", "colorCode" : "#228B22", "insightInterval" : "year" }, "_comment": "active non-metered water connections" }, "nssWsActiveSewerageConnection": { "chartName": "NSS_WS_ACTIVE_SEWERAGE_CONNECTIONS", "queries": [ { "module": "WS", "indexName": "ws-national-dashboard", "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must\":[{\"terms\":{\"connectionType.keyword\":[\"SEWERAGE\"]}}]}},\"aggs\":{\"Active Sewerage Connections\":{\"sum\":{\"field\":\"connectionsCreatedForConnectionType\"}}}}}}", "requestQueryMap": "{\"module\" : \"module.keyword\", \"ulb\" : \"ulb.keyword\",\"state\" : \"state.keyword\"}", "dateRefField": "date" } ], "translateTenantCode": false, "chartType": "metric", "valueType": "number", "action": "", "drillChart": "none", "aggregationPaths": [ "Active Sewerage Connections" ], "insight": { "chartResponseMap" : "nssWsActiveSewerageConnection", "action" : "differenceOfNumbers", "upwardIndicator" : "positive", "downwardIndicator" : "negative", "textMessage" : "$indicator$value% than last $insightInterval", "colorCode" : "#228B22", "insightInterval" : "year" }, "_comment": "active sewerage connections " }, "nssWsCumulativeConnections": { "chartName": "NSS_WS_CUMULATIVE_CONNECTION", "queries": [ { "module": "WS", "dateRefField": "date", "requestQueryMap": "{\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\",\"ward\" : \"ward.keyword\"}", "indexName": "ws-national-dashboard", "aggrQuery": "{\"aggs\":{\"Water Connections\":{\"date_histogram\":{\"field\":\"date\",\"interval\":\"intervalvalue\"},\"aggs\":{\"Water\":{\"filter\":{\"bool\":{\"must\":[{\"terms\":{\"connectionType.keyword\":[\"WATER.NONMETERED\",\"WATER.METERED\"]}}]}},\"aggs\":{\"Sum\":{\"sum\":{\"field\":\"connectionsCreatedForConnectionType\"}}}}}},\"Sewerage Connections\":{\"date_histogram\":{\"field\":\"date\",\"interval\":\"intervalvalue\"},\"aggs\":{\"Sewerage\":{\"filter\":{\"bool\":{\"must\":[{\"terms\":{\"connectionType.keyword\":[\"SEWERAGE\"]}}]}},\"aggs\":{\"Count\":{\"sum\":{\"field\":\"connectionsCreatedForConnectionType\"}}}}}}}}" } ], "translateTenantCode": false, "chartType": "line", "valueType": "number", "action": "", "drillChart": "none", "documentType": "_doc", "aggregationPaths": [ "Water Connections", "Sewerage Connections" ], "isCumulative": true, "interval": "month", "insight": { }, "_comment": " " }, "nssWsWaterConnectionByUsageType": { "chartName": "NSS_WS_WATER_CONNECTION_BY_USAGE", "queries": [ { "module": "WS", "dateRefField": "date", "requestQueryMap": "{\"tenantId\" : \"tenantId.keyword\",\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\",\"ward\" : \"ward.keyword\"}", "indexName": "ws-national-dashboard", "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{}},\"aggs\":{\"Connection by Usage Type\":{\"terms\":{\"field\":\"usageType.keyword\",\"size\":200},\"aggs\":{\"Water Connections\":{\"sum\":{\"field\":\"waterConnectionsForUsageType\"}}}}}}}}" } ], "translateTenantCode": false, "chartType": "pie", "valueType": "number", "action": "", "documentType": "_doc", "drillChart": "none", "aggregationPaths": [ "Connection by Usage Type" ], "insight": { }, "_comment": " " }, "nssWsSewerageConnectionByUsageType": { "chartName": "NSS_WS_SEWERAGE_CONNECTION_BY_USAGE", "queries": [ { "module": "WS", "dateRefField": "date", "requestQueryMap": "{\"tenantId\" : \"tenantId.keyword\",\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\",\"ward\" : \"ward.keyword\"}", "indexName": "ws-national-dashboard", "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{}},\"aggs\":{\"Connection by Usage Type\":{\"terms\":{\"field\":\"usageType.keyword\",\"size\":200},\"aggs\":{\"Sewerage Connections\":{\"sum\":{\"field\":\"sewerageConnectionsForUsageType\"}}}}}}}}" } ], "translateTenantCode": false, "chartType": "pie", "valueType": "number", "action": "", "documentType": "_doc", "drillChart": "none", "aggregationPaths": [ "Connection by Usage Type" ], "insight": { }, "_comment": " " }, "nssWsConnectionByChannelType": { "chartName": "NSS_WS_CONNECTION_BY_CHANNEL", "queries": [ { "module": "WS", "dateRefField": "date", "requestQueryMap": "{\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\",\"ward\" : \"ward.keyword\"}", "indexName": "ws-national-dashboard", "aggrQuery": "{\"aggs\":{\"Connection by Channel Type\":{\"terms\":{\"field\":\"channelType.keyword\",\"size\":200},\"aggs\":{\"Total Connections\":{\"sum\":{\"field\":\"connectionsCreatedForChannelType\"}}}}}}" } ], "translateTenantCode": false, "chartType": "pie", "valueType": "number", "action": "", "documentType": "_doc", "drillChart": "none", "aggregationPaths": [ "Connection by Channel Type" ], "insight": { }, "_comment": " " }, "nssWsConnectionAgeingState": { "chartName": "NSS_WS_CONNECTION_AGEING", "queries": [ { "module": "WS", "dateRefField": "date", "requestQueryMap": "{\"state\" : \"state.keyword\",\"ward\" : \"ward.keyword\"}", "indexName": "ws-national-dashboard", "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{}},\"aggs\":{\"State \":{\"terms\":{\"field\":\"state.keyword\",\"size\":200},\"aggs\":{\"Pending_from_0_to_3_days\":{\"filter\":{\"terms\":{\"duration.keyword\":[\"0to3Days\"]}},\"aggs\":{\"Total\":{\"sum\":{\"field\":\"pendingConnectionsForDuration\"}}}},\"Pending_from_3_to_7_days\":{\"filter\":{\"terms\":{\"duration.keyword\":[\"3to7Days\"]}},\"aggs\":{\"Total\":{\"sum\":{\"field\":\"pendingConnectionsForDuration\"}}}},\"Pending_from_7_to_15_days\":{\"filter\":{\"terms\":{\"duration.keyword\":[\"7to15Days\"]}},\"aggs\":{\"Total\":{\"sum\":{\"field\":\"pendingConnectionsForDuration\"}}}},\"Pending_from_more_than_15_days\":{\"filter\":{\"terms\":{\"duration.keyword\":[\"MoreThan15Days\"]}},\"aggs\":{\"Total\":{\"sum\":{\"field\":\"pendingConnectionsForDuration\"}}}},\"Total Connection\":{\"sum\":{\"field\":\"pendingConnectionsForDuration\"}}}}}}}}" } ], "isMdmsEnabled": false, "filterKeys": [ {"key": "state", "column": "State"} ], "chartType": "xtable", "valueType": "number", "drillChart": "nssWsConnectionAgeingULB", "action": "", "plotLabel": "State", "postAggregationTheory" : "", "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", "_comments": "fields are field names picked from its aggregation query to use post aggregation newField value with given new field name " } ], "insight": { }, "_comment": "" }, "nssWsConnectionAgeingULB": { "chartName": "NSS_WS_CONNECTION_AGEING", "queries": [ { "module": "WS", "dateRefField": "date", "requestQueryMap": "{\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\"}", "indexName": "ws-national-dashboard", "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{}},\"aggs\":{\"ULB \":{\"terms\":{\"field\":\"ulb.keyword\",\"size\":200},\"aggs\":{\"Pending_from_0_to_3_days\":{\"filter\":{\"terms\":{\"duration.keyword\":[\"0to3Days\"]}},\"aggs\":{\"Total\":{\"sum\":{\"field\":\"pendingConnectionsForDuration\"}}}},\"Pending_from_3_to_7_days\":{\"filter\":{\"terms\":{\"duration.keyword\":[\"3to7Days\"]}},\"aggs\":{\"Total\":{\"sum\":{\"field\":\"pendingConnectionsForDuration\"}}}},\"Pending_from_7_to_15_days\":{\"filter\":{\"terms\":{\"duration.keyword\":[\"7to15Days\"]}},\"aggs\":{\"Total\":{\"sum\":{\"field\":\"pendingConnectionsForDuration\"}}}},\"Pending_from_more_than_15_days\":{\"filter\":{\"terms\":{\"duration.keyword\":[\"MoreThan15Days\"]}},\"aggs\":{\"Total\":{\"sum\":{\"field\":\"pendingConnectionsForDuration\"}}}},\"Total Connection\":{\"sum\":{\"field\":\"pendingConnectionsForDuration\"}}}}}}}}" } ], "isMdmsEnabled": false, "filterKeys": [ {"key": "ulb", "column": "ULB"} ], "chartType": "xtable", "valueType": "number", "drillChart": "nssWsConnectionAgeingWard", "action": "", "plotLabel": "ULB", "postAggregationTheory" : "", "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", "_comments": "fields are field names picked from its aggregation query to use post aggregation newField value with given new field name " } ], "insight": { }, "_comment": "" }, "nssWsConnectionAgeingWard": { "chartName": "", "queries": [ { "module": "WS", "dateRefField": "date", "requestQueryMap": "{\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\",\"ward\" : \"ward.keyword\"}", "indexName": "ws-national-dashboard", "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{}},\"aggs\":{\"Ward \":{\"terms\":{\"field\":\"ward.keyword\",\"size\":200},\"aggs\":{\"Pending_from_0_to_3_days\":{\"filter\":{\"terms\":{\"duration.keyword\":[\"0to3Days\"]}},\"aggs\":{\"Total\":{\"sum\":{\"field\":\"pendingConnectionsForDuration\"}}}},\"Pending_from_3_to_7_days\":{\"filter\":{\"terms\":{\"duration.keyword\":[\"3to7Days\"]}},\"aggs\":{\"Total\":{\"sum\":{\"field\":\"pendingConnectionsForDuration\"}}}},\"Pending_from_7_to_15_days\":{\"filter\":{\"terms\":{\"duration.keyword\":[\"7to15Days\"]}},\"aggs\":{\"Total\":{\"sum\":{\"field\":\"pendingConnectionsForDuration\"}}}},\"Pending_from_more_than_15_days\":{\"filter\":{\"terms\":{\"duration.keyword\":[\"MoreThan15Days\"]}},\"aggs\":{\"Total\":{\"sum\":{\"field\":\"pendingConnectionsForDuration\"}}}},\"Total Connection\":{\"sum\":{\"field\":\"pendingConnectionsForDuration\"}}}}}}}}" } ], "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", "_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": "NSS_WS_DASHBOARD", "id": "national-ws", "isActive": "", "style": "linear", "visualizations": [ { "row": 1, "name": "NSS_REVENUE", "vizArray": [ { "id": 211, "name": "NSS_OVERVIEW", "dimensions": { "height": 350, "width": 5 }, "vizType": "metric-collection", "noUnit": true, "isCollapsible": false, "label": "NSS_OVERVIEW", "charts": [ { "id": "nssWsTodaysCollection", "name": "NSS_WS_TODAYS_COLLECTION", "code": "", "chartType": "metric", "filter": "", "headers": [] }, { "id": "nssWsTotalCollection", "name": "NSS_WS_TOTAL_COLLECTION", "code": "", "chartType": "metric", "filter": "", "headers": [] }, { "id": "nssWsTargetCollection", "name": "NSS_WS_TARGET_COLLECTION", "code": "", "chartType": "metric", "filter": "", "headers": [] }, { "id": "nssWsTargetAchieved", "name": "NSS_WS_TARGET_ACHIEVED", "code": "", "chartType": "metric", "filter": "", "headers": [] } ] }, { "id": "212", "name": "NSS_WS_TOTAL_CUMULATIVE_COLLECTION", "dimensions": { "height": 350, "width": 7 }, "vizType": "chart", "noUnit": true, "isCollapsible": false, "charts": [ { "id": "nssWsCumulativeCollections", "name": "Monthly", "code": "", "chartType": "line", "filter": "", "headers": [] } ] } ] }, { "row": 2, "name": "NSS_REVENUE", "vizArray": [ { "id": 221, "name": "NSS_WS_TOP_3_PERFORMING_STATES", "dimensions": { "height": 250, "width": 4 }, "vizType": "performing-metric", "noUnit": false, "isCollapsible": false, "label": "", "charts": [ { "id": "nssWsTopPerformingUlbs", "name": "NSS_WS_TOP_3_PERFORMING_STATES", "code": "", "chartType": "bar", "filter": "", "headers": [] } ] }, { "id": 222, "name": "NSS_WS_BOTTOM_3_PERFORMING_STATES", "dimensions": { "height": 250, "width": 4 }, "vizType": "performing-metric", "noUnit": false, "isCollapsible": false, "charts": [ { "id": "nssWsBottomPerformingUlbs", "name": "NSS_WS_BOTTOM_3_PERFORMING_STATES", "code": "", "chartType": "bar", "filter": "", "headers": [] } ] } ] }, { "row": 3, "name": "NSS_REVENUE", "vizArray": [ { "id": 223, "name": "NSS_WS_COLLECTION_BY_USAGE", "dimensions": { "height": 250, "width": 4 }, "vizType": "chart", "noUnit": true, "isCollapsible": false, "charts": [ { "id": "nssWsCollectionByUsage", "name": "NSS_WS_COLLECTION_BY_USAGE", "code": "", "chartType": "donut", "filter": "", "headers": [] } ] }, { "id": 224, "name": "NSS_WS_COLLECTION_BY_CHANNEL", "dimensions": { "height": 250, "width": 4 }, "vizType": "chart", "noUnit": true, "isCollapsible": false, "charts": [ { "id": "nssWsCollectionByChannel", "name": "NSS_WS_COLLECTION_BY_CHANNEL", "code": "", "chartType": "donut", "filter": "", "headers": [] } ] } ] }, { "row": 4, "name": "NSS_REVENUE", "vizArray": [ { "id": 231, "name": "NSS_WS_KEY_FY_INDICATORS", "dimensions": { "height": 350, "width": 12 }, "vizType": "chart", "noUnit": false, "isCollapsible": false, "charts": [ { "id": "nssWsFinancialIndicatorState", "name": "NSS_WS_DEMAND_COLLECTION_BOUNDARY", "code": "", "chartType": "table", "filter": "", "headers": [], "tabName": "Boundary" } ] } ] }, { "chartTyperow": "table", 5, "filtername": "NSS_REVENUE", "vizArray": [ "headers": [], { "tabNameid": 231, "Boundary" "name": "NSS_WS_TAX_HEAD_BOUNDARY", } "dimensions": { ] } "height": 350, ] }, "width": 12 { }, "row": 5, "namevizType": "NSS_REVENUEchart", "vizArraylabel": "", [ {"noUnit": false, "idisCollapsible": 231true, "namecharts": "NSS_WS_TAX_HEAD_BOUNDARY", [ "dimensions": { "heightid": 350"nssWsTaxHeadState", "widthname": 12 "NSS_WS_TAX_HEAD_BOUNDARY", }, "vizTypecode": "chart", "labelchartType": "table", "noUnitfilter": false,"", "isCollapsibleheaders": true,[], "chartstabName": "Boundary" [ } { ] "id": "nssWsTaxHeadState", } ] "name": "NSS_WS_TAX_HEAD_BOUNDARY", }, { "code": "", "row": 7, "chartTypename": "tableNSS_SERVICE", "vizArray": [ "filter": "", { "headersid": [], 231, "tabNamename": "Boundary"NSS_OVERVIEW", "dimensions": { } ]"height": 350, } "width": 12 ] }, { "vizType": "metric-collection", "row": 7, "namelabel": "NSS_SERVICE", "vizArray": [ {"noUnit": false, "idisCollapsible": 231true, "namecharts": "NSS_OVERVIEW", [ "dimensions": { "heightid": 350"nssWsTotalApplications", "widthname": 12 "NSS_WS_TOTAL_APPLICATIONS", }, "vizTypecode": "metric-collection", "labelchartType": "metric", "noUnitfilter": false"", "isCollapsibleheaders": [] true, "charts": [ }, { "id": "nssWsTotalConnectionnssWsSLACompliance", "name": "NSS_WS_SLA_CONNECTIONSCOMPLIANCE", "code": "", "chartType": "metric", "filter": "", "headers": [] }, { "id": "nssWsSLACompliancenssWsTotalConnection", "name": "NSS_WS_SLAACTIVE_COMPLIANCECONNECTIONS", "code": "", "chartType": "metric", "filter": "", "headers": [] }, { "id": "nssWsActiveMeteredWaterConnection", "name": "NSS_WS_ACTIVE_METERED_WATER_CONNECTIONS", "code": "", "chartType": "metric", "filter": "", "headers": [] }, { "id": "nssWsActiveNonMeteredWaterConnection", "name": "NSS_WS_ACTIVE_NON_METERED_WATER_CONNECTIONS", "code": "", "chartType": "metric", "filter": "", "headers": [] }, { "id": "nssWsActiveSewerageConnection", "name": "NSS_WS_ACTIVE_SEWERAGE_CONNECTIONS", "code": "", "chartType": "metric", "filter": "", "headers": [] } ] }, { "id": 232, "name": "NSS_WS_CUMULATIVE_CONNECTION", "dimensions": { "height": 350, "width": 7 }, "vizType": "chart", "isCollapsible": false, "charts": [ { "id": "nssWsCumulativeConnections", "name": "Monthly", "code": "", "chartType": "line", "filter": "", "headers": [] } ] } ] }, { "row": 8, "name": "NSS_SERVICE", "vizArray": [ { "id": 231, "name": "NSS_WS_WATER_CONNECTION_BY_USAGE", "dimensions": { "height": 350, "width": 12 }, "vizType": "chart", "label": "", "noUnit": false, "isCollapsible": true, "charts": [ { "id": "nssWsWaterConnectionByUsageType", "name": "", "code": "", "chartType": "donut", "filter": "", "headers": [] } ] }, { "id": 232, "name": "NSS_WS_SEWERAGE_CONNECTION_BY_USAGE", "dimensions": { "height": 350, "width": 12 }, "vizType": "chart", "label": "", "noUnit": false, "isCollapsible": true, "charts": [ { "id": "nssWsSewerageConnectionByUsageType", "name": "", "code": "", "chartType": "donut", "filter": "", "headers": [] } ] }, { "id": 233, "name": "NSS_WS_CONNECTION_BY_CHANNEL", "dimensions": { "height": 350, "width": 12 }, "vizType": "chart", "label": "", "noUnit": false, "isCollapsible": true, "charts": [ { "id": "nssWsConnectionByChannelType", "name": "NSS_WS_CONNECTION_BY_CHANNEL", "code": "", "chartType": "donut", "filter": "", "headers": [] } ] } ] }, { "row": 9, "name": "NSS_SERVICE", "vizArray": [ { "id": 231, "name": "NSS_WS_CONNECTION_AGEING", "dimensions": { "height": 350, "width": 12 }, "vizType": "chart", "label": "", "noUnit": false, "isCollapsible": true, "charts": [ { "id": "nssWsConnectionAgeingState", "name": "NSS_WS_CONNECTION_AGEING", "code": "", "chartType": "table", "filter": "", "headers": [], "tabName": "Boundary" } ] } ] } ] } |
...
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:
This Graph contains the Water and Sewerage collection amount information in the monthly base as a cumulative line graph for each water and sewerage collection separately. This will change as per the denomination amount filter selection.
line - this graph/chart is data representation on date histograms or date groupings.
...
Top
...
State By Performance:
This graph represents the ULB’s States based on the Target achieved in bar chart representation with the % of target achieved in descending order.
...
Bottom
...
State by Performance:
This graph represents the ULB’s States based on the target achieved in bar chart representation with the % of target achieved in ascending 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.
...
W&S Tax Heads:
This tabular chart representation graph shows multiple W&S information like Total Collection, Penalty, Interest and Target Collection. 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.
...
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.Total Applications : This represents the total number of applications for new, modify, and disconnections requests.
...
Total Cumulative Connections:
...
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 State to ulb and from ulb to ward level data for the same.
...