...
Here is the sample ChartApiConfiguration.json data for the W&S.
Code Block | ||
---|---|---|
| ||
"_comment": "National Dashboard-WS Revenue Tab configs start here-------------------------------", "nssWsTodaysCollection": { "chartName": "NSS_WS_TODAYS_COLLECTION", "queries": [ { "module": "WS", "indexName": "ws-national-dashboard", "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{}},\"mustaggs\":[{\"rangetodaysDate\":{\"dateterms\":{\"gtfield\":\"now-1d\/d\",\"ltedate\",\"order\":{\"_term\":\"nowdesc\"}}}]}},\"size\":1},\"aggs\":{\"Todays Collection\":{\"sum\":{\"field\":\"todaysCollectionForPaymentChannelType\"}}}},\"lastUpdatedTime\":{\"terms\":{\"field\":\"lastModifiedTime\",\"order\":{\"_term\":\"desc\"},\"size\":1}}}}}}", "requestQueryMap": "{\"module\" : \"module.keyword\", \"state\" : \"state.keyword\", \"ulb\" : \"ulb.keyword\"}", "dateRefField": "" } ], "chartType": "metric", "valueType": "amount", "drillChart": "none", "documentType": "nss", "action": "", "TodaysCollection":true, "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", "isRoundOff": true }, "_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", "isRoundOff": true }, "_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", "isRoundOff": true, "aggregationPaths": [ "Total Collection", "Target Collection" ], "insightpreActionTheory": { "chartResponseMapTarget Collection" : "nssWsTargetAchieved",repsonseToDifferenceOfDates" }, "actioninsight" : "differenceOfNumbers",{ "upwardIndicatorchartResponseMap" : "nssWsTargetAchieved", "action" : "differenceOfNumbers", "upwardIndicator" : "positive", "downwardIndicator" : "negative", "textMessage" : "$indicator$value% than last $insightInterval", "colorCode" : "#228B22", "insightInterval" : "year", "isRoundOff": true }, "_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": "amount", "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\"},\"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\"},\"aggs\":{\"Sum\":{\"sum\":{\"field\":\"todaysCollectionForPaymentChannelType\"}}}}}}}}" } ], "isMdmsEnabled": false, "isPostResponseHandler": true, "chartType": "perform", "valueType": "percentage", "drillChart": "none", "documentType": "_doc", "action": "percentage", "plotLabel": "NSS_WS_TOP_3_PERFORMING_STATES", "order": "desc", "limit": 3, "isRoundOff": true, "aggregationPaths": [ "Total Collection","Target Collection" ], "preActionTheory":{ "Target Collection":"repsonseToDifferenceOfDates" }, "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\"},\"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\"},\"aggs\":{\"Sum\":{\"sum\":{\"field\":\"todaysCollectionForPaymentChannelType\"}}}}}}}}" } ], "isMdmsEnabled": false, "isPostResponseHandler": true, "chartType": "perform", "valueType": "percentage", "drillChart": "none", "documentType": "_doc", "action": "percentage", "plotLabel": "NSS_WS_BOTTOM_3_PERFORMING_STATES", "order": "asc", "limit": 3, "isRoundOff": true, "aggregationPaths": [ "Total Collection", "Target Collection" ], "preActionTheory":{ "Target Collection":"repsonseToDifferenceOfDates" }, "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": truefalse, "chartType": "pie", "valueType": "amount", "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": truefalse, "chartType": "pie", "valueType": "amount", "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\":{\"Ws_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\":{\"Statestate\":{\"terms\":{\"field\":\"state.keyword\"},\"sizeaggs\":{\"200intermediateAggrULB\",:{\"orderterms\":{\"Total_Connectionsfield\":\"desculb.keyword\"}},\"aggs\":{\"Total_ConnectionsintermediateAggrWard\":{\"terms\":{\"field\":\"ward.keyword\"},\"aggs\":{\"days\":{\"terms\":{\"field\":\"date\"},\"aggs\":{\"Transactions\":{\"avg\":{\"field\":\"transactions\"}}}},\"wardTransactions\":{\"sum_bucket\":{\"buckets_path\":\"days.Transactions\"}}}},\"ulbTransactions\":{\"sum_bucket\":{\"fieldbuckets_path\":\"connectionsCreatedForConnectionTypeintermediateAggrWard.wardTransactions\"}}}},\"Ws_Total_Collection\"Total_Transactions\":{\"sum_bucket\":{\"buckets_path\":\"intermediateAggrULB.ulbTransactions\"}},\"Total_Connections\":{\"sum\":{\"field\":\"todaysCollectionForPaymentChannelTypeconnectionsCreatedForConnectionType\"}},\"Ws_Total_TransactionsCollection\":{\"avgsum\":{\"field\":\"transactionstodaysCollectionForPaymentChannelType\"}}}}}}}}" } ], "filterKeys": [ { "key": "state","column": "State" } ], "isPostResponseHandler": truefalse, "postAggregationTheory": "repsonseToDifferenceOfDates", "chartType": "xtable", "valueType": "number", "drillChart": "nssWsFinancialIndicatorTenant", "documentType": "_doc", "action": "", "plotLabel": "State", "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","Target_Collection"], "newField" : "amountTarget_Achieved", }, "_comments": "fields are field names picked {from its aggregation query to use post aggregation newField value "Total_Transactions": "number" with given new field name " }, } { ], "Total_ConnectionsexcludedColumns": "number"["Ws_Target_Collection"], },"pathDataTypeMapping": [ { "Ws_Target_Collection": "amount" }, { "TargetTotal_AchievedConnections": "percentagenumber" }, { ], "insightTotal_Transactions": "number" { }, "_comment": " "{ }, "nssWsFinancialIndicatorTenant": {"Ws_Total_Collection": "amount" }, { "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\":{\"Ws_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\":{\"ULBintermediateAggrULB\":{\"terms\":{\"field\":\"ulb.keyword\"},\"sizeaggs\":{\"200intermediateAggrWard\",:{\"orderterms\":{\"Total_Connectionsfield\":\"descward.keyword\"}},\"aggs\":{\"Total_Connectionsdays\":{\"sumterms\":{\"field\":\"connectionsCreatedForConnectionTypedate\"}},\"Ws_Total_Collectionaggs\":{\"sumTransactions\":{\"avg\":{\"field\":\"transactions\"}}}},\"wardTransactions\":{\"todaysCollectionForPaymentChannelTypesum_bucket\":{\"buckets_path\":\"days.Transactions\"}}}},\"Total_Transactions\":{\"sum_bucket\":{\"avg\"buckets_path\":\"intermediateAggrWard.wardTransactions\"}},\"Total_Connections\":{\"sum\":{\"field\":\"connectionsCreatedForConnectionType\"}},\"Ws_Total_Collection\":{\"sum\":{\"field\":\"transactionstodaysCollectionForPaymentChannelType\"}}}}}}}}" } ], "filterKeys": [ { "key": "ulb","column": "ULB" } ], "postAggregationTheory": "repsonseToDifferenceOfDates", "chartType": "xtable", "valueType": "number", "drillChart": "nssWsFinancialIndicatorWard", "documentType": "_doc", "action": "", "plotLabel": "ULB", "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 " }, ], { "pathDataTypeMapping": [ "postAggregationTheory" : "", { "Ws_Total_CollectionactionName": "amountPercentageComputedField", }, "fields" {: ["Ws_Total_Collection","Target_Collection"], "Total_TransactionsnewField" : "numberTarget_Achieved", }, "_comments": "fields are field names picked from {its aggregation query to use post aggregation newField value with "Total_Connections": "number" given new field name " }, } { ], "excludedColumns":["Ws_Target_Collection":], "amount" },"pathDataTypeMapping": [ { "Ws_Target_AchievedCollection": "percentageamount" }, ], { "insight": {}, "Total_commentConnections": "number" }, { "nssWsFinancialIndicatorWard": { "chartNameTotal_Transactions": "number", "queries": [ }, { "moduleWs_Total_Collection": "COMMONamount", }, "requestQueryMap": "{\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\",\"ward\" : \"ward.keyword\"}", { "dateRefFieldTarget_Collection": "dateamount", }, "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\"}}}}}}}}" "Target_Achieved": "percentage" } ], "insight": {}, "_comment": "" }, }, "nssWsFinancialIndicatorWard": { { "chartName": "", "modulequeries": "WS", [ { "dateRefFieldmodule": "dateCOMMON", "requestQueryMap": "{\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\",\"ward\" : \"ward.keyword\"}", "indexNamedateRefField": "wsdate", "indexName": "master-national-dashboard", "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{}},\"aggs\":{\"Wardstate \":{\"terms\":{\"field\":\"ward.keyword\",\"size\":\"200\"},\"orderaggs\":{\"TotalWs_Target_ConnectionsCollection\":\"desc\"}},\"aggs\":{\"Total_Connectionsfilter\":{\"sumterm\":{\"fieldmodule.keyword\":\"connectionsCreatedForConnectionTypeWS\"}},\"Ws_Total_Collectionaggs\":{\"sum\":{\"fieldsum\":\"todaysCollectionForPaymentChannelType\"}},\"Total_Transactions\":{\"avg\":{\"field\":\"transactionsbudgetProposedForMunicipalCorporation\"}}}}}}}}" }, ], { "isMdmsEnabled": false, "filterKeysmodule": [ "WS", ], "postAggregationTheorydateRefField": "repsonseToDifferenceOfDatesdate", "chartTyperequestQueryMap": "xtable", "valueType": "number", "drillChart": "", "documentType": "_doc{\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\",\"ward\" : \"ward.keyword\"}", "action": "", "plotLabelindexName": "Wardws-national-dashboard", "aggregationPaths": [ "Target_Collection", "Ws_Total_Collection", "Total_Transactions", "Total_Connections" ], "computedFields": [ { "postAggregationTheory" : "", "actionName": "PercentageComputedField", "fields" : ["Ws_Total_Collection","Target_Collection"], "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{}},\"aggs\":{\"intermediateAggrWard\":{\"terms\":{\"field\":\"ward.keyword\"},\"aggs\":{\"days\":{\"terms\":{\"field\":\"date\"},\"aggs\":{\"Transactions\":{\"avg\":{\"field\":\"transactions\"}}}},\"Total_Transactions\":{\"sum_bucket\":{\"buckets_path\":\"days.Transactions\"}},\"Total_Connections\":{\"sum\":{\"field\":\"connectionsCreatedForConnectionType\"}},\"Ws_Total_Collection\":{\"sum\":{\"field\":\"todaysCollectionForPaymentChannelType\"}}}}}}}}" } ], "isMdmsEnabled": false, "filterKeys": [ ], "postAggregationTheory": "repsonseToDifferenceOfDates", "chartType": "xtable", "valueType": "number", "drillChart": "", "documentType": "_doc", "action": "", "plotLabel": "Ward", "aggregationPaths": [ "Ws_Target_Collection", "Total_Connections", "Total_Transactions", "Ws_Total_Collection" ], "computedFields": [ { "postAggregationTheory" : "repsonseToDifferenceOfDates", "actionName": "AdditiveComputedField", "fields" : ["Ws_Target_Collection"], "newField" : "Target_Collection", "_comments": "fields are field names picked from its aggregation query to use post aggregation newField value with given new field name " }, { "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 " } ], "excludedColumns":["Ws_Target_Collection"], "pathDataTypeMapping": [ { "Ws_Target_Collection": "amount" }, { "Total_Connections": "number" }, { "Total_Transactions": "number" }, { "Ws_Total_Collection": "amount" }, { "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": "amount", "drillChart": "nssWsTaxHeadTenant", "action": "", "plotLabel": "State", "newFieldpostAggregationTheory" : "Target_Achieved", "aggregationPaths": [ "Ws_comments": "fields are field names picked from its aggregation query to use post aggregation newField value with given new field name "Total_Collection", "Late_Charges", "Interest", "Advance", "Current_Charges", }"Arrear_Charges" ], "pathDataTypeMapping": [ { "Ws_Total_Collection": "amount" }, { "Total_TransactionsLate_Charges": "amount" }, { "Interest": "numberamount" }, { "Total_ConnectionsAdvance": "numberamount" }, { "TargetCurrent_CollectionCharges": "amount" }, { "TargetArrear_AchievedCharges": "percentageamount" } ], "insight": { }, "_comment": "" }, "nssWsTaxHeadStatenssWsTaxHeadTenant": { "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\":{\"StateULB \":{\"terms\":{\"field\":\"stateulb.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": "stateulb", "column": "StateULB"} ], "chartType": "table", "valueType": "amount", "drillChart": "nssWsTaxHeadTenantnssWsTaxHeadWard", "action": "", "plotLabel": "StateULB", "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": "" }, "nssWsTaxHeadTenantnssWsTaxHeadWard": { "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\":{\"ULBWard \":{\"terms\":{\"field\":\"ulbward.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": "amount",":{\"amount\":{\"sum\":{\"field\":\"todaysCollectionForTaxHeads\"}}}},\"Ws_Total_Collection\":{\"sum\":{\"field\":\"todaysCollectionForTaxHeads\"}}}}}}}}" "drillChart": "nssWsTaxHeadWard", } "action": "" ], "plotLabelisMdmsEnabled": "ULB"false, "postAggregationTheorytranslateTenantCode" : ""false, "aggregationPathsfilterKeys": [ "Ws_Total_Collection"], "chartType": "Late_Chargestable", "Interest", "Advance", valueType": "amount", "Current_Charges", "Arrear_Charges" ]drillChart": "none", "pathDataTypeMappingaction": [ { "", "Ws_Total_CollectionplotLabel": "amountWard", "postAggregationTheory" : }"", {"aggregationPaths": [ "LateWs_Total_ChargesCollection":, "amount" }"Late_Charges", { "Interest", "InterestAdvance":, "amount" }"Current_Charges", {"Arrear_Charges" ], "Advance": "amount" "pathDataTypeMapping": [ }, { "CurrentWs_Total_ChargesCollection": "amount" }, { "ArrearLate_Charges": "amount" }, ], "insight": { }, "_commentInterest": "amount" }, { "nssWsTaxHeadWard": { "chartNameAdvance": "amount", "queries": [ }, { "moduleCurrent_Charges": "WSamount", }, "dateRefField": "date", { "requestQueryMap": "{\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\",\"ward\" : \"ward.keyword\"}","Arrear_Charges": "amount" } "indexName": "ws-national-dashboard", ], "aggrQueryinsight": "{\"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\"]{ }, "_comment": "" }, "_comment": "National Dashboard-WS- Service Tab- all cards configs start here", "nssWsTotalApplications": { "chartName": "NSS_WS_TOTAL_APPLICATIONS", "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\":{\"amountstate\":{\"sumterms\":{\"field\":\"todaysCollectionForTaxHeadsstate.keyword\"}}}},\"Advanceaggs\":{\"filterintermediateAggrULB\":{\"terms\":{\"taxHeads.keywordfield\":[\"ADVANCEulb.keyword\"]}},\"aggs\":{\"amountintermediateAggrWard\":{\"sumterms\":{\"field\":\"todaysCollectionForTaxHeadsward.keyword\"}}}},\"Current_Chargesaggs\":{\"filterdays\":{\"terms\":{\"taxHeads.keywordfield\":[\"CURRENT.CHARGESdate\"]}},\"aggs\":{\"amountapplications\":{\"sumavg\":{\"field\":\"todaysCollectionForTaxHeadstodaysTotalApplications\"}}}},\"Ws_Total_Collectionwardapplications\":{\"sum_bucket\":{\"fieldbuckets_path\":\"todaysCollectionForTaxHeadsdays.applications\"}}}}}}}}" } ], "isMdmsEnabled": false, "translateTenantCode": false, "filterKeys": [ ], "chartType": "table", "valueType": "amount", "drillChart": "none", "action": "", "plotLabel": "Ward", "postAggregationTheory" : "", "aggregationPaths": [ "Ws_Total_Collection", "Late_Charges", "Interest", "Advance",,\"ulbApplications\":{\"sum_bucket\":{\"buckets_path\":\"intermediateAggrWard.wardapplications\"}}}},\"stateApplications\":{\"sum_bucket\":{\"buckets_path\":\"intermediateAggrULB.ulbApplications\"}}}},\"Total Applications\":{\"sum_bucket\":{\"buckets_path\":\"state.stateApplications\"}}}}}}" "Current_Charges", } "Arrear_Charges" ], ], "pathDataTypeMappingtranslateTenantCode": [ { false, "Ws_Total_CollectionchartType": "amountmetric", }"valueType": "number", { "action": "", "Late_ChargesdrillChart": "amountnone", }, {"aggregationPaths": [ "Interest":Total Applications"amount" }], "insight": { "AdvancechartResponseMap" : "amountnssWsTotalApplications", } "action" : "differenceOfNumbers", { "upwardIndicator" : "positive", "Current_ChargesdownwardIndicator" : "amountnegative", }, "textMessage" : "$indicator$value% than {last $insightInterval", "Arrear_ChargescolorCode" : "amount#228B22", } "insightInterval" : "year", ], "insightisRoundOff": {true }, "_comment": " " }, "nssWsTotalApplicationsnssWsTotalConnection": { "chartName": "NSS_WS_TOTALACTIVE_APPLICATIONSCONNECTIONS", "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\":{\"intermediateAggr\":{\"terms"aggrQuery": "{\"aggs\":{\"fieldConnections\":{\"date\"},filter\"aggs\":{\"applicationsbool\":{}},\"avgaggs\":{\"fieldCount\":\"todaysTotalApplications\"}}}},\"Total Applications\":{\"sum_bucket\":{\"buckets_pathfield\":\"intermediateAggr.applicationsconnectionsCreatedForConnectionType\"}}}}}}" } ], "translateTenantCode": false, "chartType": "metric", "valueType": "number", "action": "", "drillChart": "none", "aggregationPaths": [ "Total ApplicationsConnections" ], "insight": { "chartResponseMap" : "nssWsTotalApplicationsnssWsTotalConnection", "action" : "differenceOfNumbers", "upwardIndicator" : "positive", "downwardIndicator" : "negative", "textMessage" : "$indicator$value% than last $insightInterval", "colorCode" : "#228B22", "insightInterval" : "year", "isRoundOff": true }, "_comment": " " }, "nssWsTotalConnection "nssWsSLACompliance": { "chartName": "NSS_WS_ACTIVESLA_CONNECTIONSCOMPLIANCE", "queries": [ { "module": "WS", "dateRefField": "date", "requestQueryMap": "{\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\",\"ward\" : \"ward.keyword\"}", "indexName": "ws-national-dashboard", "aggrQuery": "{\"aggs\":{\"ConnectionsAGGR\":{\"filter\":{\"bool\":{}},\"aggsmust_not\":[{\"Countterm\":{\"sumulb.keyword\":{\"field\":pb.testing\"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\":{,\"aggs\":{\"state\":{\"terms\":{\"field\":\"state.keyword\"},\"aggs\":{\"intermediateAggrULB\":{\"terms\":{\"field\":\"ulb.keyword\"},\"aggs\":{\"intermediateAggrWard\":{\"terms\":{\"field\":\"ward.keyword\"},\"aggs\":{\"todaysDate\":{\"terms\":{\"field\":\"date\",\"order\":{\"_term\":\"desc\"},\"size\":1},\"aggs\":{\"SLACompliance\":{\"avg\":{\"field\":\"slaCompliance\"}}}},\"wardSLACompliance\":{\"avg_bucket\":{\"buckets_path\":\"todaysDate.SLACompliance\"}}}},\"ulbSLACompliance\":{\"avg_bucket\":{\"buckets_path\":\"intermediateAggrWard.wardSLACompliance\"}}}},\"stateSLACompliance\":{\"avg_bucket\":{\"buckets_path\":\"intermediateAggrULB.ulbSLACompliance\"}}}},\"SLA Compliance\":{\"avg_bucket\":{\"fieldbuckets_path\":\"slaCompliancestate.stateSLACompliance\"}}}}}}" } ], } ], "translateTenantCode": false, "chartType": "metric", "valueType": "percentage", "action": "", "drillChart": "none", "isRoundOff": true, "aggregationPaths": [ "SLA Compliance" ], "insight": { "chartResponseMap" : "nssWsSLACompliance", "action" : "differenceOfNumbers", "upwardIndicator" : "positive", "downwardIndicator" : "negative", "textMessage" : "$indicator$value% than last $insightInterval", "colorCode" : "#228B22", "insightInterval" : "year", "isRoundOff": true }, "_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", "isRoundOff": true }, "_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", "isRoundOff": true }, "_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", "isRoundOff": true }, "_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": "_docnss", "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": "" }, |
Click here to check the complete configuration
...
Code Block |
---|
{ "name": "NSS_WS_DASHBOARD", "id": "national-ws", "isActive": "", "style": "linear", "visualizations": [ { "row": 1, "name": "NSS_REVENUE", "vizArray": [ { "id": 211, "name": "NSS_NATIONAL_WS_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": "{"title": "TODAY"}", "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" } ] } ] }, { "row": 5, "name": "NSS_REVENUE", "vizArray": [ { "id": 231, "name": "NSS_WS_TAX_HEAD_BOUNDARY", "dimensions": { "height": 350, "width": 12 }, "vizType": "chart", "label": "", "noUnit": false, "isCollapsible": true, "charts": [ { "id": "nssWsTaxHeadState", "name": "NSS_WS_TAX_HEAD_BOUNDARY", "code": "", "chartType": "table", "filter": "", "headers": [], "tabName": "Boundary" } ] } ] }, { "row": 7, "name": "NSS_SERVICE", "vizArray": [ { "id": 231, "name": "NSS_NATIONAL_WS_OVERVIEW", "dimensions": { "height": 350, "width": 12 }, "vizType": "metric-collection", "label": "", "noUnit": false, "isCollapsible": true, "charts": [ { "id": "nssWsTotalApplications", "name": "NSS_WS_TOTAL_APPLICATIONS", "code": "", "chartType": "metric", "filter": "", "headers": [] }, { "id": "nssWsSLACompliance", "name": "NSS_WS_SLA_COMPLIANCE", "code": "", "chartType": "metric", "filter": "", "headers": [] }, { "id": "nssWsTotalConnection", "name": "NSS_WS_ACTIVE_CONNECTIONS", "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" } ] } ] } ] } |
...
line - this graph/chart is data representation on date histograms or date groupings.
...
Top State By Performance:
This graph represents the States based on the Target achieved in bar chart representation with the % of target achieved in descending order.
...
On click of Show More it shows the information of all the states as shown in following screenshot:
...
Bottom State by Performance:
This graph represents the States based on the target achieved in bar chart representation with the % of target achieved in ascending order.
...
...
On click of Show More it shows the information of all the states as shown in following screenshot:
...
W&S Collection by Usage Type:
...
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.
...
Attributes | Definition | Breakup |
ulb | The district or region for which the data is ingested. | Nil |
state | The ULB name for which the data is ingested. | Nil |
ward | The ward for which the data is ingested. | Nil |
transactions | Number of transactions related to WS/SW module on a given date | Nil |
connectionsCreated | Number of connections related to WS/SW module on a given date. | Breakup by: |
todaysCollection | Total collection related to WS/SW module on a given date | Breakup by: |
waterConnections | new connections created on the given date | Breakup by: |
sewerageConnections | new sewreage connections created on the given date | Breakup by: |
pendingConnections | pending connections on the given date | Breakup by: duration( |
slaCompliance | Percentage of complaints that are resolved within SLA till the given date. | Nil |
todaysTotalApplications | # of Applications created on the given date | Nil |
todaysClosedApplications | # of Applications closed on the given date | Nil |
todaysCompletedApplicationsWithinSLA | # of Applications closed on the given date within SLA | Nil |
...