Page Comparison

...

Code Block

breakoutMode	wide

  "_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\":{\"must\":[{\"range\":{\"date\":{\"gt\":\"now-1d\/d\",\"lte\":\"now\"}}}]}},\"aggs\":{\"todaysDate\":{\"terms\":{\"field\":\"date\",\"order\":{\"_term\":\"desc\"},\"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"
      ],
      "preActionTheory":{
        "Target Collection":"repsonseToDifferenceOfDates"
      },
      "insight": {
        "chartResponseMap" : "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"
      ],
      "insightpreActionTheory": {
      },       "_comment": " Top Performing Ulbs for target achieved""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\":{\"sumterms\":{\"field\":\"connectionsCreatedForConnectionTypeward.keyword\"}},\"aggs\"Ws_Total_Collection:{\"days\":{\"sumterms\":{\"field\":\"todaysCollectionForPaymentChannelTypedate\"}},\"Total_aggs\":{\"Transactions\":{\"avg\":{\"field\":\"transactions\"}}}}}}}}"
        }
      ,\"wardTransactions\":{\"sum_bucket\":{\"buckets_path\":\"days.Transactions\"}}}},\"ulbTransactions\":{\"sum_bucket\":{\"buckets_path\":\"intermediateAggrWard.wardTransactions\"}}}},\"Total_Transactions\":{\"sum_bucket\":{\"buckets_path\":\"intermediateAggrULB.ulbTransactions\"}},\"Total_Connections\":{\"sum\":{\"field\":\"connectionsCreatedForConnectionType\"}},\"Ws_Total_Collection\":{\"sum\":{\"field\":\"todaysCollectionForPaymentChannelType\"}}}}}}}}"
        }
      ],
      "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  "
        },
      ],  {
    "pathDataTypeMapping": [       "postAggregationTheory" : "",
           "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"
        },
      ],       "insight": {
  
   },       "Total_commentTransactions": "number"
   "     },
       "nssWsFinancialIndicatorTenant": {
      "chartName    "Ws_Total_Collection": "NSS_WS_DEMAND_COLLECTION_BOUNDARY",amount"
       "queries": [ },
        {
          "moduleTarget_Collection": "COMMON",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\":{\"days\":{\"terms\":{\"field\":\"date\"},\"aggs\":{\"Transactions\":{\"Total_Connectionsavg\":{\"field\":\"transactions\"}}}},\"wardTransactions\":{\"sum_bucket\":{\"buckets_path\":\"days.Transactions\"}}}},\"Total_Transactions\":{\"sum_bucket\":{\"fieldbuckets_path\":\"connectionsCreatedForConnectionTypeintermediateAggrWard.wardTransactions\"}},\"Ws_Total_CollectionConnections\":{\"sum\":{\"field\":\"todaysCollectionForPaymentChannelTypeconnectionsCreatedForConnectionType\"}},\"Ws_Total_TransactionsCollection\":{\"avgsum\":{\"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"],
  {         "newField" : "TotalTarget_TransactionsAchieved":,
"number"         },  "_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": "date",amount"
        },
       "indexName": "master-national-dashboard", {
          "aggrQueryTarget_Achieved": "{\"aggs\":{\"state \":{\"terms\":{\"field\":\"ward.keyword\",\"size\":200},\"aggs\":{\"Target_Collection\":{\"filter\":{\"term\":{\"module.keyword\":\"WS\"}},\"aggs\":{\"sum\":{\"sum\":{\"field\":\"budgetProposedForMunicipalCorporation\"}}}}}}}}"percentage"
        }
      ],
      "insight": {},
      "_comment": ""
    },
    
    "nssWsFinancialIndicatorWard": {
      "chartName": "",
        },"queries": [
        {
          "module": "WSCOMMON",
          "dateRefFieldrequestQueryMap": "{\"datestate\",           "requestQueryMap": "{\"state\" : \"state: \"state.keyword\",\"ulb\" : \"ulb.keyword\",\"ward\" : \"ward.keyword\"}",
          "dateRefField": "date",
          "indexName": "wsmaster-national-dashboard",
          "aggrQuery": "{\"aggs\":{\"AGGRstate \":{\"filter\":{\"bool\":{}},\"aggs\":{\"Ward\":{\"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",
         ],       "postAggregationTheory"dateRefField": "repsonseToDifferenceOfDatesdate",
      "chartType": "xtable",       "valueTyperequestQueryMap": "{\"numberstate\",       "drillChart": \"state.keyword\",
      "documentType"\"ulb\" : "_doc",
      "action": ""\"ulb.keyword\",\"ward\" : \"ward.keyword\"}",
      "plotLabel": "Ward",
      "aggregationPathsindexName": [         "Target_Collection"ws-national-dashboard",
        "Ws_Total_Collection",
        "Total_TransactionsaggrQuery",
        "Total_Connections"
      ],
      "computedFields": [
        {
          "postAggregationTheory" : "",
          "actionName": "PercentageComputedField",
          "fields" : ["Ws_Total_Collection","Target_Collection"],
 : "{\"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",
      "postAggregationTheory" : "",
      "aggregationPaths": [
        "Ws_Total_Collection",
        "Late_Charges",
        "Interest",
        "newFieldAdvance" :,
        "TargetCurrent_AchievedCharges",

         "Arrear_commentsCharges":
  "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"
],       "pathDataTypeMapping": [ },
        {
          "WsLate_Total_CollectionCharges": "amount"
        },
        {
          "Total_TransactionsInterest": "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\"}}}}}}}}"
        }
      ],
      "translateTenantCodeisMdmsEnabled": false,
      "isMdmsEnabledtranslateTenantCode": false,
      "filterKeys": [
 
      {"key": "ulb", "column": "ULB"}
      ],
      "chartType": "table",
      "valueType": "amount",
      "drillChart": "nssWsTaxHeadWardnone",
      "action": "",
      "plotLabel": "ULBWard",
      "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_comment": {
      "chartName": "",
      "queries": [
        {
    "National Dashboard-WS- Service Tab- all cards configs start here",

    "modulenssWsTotalApplications": "WS",{
          "dateRefFieldchartName": "dateNSS_WS_TOTAL_APPLICATIONS",
          "requestQueryMapqueries": "{\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\",\"ward\" : \"ward.keyword\"}",[
          {
     "indexName": "ws-national-dashboard",           "aggrQuerymodule": "{\"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\""WS",
            "dateRefField": "date",
            "requestQueryMap": "{\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\",\"ward\" : \"ward.keyword\"}",
            "indexName": "ws-national-dashboard",
            "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"termsbool\":{\"taxHeads.keyword\":[\"ARREAR.CHARGES\"]}},\"aggs\":{\"amountstate\":{\"sumterms\":{\"field\":\"todaysCollectionForTaxHeadsstate.keyword\"}}}},\"Advanceaggs\":{\"filterintermediateAggrULB\":{\"terms\":{\"taxHeads.keywordfield\":[\"ADVANCE\"ulb.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",\"ulbApplications\":{\"sum_bucket\":{\"buckets_path\":\"intermediateAggrWard.wardapplications\"}}}},\"stateApplications\":{\"sum_bucket\":{\"buckets_path\":\"intermediateAggrULB.ulbApplications\"}}}},\"Total Applications\":{\"sum_bucket\":{\"buckets_path\":\"state.stateApplications\"}}}}}}"
          }
        ],
        "InteresttranslateTenantCode",
      "Advance": false,
        "Current_Charges",
        "Arrear_Charges"chartType": "metric",
         ],
      "pathDataTypeMapping"valueType": [
 "number",
      {           "Ws_Total_Collection"action": "amount"
        },
  
     {           "Late_Charges"drillChart": "amount"
        }none",
        {"aggregationPaths": [
         "Interest": "amountTotal Applications"
        }],
        "insight": {
          "AdvancechartResponseMap" : "amountnssWsTotalApplications",
        },  "action"    : "differenceOfNumbers",
  {           "Current_Charges""upwardIndicator" : "amountpositive",
        },  "downwardIndicator" : "negative",
    {      "textMessage" : "$indicator$value% than last $insightInterval"Arrear_Charges": "amount",
         } "colorCode" : "#228B22",
   ],       "insightinsightInterval" : {"year",
       },   "isRoundOff": true
  "_comment": ""     },
        "_comment": "National Dashboard-WS-"
Service Tab- all cards configs start here"},
     "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\":{\"field\":\"date\"},\"     "aggrQuery": "{\"aggs\":{\"applicationsConnections\":{\"avgfilter\":{\"fieldbool\":{}},\"todaysTotalApplicationsaggs\"}}}},:{\"Total ApplicationsCount\":{\"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": " "
    },
    
    "nssWsTotalConnectionnssWsSLACompliance": {
      "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\":\"connectionsCreatedForConnectionTypepb.testing\"}}}}}}"
      }
      ],
      "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": "nss",
        "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: 1.) channel type(`Counter`, `ONLINE`, `CSC`, `SYSTEM`) and 2.) connection type(`WATER.METERED`, `WATER.NONMETERED`, `SEWERAGE`) has to be provided
todaysCollection	Total collection related to WS/SW module on a given date	Breakup by: 1.)usage type(`Domestic`, channel type and tax head `Commercial`, `Institutional`, `Domestic SLC`, `Domestic Exempted`,`Commercial Motor`,etc), 2.)payment channel type(`System`, `Paytm`, `Field`, `RazorPay`, `PayU`, `BBPS`, `POS`, `Sewakendra`, `Freecharge`), 3.) tax head(`INTEREST`,`LATE.CHARGES`, `ADVANCE`, `CURRENT.CHARGES`, `ARREAR.CHARGES`), and 4.) connection type(`WATER.METERED`, `WATER.NONMETERED`, `SEWERAGE`) has to be provided
waterConnections	new connections created on the given date	Breakup by: 1.) meter type(`METERED`, `NON.METERED`), 2.) usage(`Domestic`, `Commercial`, `Residential`, `Institutional`, `Domestic Exempted`) and 3.) channel(`Counter`, `ONLINE`, `CSC`, `SYSTEM`)
sewerageConnections	new sewreage connections created on the given date	Breakup by: 1.) usage(`Domestic`, `Commercial`, `Residential`, `Institutional`, `Domestic Exempted`) and 2.) channel(`ONLINE`, `CSC`, `SYSTEM`)
pendingConnections	pending connections on the given date	Breakup by: duration(`0to3Days`, `3to7Days`, `7to15Days`, `MoreThan15Days`)
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

...

Versions Compared

Old Version 9

New Version Current

Key

Bottom State by Performance:

Attributes

Definition

Breakup