Page Comparison

...

Analytics Configurations:
Analytics contains multiple configurations. we need to add the changes related to National-Dashboard in this dashboard-analytics.
Here is the location : https://github.com/egovernments/configs/tree/qa/egov-dss-dashboards/dashboard-analytics
Below is a list of configurations that need to be changed to run National-Dashboard successfully.

Chart API Configuration
Master Dashboard Configuration
Role Dashboard Mappings Configuration

Description :

Chart API Configuration :

...

Here is the sample ChartApiConfiguration.json data for the Property Tax.

Code Block

 "_comment": "NSS-PROPERTYTAX",
   
 	"todaysCollectionv3": {
    "chartName": "NATIONAL_DSS_TODAYS_COLLECTION",
    "queries": [
      {
        "module": "PT",
        "dateRefField": "date",
        "requestQueryMap": "{\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\"}",
        "indexName": "pt-national-dashboard",
        "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{}},\"aggs\":{\"todaysDate\":{\"terms\":{\"field\":\"date\",\"order\":{\"_term\":\"desc\"},\"size\":1},\"aggs\":{\"Todays Collection\":{\"sum\":{\"field\":\"todaysCollectionForUsageCategory\"}}}},\"lastUpdatedTime\":{\"terms\":{\"field\":\"lastModifiedTime\",\"order\":{\"_term\":\"desc\"},\"size\":1}}}}}}"
      }
    ],
    "chartType": "metric",
    "valueType": "Amount",
    "drillChart": "none",
    "documentType": "_doc",
    "action": "",
    "TodaysCollection":true,
    "aggregationPaths": [
      "Todays Collection"
    ],
    "insight": {
      "chartResponseMap"
: "todaysCollectionv3",
      "action" : "differenceOfNumbers",
      "upwardIndicator" : "positive",
      "downwardIndicator" : "negative",
      "textMessage" : "$indicator$value% than last $insightInterval",
      "colorCode" : "#228B22",
      "insightInterval" : "year",
      "isRoundOff": true
    },
    "_comment": " "
  },
 	
 	"totalCollectionv3": {
    "chartName": "NATIONAL_DSS_TOTAL_COLLECTION",
    "queries": [
      {
        "module": "PT",
        "dateRefField": "date",
        "requestQueryMap": "{\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\"}",
        "indexName": "pt-national-dashboard",
        "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{}},\"aggs\":{\"Total Collection\":{\"sum\":{\"field\":\"todaysCollectionForUsageCategory\"}}}}}}"
      }
    ],
    "chartType": "metric",
    "valueType": "Amount",
    "drillChart": "none",
    "documentType": "_doc",
    "action": "",
    "aggregationPaths": [
      "Total Collection"
    ],
    "insight": {
      "chartResponseMap" : "totalCollectionv3",
      "action" : "differenceOfNumbers",
      "upwardIndicator" : "positive",
      "downwardIndicator" : "negative",
      "textMessage" : "$indicator$value% than last $insightInterval",
      "colorCode" : "#228B22",
      "insightInterval" : "year",
      "isRoundOff": true
    },
    "_comment": " "
  },
 	
 	"targetCollectionv3": {
    "chartName": "NATIONAL_DSS_TARGET_COLLECTION",
    "queries": [
      {
        "module": "MASTER",
        "requestQueryMap": "{\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\"}",
        "dateRefField": "date",
        "indexName": "master-national-dashboard",
        "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must\":[{\"term\":{\"module.keyword\":\"PT\"}}]}},\"aggs\":{\"Target Collection\":{\"sum\":{\"field\":\"budgetProposedForMunicipalCorporation\"}}}}}}"
      }
    ],
    "chartType": "metric",
    "valueType": "amount",
    "action": "",
    "drillChart": "none",
    "documentType": "_doc",
    "aggregationPaths": [
      "Target Collection"
    ],
    "isDayUnit": true,
    "postAggregationTheory" : "repsonseToDifferenceOfDates",
    "insight": {
      "chartResponseMap" : "targetCollectionv3",
      "action" : "differenceOfNumbers",
      "upwardIndicator" : "positive",
      "downwardIndicator" : "negative",
      "textMessage" : "$indicator$value% than last $insightInterval",
      "colorCode" : "#228B22",
      "insightInterval" : "year",
      "isRoundOff": true
    },
    "_comment": " "
  },
  	
  	"targetAchievedv3": {
    "chartName": "NATIONAL_DSS_TARGET_ACHIEVED",
    "queries": [
      {
        "module": "MASTER",
        "requestQueryMap": "{\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\"}",
        "dateRefField": "date",
        "indexName": "master-national-dashboard",
        "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must\":[{\"term\":{\"module.keyword\":\"PT\"}}]}},\"aggs\":{\"Actual collection\":{\"sum\":{\"field\":\"budgetProposedForMunicipalCorporation\"}}}}}}"
      },
      {
        "module": "PT",
        "dateRefField": "date",
        "requestQueryMap": "{\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\"}",
        "indexName": "pt-national-dashboard",
        "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{}},\"aggs\":{\"Total Collection\":{\"sum\":{\"field\":\"todaysCollectionForUsageCategory\"}}}}}}"
      }

    ],
    "chartType": "metric",
    "valueType": "percentage",
    "drillChart": "none",
    "documentType": "_doc",
    "action": "percentage",
    "isRoundOff": true,
    "preActionTheory":{
      "Actual collection":"repsonseToDifferenceOfDates"
    },
    "aggregationPaths": [
      "Total Collection",
      "Actual collection"
    ],
    "insight": {
      "chartResponseMap" : "targetAchievedv3",
      "action" : "differenceOfNumbers",
      "upwardIndicator" : "positive",
      "downwardIndicator" : "negative",
      "textMessage" : "$indicator$value% than last $insightInterval",
      "colorCode" : "#228B22",
      "insightInterval" : "year",
      "isRoundOff": true
    },
    "_comment": " "
  },
  
  	"cumulativeCollectionv3": {
    "chartName": "NATIONAL_DSS_TOTAL_CUMULATIVE_COLLECTION",
    "queries": [
      {
        "module": "PT",
        "dateRefField": "date",
        "requestQueryMap": "{\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\"}",
        "indexName": "pt-national-dashboard",
        "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{}},\"aggs\":{\"Collections\":{\"date_histogram\":{\"field\":\"date\",\"interval\":\"intervalvalue\"},\"aggs\":{\"Sum\":{\"sum\":{\"field\":\"todaysCollectionForUsageCategory\"}}}}}}}}"
      }
    ],
    "chartType": "line",
    "valueType": "amount",
    "action": "",
    "drillChart": "none",
    "documentType": "_doc",
    "aggregationPaths": [
      "Collections"
    ],
    "isCumulative": true,
    "interval": "month",
    "insight": {
    },
    "_comment": " "
  },
	
	"topPerformingStatesv3": {
    "chartName": "NATIONAL_DSS_PT_TOP_3_PERFORMING_STATES_TARGET_ACHIEVEMENT",
    "queries": [
      {
        "module": "MASTER",
        "requestQueryMap": "{\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\"}",
        "dateRefField": "date",
        "indexName": "master-national-dashboard",
        "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must\":[{\"term\":{\"module.keyword\":\"PT\"}}]}},\"aggs\":{\"Target Collection\":{\"terms\":{\"field\":\"state.keyword\",\"size\":\"200\",\"order\":{\"Sum\":\"desc\"}},\"aggs\":{\"Sum\":{\"sum\":{\"field\":\"budgetProposedForMunicipalCorporation\"}}}}}}}}"
      },
      {
        "module": "PT",
        "requestQueryMap": "{\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\"}",
        "dateRefField": "date",
        "indexName": "pt-national-dashboard",
        "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{}},\"aggs\":{\"Total Collection\":{\"terms\":{\"field\":\"state.keyword\",\"size\":\"200\",\"order\":{\"Sum\":\"desc\"}},\"aggs\":{\"Sum\":{\"sum\":{\"field\":\"todaysCollectionForUsageCategory\"}}}}}}}}"
      }
    ],
    "chartType": "perform",
    "valueType": "percentage",
    "drillChart": "none",
    "documentType": "_doc",
    "action": "percentage",
    "plotLabel": "NATIONAL_DSS_TARGET_ACHIEVED",
    "order": "desc",
    "limit": 3,
    "isRoundOff": true,
    "aggregationPaths": [
      "Total Collection","Target Collection"
    ],
    "preActionTheory":{
      "Target Collection":"repsonseToDifferenceOfDates"
    },		
    "insight": {
    },
    "_comment": " Top Performing Ulbs for target achieved"
  },
	
	"bottomPerformingStatesv3": {
    "chartName": "NATIONAL_DSS_PT_BOTTOM_3_PERFORMING_STATES_TARGET_ACHIEVEMENT",
    "queries": [
      {
        "module": "MASTER",
        "requestQueryMap": "{\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\"}",
        "dateRefField": "date",
        "indexName": "master-national-dashboard",
        "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must\":[{\"term\":{\"module.keyword\":\"PT\"}}]}},\"aggs\":{\"Target Collection\":{\"terms\":{\"field\":\"state.keyword\",\"size\":\"200\",\"order\":{\"Sum\":\"asc\"}},\"aggs\":{\"Sum\":{\"sum\":{\"field\":\"budgetProposedForMunicipalCorporation\"}}}}}}}}"
      },
      {
        "module": "PT",
       "requestQueryMap": "{\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\"}",
        "dateRefField": "date",
        "indexName": "pt-national-dashboard",
        "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{}},\"aggs\":{\"Total Collection\":{\"terms\":{\"field\":\"state.keyword\",\"size\":\"200\",\"order\":{\"Sum\":\"asc\"}},\"aggs\":{\"Sum\":{\"sum\":{\"field\":\"todaysCollectionForUsageCategory\"}}}}}}}}"
      }
    ],
    "chartType": "perform",
    "valueType": "percentage",
    "drillChart": "none",
    "documentType": "_doc",
    "action": "percentage",
    "plotLabel": "NATIONAL_DSS_TARGET_ACHIEVED",
    "order": "asc",
    "limit": 3,
    "isRoundOff": true,
    "aggregationPaths": [
      "Total Collection", "Target Collection"
    ],
    "insightpreActionTheory": {
    },     "_comment": " Bottom Performing Ulbs for target "Target Collection":"repsonseToDifferenceOfDates"
    },	
    "insight": {
    },
    "_comment": " Bottom Performing Ulbs for target achieved"
  },
	
	"collectionByUsageTypev3": {
    "chartName": "NATIONAL_DSS_PT_COLLECTION_BY_USAGE_TYPE",
    "queries": [
      {
        "module": "PT",
        "requestQueryMap": "{\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\"}",
        "dateRefField": "date",
        "indexName": "pt-national-dashboard",
        "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{}},\"aggs\":{\"Usage Type\":{\"terms\":{\"field\":\"usageCategory.keyword\",\"size\":200},\"aggs\":{\"Amount Paid\":{\"sum\":{\"field\":\"todaysCollectionForUsageCategory\"}}}}}}}}"
      }
    ],
    "chartType": "pie",
    "valueType": "amount",
    "action": "",
    "documentType": "_doc",
    "drillChart": "none",
    "aggregationPaths": [
      "Usage Type"
    ],
    "insight": {
    },
    "_comment": " collection/amount per usage type"
  },

	"demandCollectionIndexStatesRevenuev3": {
    "chartName": "NATIONAL_DSS_PT_KEY_FY_INDICATORS",
    "queries": [
      {
        "module": "PT",
        "requestQueryMap": "{\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\"}",
        "dateRefField": "date",
        "indexName": "pt-national-dashboard",
        "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{}},\"aggs\":{\"state \":{\"terms\":{\"field\":\"state.keyword\",\"size\":200},\"aggs\":{\"PT_Total_Collection\":{\"sum\":{\"field\":\"todaysCollectionForUsageCategory\"}},\"PT_Transactions\":{\"sum\":{\"field\":\"transactionsForUsageCategory\"}},\"PT_Assessed_Properties\":{\"sum\":{\"field\":\"assessedPropertiesForUsageCategory\"}}}}}}}}"
      },
      {
        "module": "MASTER",
       "requestQueryMap": "{\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\"}",
        "dateRefField": "date",
        "indexName": "master-national-dashboard",
        "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{}},\"aggs\":{\"state \":{\"terms\":{\"field\":\"state.keyword\",\"size\":200},\"aggs\":{\"PT_Target_Collection\":{\"filter\":{\"term\":{\"module.keyword\":\"PT\"}},\"aggs\":{\"sum\":{\"sum\":{\"field\":\"budgetProposedForMunicipalCorporation\"}}}}}}}}}}"
      }
    ],
    "isMdmsEnabled": false,
    "filterKeys": [
      {"key": "state", "column": "State"}
    ],
    "chartType": "xtable",
    "valueType": "number",
    "drillChart": "demandCollectionIndexUlbRevenuev3",
    "action": "",
    "plotLabel": "State",
    "isPostResponseHandler": true,
    "postAggregationTheory" : "repsonseToDifferenceOfDates",
    "aggregationPaths": [
      "PT_Total_Collection",
      "PT_Transactions",
      "PT_Assessed_Properties",
      "PT_Target_Collection"
    ],
     "computedFields": [
      {
        "postAggregationTheory" : "repsonseToDifferenceOfDates",
        "actionName": "AdditiveComputedField",
        "fields" : ["PT_Target_Collection"],
        "newField" : "Target_Collection_PT",
        "_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" : ["PT_Total_Collection","Target_Collection_PT"],
        "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":["PT_Target_Collection"],
    "pathDataTypeMapping": [
      {
        "PT_Total_Collection": "amount"
      },
      {
        "PT_Transactions": "number"
      },
      {
        "PT_Assessed_Properties": "number"
      },
      {
        "PT_Target_Collection": "amount"
      },
      {
      	"Target Achieved" : "percentage"
      },
      {
         "Target_Collection_PT": "amount"
      }
    ],
    "insight": {
    },
    "_comment": ""
  },
	
	"demandCollectionIndexUlbRevenuev3": {
    "chartName": "NATIONAL_DSS_PT_DEMAND_COLLECTION_ULB",
    "queries": [
       {
        "module": "PT",
        "requestQueryMap": "{\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\"}",
        "dateRefField": "date",
        "indexName": "pt-national-dashboard",
        "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{}},\"aggs\":{\"ulb \":{\"terms\":{\"field\":\"ulb.keyword\",\"size\":200},\"aggs\":{\"PT_Total_Collection\":{\"sum\":{\"field\":\"todaysCollectionForUsageCategory\"}},\"PT_Transactions\":{\"sum\":{\"field\":\"transactionsForUsageCategory\"}},\"PT_Assessed_Properties\":{\"sum\":{\"field\":\"assessedPropertiesForUsageCategory\"}}}}}}}}"
      },
      {
        "module": "MASTER",
       "requestQueryMap": "{\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\"}",
        "dateRefField": "date",
        "indexName": "master-national-dashboard",
        "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{}},\"aggs\":{\"ulb \":{\"terms\":{\"field\":\"ulb.keyword\",\"size\":200},\"aggs\":{\"PT_Target_Collection\":{\"filter\":{\"term\":{\"module.keyword\":\"PT\"}},\"aggs\":{\"sum\":{\"sum\":{\"field\":\"budgetProposedForMunicipalCorporation\"}}}}}}}}}}"
      }
    ],
    "filterKeys": [
      {"key": "ulb", "column": "Ulb"}
    ],
    "postAggregationTheory" : "repsonseToDifferenceOfDates",    
    "chartType": "xtable",
    "valueType": "number",
    "drillChart": "demandCollectionIndexWardRevenuev3",
    "drillFields": [
      "ward",
      ""
    ],
    "documentType": "_doc",
    "action": "",
    "plotLabel": "Ulb",
    "aggregationPaths": [ 
      "PT_Total_Collection",
      "PT_Transactions",
      "PT_Assessed_Properties",
      "PT_Target_Collection"
    ],
     "computedFields": [
      {
        "postAggregationTheory" : "repsonseToDifferenceOfDates",
        "actionName": "AdditiveComputedField",
        "fields" : ["PT_Target_Collection"],
        "newField" : "Target_Collection_PT",
        "_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" : ["PT_Total_Collection","Target_Collection_PT"],
        "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":["PT_Target_Collection"],
    "pathDataTypeMapping": [
      {
        "PT_Total_Collection": "amount"
      },
      {
        "PT_Transactions": "number"
      },
      {
        "PT_Assessed_Properties": "number"
      },
      {
        "PT_Target_Collection": "amount"
      },
      {
      	"Target Achieved" : "percentage"
      },
      {
      	"Target_Collection_PT" : "amount"
      }
    ],
    "insight": {
    },
    "_comment": ""
  },
  	
  	"demandCollectionIndexWardRevenuev3": {
    "chartName": "NATIONAL_DSS_PT_DEMAND_COLLECTION_WARD",
    "queries": [
       {
        "module": "PT",
        "requestQueryMap": "{\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\", \"ward\" : \"ward.keyword\"}",
        "dateRefField": "date",
        "indexName": "pt-national-dashboard",
        "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{}},\"aggs\":{\"ward \":{\"terms\":{\"field\":\"ward.keyword\",\"size\":200},\"aggs\":{\"PT_Total_Collection\":{\"sum\":{\"field\":\"todaysCollectionForUsageCategory\"}},\"PT_Transactions\":{\"sum\":{\"field\":\"transactionsForUsageCategory\"}},\"PT_Assessed_Properties\":{\"sum\":{\"field\":\"assessedPropertiesForUsageCategory\"}}}}}}}}"
      },
      {
        "module": "MASTER",
       "requestQueryMap": "{\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\", \"ward\" : \"ward.keyword\"}",
        "dateRefField": "date",
        "indexName": "master-national-dashboard",
        "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{}},\"aggs\":{\"ward \":{\"terms\":{\"field\":\"ward.keyword\",\"size\":200},\"aggs\":{\"PT_Target_Collection\":{\"filter\":{\"term\":{\"module.keyword\":\"PT\"}},\"aggs\":{\"sum\":{\"sum\":{\"field\":\"budgetProposedForMunicipalCorporation\"}}}}}}}}}}"
      }
    ],
    "filterKeys": [
    ],
    "postAggregationTheory" : "repsonseToDifferenceOfDates",    
    "chartType": "xtable",
    "valueType": "number",
    "drillChart": "",
    "documentType": "_doc",
    "action": "",
    "plotLabel": "Ward",
    "aggregationPaths": [
      "PT_Total_Collection",
      "PT_Transactions",
      "PT_Assessed_Properties",
      "PT_Target_Collection"
    ],
     "computedFields": [
      {
        "postAggregationTheory" : "repsonseToDifferenceOfDates",
        "actionName": "AdditiveComputedField",
        "fields" : ["PT_Target_Collection"],
        "newField" : "Target_Collection_PT",
        "_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" : ["PT_Total_Collection","Target_Collection_PT"],
        "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":["PT_Target_Collection"],
    "pathDataTypeMapping": [
      {
        "PT_Total_Collection": "amount"
      },
      {
        "PT_Transactions": "number"
      },
      {
        "PT_Assessed_Properties": "number"
      },
      {
        "PT_Target_Collection": "amount"
      },
      {
      	"Target Achieved" : "percentage"
      },
      {
        "Target_Collection_PT": "amount"
      }
    ],
    "insight": {
    },
    "_comment": ""
  },
  
	"demandCollectionIndexUsageRevenuev3": {
    "chartName": "NATIONAL_DSS_PT_DEMAND_COLLECTION_USAGETYPE",
    "queries": [
      {
        "module": "PT",
        "requestQueryMap": "{\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\"}",
        "dateRefField": "date",
        "indexName": "pt-national-dashboard",
        "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{}},\"aggs\":{\"UsageType \":{\"terms\":{\"field\":\"usageCategory.keyword\",\"size\":200},\"aggs\":{\"PT_Total_Collection\":{\"filter\":{\"term\":{\"module.keyword\":\"PT\"}},\"aggs\":{\"top_tags_per_comment\":{\"sum\":{\"field\":\"todaysCollectionForUsageCategory\"}}}},\"PT_Transactions\":{\"filter\":{\"term\":{\"module.keyword\":\"PT\"}},\"aggs\":{\"txn\":{\"sum\":{\"field\":\"transactionsForUsageCategory\"}}}},\"PT_Assessed_Properties\":{\"filter\":{\"term\":{\"module.keyword\":\"PT\"}},\"aggs\":{\"assessedProperties\":{\"sum\":{\"field\":\"assessedPropertiesForUsageCategory\"}}}}}}}}}}"
      }
    ],
    "filterKeys": [

    ],
    "chartType": "table",
    "valueType": "number",
    "drillChart": "",
    "drillFields": [
      "ward",
      ""
    ],
    "documentType": "_doc",
    "action": "",
    "plotLabel": "Usage Type",
    "aggregationPaths": [
      "PT_Total_Collection",
      "PT_Transactions",
      "PT_Assessed_Properties"

    ],
    "pathDataTypeMapping": [
      {
        "PT_Total_Collection": "amount"
      },
      {
        "PT_Transactions": "number"
      },
      {
        "PT_Assessed_Properties": "number"
      }
    ],
    "insight": {
    },
    "_comment": ""
  },
  	
  	"taxHeadsBreakupStatesRevenuev3": {
    "chartName": "NATIONAL_DSS_PT_TAX_HEAD_BREAKUP_REVENUE_STATES",
    "queries": [
      {
        "module": "PT",
        "requestQueryMap": "{\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\"}",
        "dateRefField": "date",
      	"indexName": "pt-national-dashboard",
        "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{}},\"aggs\":{\"State \":{\"terms\":{\"field\":\"state.keyword\",\"size\":200},\"aggs\":{\"PT_Total_Amount\":{\"sum\":{\"field\":\"todaysCollectionForUsageCategory\"}},\"PT_Tax\":{\"filter\":{\"term\":{\"module.keyword\":\"PT\"}},\"aggs\":{\"amount\":{\"sum\":{\"field\":\"propertyTaxForUsageCategory\"}}}},\"PT_Cess\":{\"filter\":{\"term\":{\"module.keyword\":\"PT\"}},\"aggs\":{\"amount\":{\"sum\":{\"field\":\"cessForUsageCategory\"}}}},\"PT_Rebate\":{\"filter\":{\"term\":{\"module.keyword\":\"PT\"}},\"aggs\":{\"amount\":{\"sum\":{\"field\":\"rebateForUsageCategory\"}}}},\"PT_Penalty\":{\"filter\":{\"term\":{\"module.keyword\":\"PT\"}},\"aggs\":{\"amount\":{\"sum\":{\"field\":\"penaltyForUsageCategory\"}}}},\"PT_Interest\":{\"filter\":{\"term\":{\"module.keyword\":\"PT\"}},\"aggs\":{\"amount\":{\"sum\":{\"field\":\"interestForUsageCategory\"}}}}}}}}}}"

      }
    ],
    "isMdmsEnabled": false,
    "filterKeys": [
      {"key": "state", "column": "State"}

    ],
    "chartType": "xtable",
    "valueType": "number",
    "drillChart": "taxHeadsBreakupUlbRevenuev3",
    "isPostResponseHandler": true,
    "documentType": "_doc",
    "action": "",
    "plotLabel": "State",
    "aggregationPaths": [
      "PT_Tax",
      "PT_Cess",
      "PT_Rebate",
      "PT_Penalty",
      "PT_Interest"
    ],
    "computedFields": [
      {
        "postAggregationTheory" : "",
        "actionName": "AdditiveComputedField",
        "fields" : [ "PT_Tax", "PT_Cess", "PT_Rebate", "PT_Penalty", "PT_Interest"],
        "newField" : "PT_Total_Amount",
        "_comments": "fields are field names picked from its aggregation query to use post aggregation newField value with given new field name  "
      }
    ],
    "pathDataTypeMapping": [
      {
        "PT_Total_Amount": "amount"
      },
      {
        "PT_Tax": "amount"
      },
      {
        "PT_Cess": "amount"
      },
      {
        "PT_Rebate": "amount"
      },
      {
        "PT_Penalty": "amount"
      },
      {
        "PT_Interest": "amount"
      }
    ],
    "insight": {
    },
    "_comment": ""
  },

	"taxHeadsBreakupUlbRevenuev3": {
    "chartName": "NATIONAL_DSS_PT_TAX_HEAD_BREAKUP_REVENUE_ULB",
    "queries": [
      {
        "module": "PT",
        "requestQueryMap": "{\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\"}",
        "dateRefField": "date",
        "indexName": "pt-national-dashboard",
        "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{}},\"aggs\":{\"State \":{\"terms\":{\"field\":\"ulb.keyword\",\"size\":200},\"aggs\":{\"PT_Total_Amount\":{\"sum\":{\"field\":\"todaysCollectionForUsageCategory\"}},\"PT_Tax\":{\"filter\":{\"term\":{\"module.keyword\":\"PT\"}},\"aggs\":{\"amount\":{\"sum\":{\"field\":\"propertyTaxForUsageCategory\"}}}},\"PT_Cess\":{\"filter\":{\"term\":{\"module.keyword\":\"PT\"}},\"aggs\":{\"amount\":{\"sum\":{\"field\":\"cessForUsageCategory\"}}}},\"PT_Rebate\":{\"filter\":{\"term\":{\"module.keyword\":\"PT\"}},\"aggs\":{\"amount\":{\"sum\":{\"field\":\"rebateForUsageCategory\"}}}},\"PT_Penalty\":{\"filter\":{\"term\":{\"module.keyword\":\"PT\"}},\"aggs\":{\"amount\":{\"sum\":{\"field\":\"penaltyForUsageCategory\"}}}},\"PT_Interest\":{\"filter\":{\"term\":{\"module.keyword\":\"PT\"}},\"aggs\":{\"amount\":{\"sum\":{\"field\":\"interestForUsageCategory\"}}}}}}}}}}"
      }
    ],
    "filterKeys": [
      {"key": "ulb", "column": "Ulb"}

    ],
    "chartType": "xtable",
    "valueType": "number",
    "drillChart": "taxHeadsBreakupWardRevenuev3",
    "drillFields": [
      "ward",
      ""
    ],
    "documentType": "_doc",
    "action": "",
    "plotLabel": "Ulb",
    "aggregationPaths": [
      "PT_Tax",
      "PT_Cess",
      "PT_Rebate",
      "PT_Penalty",
      "PT_Interest"
    ],
	 "computedFields": [
      {
        "postAggregationTheory" : "",
        "actionName": "AdditiveComputedField",
        "fields" : ["PT_Tax", "PT_Cess", "PT_Rebate", "PT_Penalty", "PT_Interest"],
        "newField" : "PT_Total_Amount",
        "_comments": "fields are field names picked from its aggregation query to use post aggregation newField value with given new field name  "
      }
    ],
    "pathDataTypeMapping": [
      {
        "PT_Total_Amount": "amount"
      },
      {
        "PT_Tax": "amount"
      },
      {
        "PT_Cess": "amount"
      },
      {
        "PT_Rebate": "amount"
      },
      {
        "PT_Penalty": "amount"
      },
      {
        "PT_Interest": "amount"
      }
    ],
    "insight": {
    },
    "_comment": ""
  },
	
	"taxHeadsBreakupWardRevenuev3": {
    "chartName": "National Tax head Breakup Ward",
    "queries": [
      {
      	"module": "PT",
        "requestQueryMap": "{\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\"}",
        "dateRefField": "date",
        "indexName": "pt-national-dashboard",
        "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{}},\"aggs\":{\"State \":{\"terms\":{\"field\":\"ward.keyword\",\"size\":200},\"aggs\":{\"PT_Total_Amount\":{\"sum\":{\"field\":\"todaysCollectionForUsageCategory\"}},\"PT_Tax\":{\"filter\":{\"term\":{\"module.keyword\":\"PT\"}},\"aggs\":{\"amount\":{\"sum\":{\"field\":\"propertyTaxForUsageCategory\"}}}},\"PT_Cess\":{\"filter\":{\"term\":{\"module.keyword\":\"PT\"}},\"aggs\":{\"amount\":{\"sum\":{\"field\":\"cessForUsageCategory\"}}}},\"PT_Rebate\":{\"filter\":{\"term\":{\"module.keyword\":\"PT\"}},\"aggs\":{\"amount\":{\"sum\":{\"field\":\"rebateForUsageCategory\"}}}},\"PT_Penalty\":{\"filter\":{\"term\":{\"module.keyword\":\"PT\"}},\"aggs\":{\"amount\":{\"sum\":{\"field\":\"penaltyForUsageCategory\"}}}},\"PT_Interest\":{\"filter\":{\"term\":{\"module.keyword\":\"PT\"}},\"aggs\":{\"amount\":{\"sum\":{\"field\":\"interestForUsageCategory\"}}}}}}}}}}"
      }
    ],
    "filterKeys": [

    ],
    "chartType": "xtable",
    "valueType": "number",
    "drillChart": "",
    "drillFields": [
      "ward",
      ""
    ],
    "documentType": "_doc",
    "action": "",
    "plotLabel": "Ward",
    "aggregationPaths": [
      "PT_Tax",
      "PT_Cess",
      "PT_Rebate",
      "PT_Penalty",
      "PT_Interest"
    ],
	 "computedFields": [
      {
        "postAggregationTheory" : "",
        "actionName": "AdditiveComputedField",
        "fields" : [ "PT_Tax", "PT_Cess", "PT_Rebate", "PT_Penalty", "PT_Interest"],
        "newField" : "PT_Total_Amount",
        "_comments": "fields are field names picked from its aggregation query to use post aggregation newField value with given new field name  "
      }
    ],
    "pathDataTypeMapping": [
      {
        "PT_Total_Amount": "amount"
      },
      {
        "PT_Tax": "amount"
      },
      {
        "PT_Cess": "amount"
      },
      {
        "PT_Rebate": "amount"
      },
      {
        "PT_Penalty": "amount"
      },
      {
        "PT_Interest": "amount"
      }
    ],
    "insight": {
    },
    "_comment": ""
  },

 	"taxHeadsBreakupUsagev3": {
    "chartName": "NATIONAL_DSS_PT_TAX_HEAD_BREAKUP_USAGE",
    "queries": [
      {
        "module": "PT",
       	"requestQueryMap": "{\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\"}",
        "dateRefField": "date",
        "indexName": "pt-national-dashboard",
        "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{}},\"aggs\":{\"usage \":{\"terms\":{\"field\":\"usageCategory.keyword\",\"size\":200},\"aggs\":{\"PT_Total_Amount\":{\"sum\":{\"field\":\"todaysCollectionForUsageCategory\"}},\"PT_Tax\":{\"filter\":{\"term\":{\"module.keyword\":\"PT\"}},\"aggs\":{\"amount\":{\"sum\":{\"field\":\"propertyTaxForUsageCategory\"}}}},\"PT_Cess\":{\"filter\":{\"term\":{\"module.keyword\":\"PT\"}},\"aggs\":{\"amount\":{\"sum\":{\"field\":\"cessForUsageCategory\"}}}},\"PT_Rebate\":{\"filter\":{\"term\":{\"module.keyword\":\"PT\"}},\"aggs\":{\"amount\":{\"sum\":{\"field\":\"rebateForUsageCategory\"}}}},\"PT_Penalty\":{\"filter\":{\"term\":{\"module.keyword\":\"PT\"}},\"aggs\":{\"amount\":{\"sum\":{\"field\":\"penaltyForUsageCategory\"}}}},\"PT_Interest\":{\"filter\":{\"term\":{\"module.keyword\":\"PT\"}},\"aggs\":{\"amount\":{\"sum\":{\"field\":\"interestForUsageCategory\"}}}}}}}}}}"
      }
    ],
    "filterKeys": [

    ],
    "chartType": "table",
    "valueType": "number",
    "drillChart": "",
    "documentType": "_doc",
    "action": "",
    "plotLabel": "Usage Type",
    "aggregationPaths": [
      "PT_Total_Amount",
      "PT_Tax",
      "PT_Cess",
      "PT_Rebate",
      "PT_Penalty",
      "PT_Interest"
    ],
    "pathDataTypeMapping": [
      {
        "PT_Total_Amount": "amount"
      },
      {
        "PT_Tax": "amount"
      },
      {
        "PT_Cess": "amount"
      },
      {
        "PT_Rebate": "amount"
      },
      {
        "PT_Penalty": "amount"
      },
      {
        "PT_Interest": "amount"
      }
    ],
    "insight": {
    },
    "_comment": ""
  },
	     
    "totalPropertiesv3totalApplicationsv3": {
    "chartName": "NATIONAL_DSS_PT_TOTAL_PROPERTIESAPPLICATIONS",
    "queries": [
      {
        "module": "PT",
        "indexName": "pt-national-dashboard",
        "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{}},\"aggs\":{\"Total Applicationstate\":{\"sumterms\":{\"field\":\"propertiesRegisteredForFinancialYearstate.keyword\"}}}}}}",
        "requestQueryMap": ",\"aggs\":{\"stateintermediateAggrULB\" : {\"state.keywordterms\",:{\"ulbfield\" : \"ulb.keyword\"}",
        "dateRefField": "date"
      }
    ],
    "chartType": "metric",
    "valueType": "number",
    "action": "",
    "documentType": "_doc",
    "drillChart": "none",
    "aggregationPaths": [
      "Total Application"
    ],
    "insight": {
      "chartResponseMap" : "totalPropertiesv3",
      "action" : "differenceOfNumbers",
      "upwardIndicator" : "positive",
      "downwardIndicator" : "negative",
      "textMessage" : "$indicator$value% than last $insightInterval",
      "colorCode" : "#228B22",
      "insightInterval" : "year",,\"aggs\":{\"intermediateAggrWard\":{\"terms\":{\"field\":\"ward.keyword\"},\"aggs\":{\"days\":{\"terms\":{\"field\":\"date\"},\"aggs\":{\"applications\":{\"avg\":{\"field\":\"todaysTotalApplications\"}}}},\"wardapplications\":{\"sum_bucket\":{\"buckets_path\":\"days.applications\"}}}},\"ulbApplications\":{\"sum_bucket\":{\"buckets_path\":\"intermediateAggrWard.wardapplications\"}}}},\"stateApplications\":{\"sum_bucket\":{\"buckets_path\":\"intermediateAggrULB.ulbApplications\"}}}},\"Total Applications\":{\"sum_bucket\":{\"buckets_path\":\"state.stateApplications\"}}}}}}",
        "requestQueryMap": "{\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\"}",
        "isRoundOffdateRefField": "date"
 true     }
    ],
    "_commentchartType": "metric",
  totol properties count"  "valueType": "number",
  },  	"propertiesAssessedv3action": {"",
    "chartNamedocumentType": "NATIONAL_PT_TOTAL_PROPERTIES_ASSESSED_doc",
    "queriesdrillChart": ["none",
      {"aggregationPaths": [
      "Total  "moduleApplications":
"PT",    ],
    "indexNameinsight": "pt-national-dashboard",{
        "aggrQuerychartResponseMap": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{}},\"aggs\":{\"Assessed Properties\":{\"sum\":{\"field\":\"assessedPropertiesForUsageCategory\"}}}}}}",
 "totalApplicationsv3",
      "requestQueryMapaction" : "{\"state\" : \"state.keyword\",\"ulb\differenceOfNumbers",
      "upwardIndicator" : \"ulb.keyword\"}"positive",

       "dateRefFielddownwardIndicator" : "datenegative",
      }"textMessage" : "$indicator$value% than last ]$insightInterval",
      "chartTypecolorCode" : "metric#228B22",
      "valueTypeinsightInterval" : "numberyear",
      "actionisRoundOff": "",true
    "documentType": "_doc"},
    "drillChart_comment": "none ",
    "aggregationPaths": [},
    
   "Assessed Properties"
    ],
    "insight""totalPropertiesv3": {
 
    "chartResponseMap" : "propertiesAssessedv3",
      "action" : "differenceOfNumbers",
      "upwardIndicator" : "positive",
      "downwardIndicator" : "negative",
      "textMessage" : "$indicator$value% than last $insightInterval",
      "colorCode" : "#228B22",
      "insightInterval" : "year",
      "isRoundOff": true
    },
    "_comment": " totol properties having assessmentNumber "
  },
	
	"totalAssessmentv3": {
    "chartName": "NATIONAL_DSS_PT_TOTAL_ASSESSMENTSPROPERTIES",
    "queries": [
      {
        "module": "PT",
        "indexName": "pt-national-dashboard",
        "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{}},\"aggs\":{\"stateTotal Application\":{\"termssum\":{\"field\":\"state.keywordpropertiesRegisteredForFinancialYear\"}},\"aggs\":}}}}",
        "requestQueryMap": "{\"intermediateAggrULBstate\" :{ \"termsstate.keyword\":{,\"fieldulb\" : \"ulb.keyword\"},\"aggs\":{\"intermediateAggrWard\":{\"terms\":{\"field\":\"ward.keyword\"},\"aggs\":{\"days\":{\"terms\":{\"field\":\"date\"},\"aggs\":{\"applications\":{\"avg\":{\"field\":\"assessments\"}}}},\"wardapplications\":{\"sum_bucket\":{\"buckets_path\":\"days.applications\"}}}},\"ulbApplications\":{\"sum_bucket\":{\"buckets_path\":\"intermediateAggrWard.wardapplications\"}}}},\"stateApplications\":{\"sum_bucket\":{\"buckets_path\":\"intermediateAggrULB.ulbApplications\"}}}},\"Total Assessments\":{\"sum_bucket\":{\"buckets_path\":\"state.stateApplications\"}}}}}}",
 ",
        "dateRefField": "date"
      }
    ],
    "chartType": "metric",
    "valueType": "number",
    "action": "",
    "documentType": "_doc",
    "drillChart": "none",
    "aggregationPaths": [
      "Total Application"
    ],
    "insight": {
      "chartResponseMap" : "totalPropertiesv3",
      "action" : "differenceOfNumbers",
      "upwardIndicator" : "positive",
      "downwardIndicator" : "negative",
      "textMessage" : "$indicator$value% than last $insightInterval",
      "colorCode" : "#228B22",
      "requestQueryMap": "{\"state\"insightInterval" : \"state.keyword\year",\"ulb\"
: \"ulb.keyword\"}",
        "dateRefFieldisRoundOff": "date"
 true
    }
    ],
    "chartType_comment": "metric", totol properties count"
 "valueType": "number" },

   	"actionpropertiesAssessedv3": "",{
    "documentTypechartName": "_docNATIONAL_PT_TOTAL_PROPERTIES_ASSESSED",
    "drillChart": "none",
    "aggregationPathsqueries": [
      "Total Assessments"
{
   ],     "insightmodule": {
      "chartResponseMapPT",
: "totalAssessmentv3",       "actionindexName" : "differenceOfNumberspt-national-dashboard",
        "upwardIndicatoraggrQuery" : "positive",
      "downwardIndicator" : "negative",
{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{}},\"aggs\":{\"Assessed Properties\":{\"sum\":{\"field\":\"assessedPropertiesForUsageCategory\"}}}}}}",
        "textMessagerequestQueryMap" : "{\"state\"$indicator$value% than last $insightInterval",
      "colorCode: \"state.keyword\",\"ulb\" : "#228B22\"ulb.keyword\"}",
        "insightIntervaldateRefField" : "yeardate",
      "isRoundOff": true}
    }],
    "_commentchartType": "metric",
 totol properties having assessmentNumber "
  }"valueType": "number",
    "action": "",
   	 "cumulativePropertiesAssessedv3documentType": {"_doc",
    "chartNamedrillChart": "NATIONAL_DSS_PT_CUMULATIVE_PROPERTIES_ASSESSEDnone",
    "queriesaggregationPaths": [
      "Assessed Properties"
{    ],
    "moduleinsight": "PT",
 {
      "indexNamechartResponseMap" : "pt-national-dashboardpropertiesAssessedv3",
        "aggrQueryaction" : "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{}},\"aggs\":{\"Assesments\":{\"date_histogram\":{\"field\":\"date\",\"interval\":\"intervalvalue\"},\"aggs\":{\"SUM\":{\"sum\":{\"field\":\"assessedPropertiesForUsageCategory\"}}}}}}}}",
differenceOfNumbers",
      "upwardIndicator" : "positive",
      "downwardIndicator" : "negative",
       "requestQueryMaptextMessage" : "{\"state\" : \"state.keyword\",\"ulb\$indicator$value% than last $insightInterval",
      "colorCode" : \"ulb.keyword\"}"#228B22",

       "dateRefFieldinsightInterval" : "dateyear",
      }
    ],
    "chartType": "line",
    "valueType": "number",
    "action": "",
    "documentType": "_doc",
    "drillChart": "none",
    "aggregationPaths": [
      "Assesments"
    ],
    "isCumulative": true,
    "interval": "month",	
    "insight": {"isRoundOff": true
    },
    "_comment": " totol properties having assessmentNumber "
  },
  
	
	"topPerformingStatesCompletionRatev3totalAssessmentv3": {
    "chartName": "NATIONAL_DSS_PT_TOP_3_PERFORMING_STATES_COMPLETION_RATETOTAL_ASSESSMENTS",
    "queries": [
      {
        "module": "PT",
        "requestQueryMapindexName": "{\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\"}",
        "dateRefField": "date",
        "indexName": "pt-national-dashboard",
        "aggrQuery": "{\"aggs"pt-national-dashboard",
        "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{}},\"aggs\":{\"state\":{\"AGGRterms\":{\"filterfield\":{\"boolstate.keyword\":{}},\"aggs\":{\"Closed ApplicationintermediateAggrULB\":{\"terms\":{\"field\":\"stateulb.keyword\"},\"aggs\":{\"sumintermediateAggrWard\":{\"sumterms\":{\"field\":\"assessedPropertiesForUsageCategoryward.keyword\"}}}},\"aggs\":{\"Total Applicationdays\":{\"terms\":{\"field\":\"state.keyworddate\"},\"aggs\":{\"sumapplications\":{\"sumavg\":{\"field\":\"propertiesRegisteredForFinancialYearassessments\"}}}}}}}}"
      }
    ],
    "chartType": "perform",
    "valueType": "percentage",
    "drillChart": "none",
    "documentType": "_doc",
    "action": "percentage",
    "plotLabel": "NATIONAL_DSS_COMPLETION_RATE",
    "order": "desc",
    "limit": 3,
    "isRoundOff": true,
    "aggregationPaths": [,\"wardapplications\":{\"sum_bucket\":{\"buckets_path\":\"days.applications\"}}}},\"ulbApplications\":{\"sum_bucket\":{\"buckets_path\":\"intermediateAggrWard.wardapplications\"}}}},\"stateApplications\":{\"sum_bucket\":{\"buckets_path\":\"intermediateAggrULB.ulbApplications\"}}}},\"Total Assessments\":{\"sum_bucket\":{\"buckets_path\":\"state.stateApplications\"}}}}}}",
        "requestQueryMap": "{\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\"}",
        "dateRefField"Closed: Application"date",
      "Total Application"}
    ],
    "insightchartType": {
    }"metric",
    "_commentvalueType": "number",
Top Performing states for Completion rate"
  },
"action": "",
    	"bottomPerformingStatesCompletionRatev3documentType": {"_doc",
    "chartNamedrillChart": "NATIONAL_DSS_PT_BOTTOM_3_PERFORMING_STATES_COMPLETION_RATEnone",
    "queriesaggregationPaths": [
      "Total Assessments"
{    ],
    "moduleinsight": {
      "PTchartResponseMap", : "totalAssessmentv3",
      "requestQueryMapaction" : "{\"state\"differenceOfNumbers",
      "upwardIndicator" : \"state.keyword\positive",\"ulb\
      "downwardIndicator" : \"ulb.keyword\"}"negative",
 
      "dateRefFieldtextMessage" : "date$indicator$value% than last $insightInterval",

       "indexNamecolorCode" : "pt-national-dashboard#228B22",
      "insightInterval" : "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{}},\"aggs\":{\"Closed Application\":{\"terms\":{\"field\":\"state.keyword\"},\"aggs\":{\"sumyear",
      "isRoundOff": true
    },
    "_comment": " totol properties having assessmentNumber "
  },
  
	"completionRateV3": {
    "chartName": "NATIONAL_DSS_PT_COMPLETION_RATE",
    "queries": [
       {
        "module": "PT",
        "requestQueryMap": "{\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\"}",
        "dateRefField": "date",
        "indexName": "pt-national-dashboard",
        "aggrQuery": "{\"aggs\":{\"sumAGGR\":{\"fieldfilter\":{\"assessedPropertiesForUsageCategorybool\"}}:{}},\"Total Applicationaggs\":{\"Closed Application\":{\"terms\":{\"field\":\"state.keyword\"},\"aggs\":{\"sum\":{\"sum\":{\"field\":\"assessedPropertiesForUsageCategory\"}}}},\"Total Application\":{\"terms\":{\"field\":\"state.keyword\"},\"aggs\":{\"sum\":{\"sum\":{\"field\":\"propertiesRegisteredForFinancialYear\"}}}}}}}}"
      }
    ],
    "chartType": "performmetric",
    "valueType": "percentage",
    "drillChart": "none",
    "documentType": "_doc",
    "action": "percentage",

   "plotLabel": "NATIONAL_DSS_COMPLETION_RATE",
    "order": "asc",
    "limit": 3,
    "isRoundOff": true,
    "aggregationPaths": [
      "Closed Application",
      "Total Application"
    ],
    "insight": {
    },  "chartResponseMap"  : "_comment": " Bottom Performing states for Completion rate"
  },
 	
 	"propertiesByUsageTypev3": {completionRateV3",
      "action" : "differenceOfNumbers",
      "upwardIndicator" : "positive",
      "chartNamedownwardIndicator" : "NATIONAL_DSS_PT_PROPERTIES_BY_USAGE_TYPEnegative",
      "queriestextMessage" : ["$indicator$value% than last $insightInterval",
   {   "colorCode" : "#228B22",
      "moduleinsightInterval" : "PTyear",
      "isRoundOff": true
"requestQueryMap    },
    "_comment": " "{\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\"}",
  },
	
	
	"cumulativePropertiesAssessedv3": {
    "chartName": "NATIONAL_DSS_PT_CUMULATIVE_PROPERTIES_ASSESSED",
    "queries": [
      {
        "dateRefFieldmodule": "datePT",
        "indexName": "pt-national-dashboard",
        "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{}},\"aggs\":{\"Usage TypeAssesments\":{\"termsdate_histogram\":{\"field\":\"date\",\"interval\":\"usageCategory.keywordintervalvalue\"},\"aggs\":{\"Assessed PropertiesSUM\":{\"sum\":{\"field\":\"assessedPropertiesForUsageCategory\"}}}}}}}}",
       } "requestQueryMap": "{\"state\"   ],
    "chartType": "pie",: \"state.keyword\",\"ulb\" : \"ulb.keyword\"}",
        "valueTypedateRefField": "number"date"
      }
    ],
    "chartType": "line",
    "valueType": "number",
    "action": "",
    "documentType": "_doc",
    "drillChart": "none",
    "aggregationPaths": [
      "Usage Type""Assesments"
    ],
    "isCumulative": true,
     ],"interval": "month",	
    "insight": {
    },
    "_comment": " totol properties having assessmentNumber per usage type"
  },
  
	 	"xptFyByStatesv3topPerformingStatesCompletionRatev3": {
    "chartName": "NATIONAL_DSS_PT_TOP_3_PROPERTIESPERFORMING_BYSTATES_FINANCIALCOMPLETION_YEARRATE",
    "queries": [
       {
      
        "module": "PT",
		
        "requestQueryMap": "{\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\"}",
        "dateRefField": "date",
        "indexName": "pt-national-dashboard",	
        "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{}},\"aggs\":{\"stateClosed Application\":{\"terms\":{\"field\":\"state.keyword\",\"size\":200},\"aggs\":{\"Fyssum\":{\"termssum\":{\"field\":\"financialYear.keywordassessedPropertiesForUsageCategory\"}}}},\"min_doc_countTotal Application\":0,{\"orderterms\":{\"_termfield\":\"ascstate.keyword\"}},\"aggs\":{\"sum\":{\"sum\":{\"field\":\"propertiesRegisteredForFinancialYear\"}}}}}}}}}}"
      },
    ],
 {   "chartType": "perform",
    "modulevalueType": "PTpercentage",
    "drillChart": "none",
    "requestQueryMapdocumentType": "{\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\"}_doc",
    "action": "percentage",
    "plotLabel": "NATIONAL_DSS_COMPLETION_RATE",
    "order": "desc",
    "dateRefFieldlimit": 3,
    "dateisRoundOff": true,
    "aggregationPaths": [
      "indexName": "pt-national-dashboard",Closed Application",
      "Total Application"
    ],
    "aggrQueryinsight": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{}},\"aggs\":{\"state \":{\"terms\":{\"field\":\"state.keyword\",\"size\":200},\"aggs\":{\"Total\":{\"sum\":{\"field\":\"propertiesRegisteredForFinancialYear\"}}}}}}}}"
{
    },
    "_comment": " Top Performing states for Completion rate"
  },
  
  	"bottomPerformingStatesCompletionRatev3": {
    "chartName": "NATIONAL_DSS_PT_BOTTOM_3_PERFORMING_STATES_COMPLETION_RATE",
    "queries": [
     } {
   ],     "isMdmsEnabledmodule": false"PT",
    "filterKeys": [       {"key": "state", "column": "State"}
"requestQueryMap": "{\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\"}",
   ],     "chartTypedateRefField": "xtabledate",
 
  "valueType": "number",     "drillChartindexName": "xptFyByUlbv3pt-national-dashboard",
 
  "plotLabel": "State",     "insightaggrQuery": {
    },
    "_comment": " fy data"
  },
  
  	"xptFyByUlbv3": {
    "chartName": "NATIONAL_DSS_PT_PROPERTIES_BY_FINANCIAL_YEAR_ULB",
    "queries": [
       {
      
        "module": "PT",
		"requestQueryMap": "{\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\"}",
        "dateRefField": "date",
        "indexName": "pt-national-dashboard",	
        "aggrQuery": "{\"aggs"{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{}},\"aggs\":{\"Closed Application\":{\"terms\":{\"field\":\"state.keyword\"},\"aggs\":{\"sum\":{\"AGGRsum\":{\"filterfield\":{\"boolassessedPropertiesForUsageCategory\":{}}}},\"aggsTotal Application\":{\"ulb terms\":{\"termsfield\":{\"field\":\"ulbstate.keyword\",\"size\":200},\"aggs\":{\"Fyssum\":{\"termssum\":{\"field\":\"financialYear.keyword\",\"min_doc_count\":0,\"order\":{\"_term\":\"asc\"}},\"aggs\":{\"sum\":{\"sum\":{\"field\":\"propertiesRegisteredForFinancialYear\"}}}}}}}}}}"
      },
      {
        "module": "PT",
        "requestQueryMap": "{\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\"}",propertiesRegisteredForFinancialYear\"}}}}}}}}"
      }
    ],
    "chartType": "perform",
    "valueType": "percentage",
    "drillChart": "none",
    "documentType": "_doc",
    "action": "percentage",
    "plotLabel": "NATIONAL_DSS_COMPLETION_RATE",
    "order": "asc",
    "limit": 3,
    "isRoundOff": true,
    "aggregationPaths": [
      "Closed Application",
      "Total Application"
    ],
    "insight": {
    },
    "_comment": " Bottom Performing states for Completion rate"
  },
 	
 	"propertiesByUsageTypev3": {
    "chartName": "NATIONAL_DSS_PT_PROPERTIES_BY_USAGE_TYPE",
    "queries": [
      {
        "module": "PT",
        "requestQueryMap": "{\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\"}",
        "dateRefField": "date",
        "indexName": "pt-national-dashboard",
        "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{}},\"aggs\":{\"Usage Type\":{\"terms\":{\"field\":\"usageCategory.keyword\"},\"aggs\":{\"Assessed Properties\":{\"sum\":{\"field\":\"assessedPropertiesForUsageCategory\"}}}}}}}}"

      }
    ],
    "chartType": "pie",
    "valueType": "number",
    "action": "",
    "documentType": "_doc",
    "drillChart": "none",
    "aggregationPaths": [
      "Usage Type"
    ],
    "insight": {
    },
    "_comment": " properties having assessmentNumber per usage type"
  },
	
	"xptFyByStatesv3": {
    "chartName": "NATIONAL_DSS_PT_PROPERTIES_BY_FINANCIAL_YEAR",
    "queries": [
       {
      
        "module": "PT",
		"requestQueryMap": "{\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\"}",
        "dateRefField": "date",
        "indexName": "pt-national-dashboard",	
        "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{}},\"aggs\":{\"state \":{\"terms\":{\"field\":\"state.keyword\",\"size\":200},\"aggs\":{\"Fys\":{\"terms\":{\"field\":\"financialYear.keyword\",\"min_doc_count\":0,\"order\":{\"_term\":\"asc\"}},\"aggs\":{\"sum\":{\"sum\":{\"field\":\"propertiesRegisteredForFinancialYear\"}}}}}}}}}}"
      },
      {
        "module": "PT",
        "requestQueryMap": "{\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\"}",
        "dateRefField": "date",
        "indexName": "pt-national-dashboard",
        "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{}},\"aggs\":{\"state \":{\"terms\":{\"field\":\"state.keyword\",\"size\":200},\"aggs\":{\"Total\":{\"sum\":{\"field\":\"propertiesRegisteredForFinancialYear\"}}}}}}}}"
      }
    ],
    "isMdmsEnabled": false,
    "filterKeys": [
      {"key": "state", "column": "State"}
    ],
    "chartType": "xtable",
    "valueType": "number",
    "drillChart": "xptFyByUlbv3",
    "plotLabel": "State",
    "insight": {
    },
    "_comment": " fy data"
  },
  
  	"xptFyByUlbv3": {
    "chartName": "NATIONAL_DSS_PT_PROPERTIES_BY_FINANCIAL_YEAR_ULB",
    "queries": [
       {
      
        "module": "PT",
		"requestQueryMap": "{\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\"}",
        "dateRefField": "date",
        "indexName": "pt-national-dashboard",	
        "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{}},\"aggs\":{\"ulb \":{\"terms\":{\"field\":\"ulb.keyword\",\"size\":200},\"aggs\":{\"Fys\":{\"terms\":{\"field\":\"financialYear.keyword\",\"min_doc_count\":0,\"order\":{\"_term\":\"asc\"}},\"aggs\":{\"sum\":{\"sum\":{\"field\":\"propertiesRegisteredForFinancialYear\"}}}}}}}}}}"
      },
      {
        "module": "PT",
        "requestQueryMap": "{\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\"}",
        "dateRefField": "date",
        "indexName": "pt-national-dashboard",
        "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{}},\"aggs\":{\"ulb \":{\"terms\":{\"field\":\"ulb.keyword\",\"size\":200},\"aggs\":{\"Total\":{\"sum\":{\"field\":\"propertiesRegisteredForFinancialYear\"}}}}}}}}"
      }
    ],
    "isMdmsEnabled": false,
    "filterKeys": [
      {"key": "ulb", "column": "Ulb"}
    ],
    "chartType": "xtable",
    "valueType": "number",
    "drillChart": "xptFyByWardv3",
    "drillFields": [
      "ward",
      ""
    ],
    "plotLabel": "Ulb",
    "insight": {
    },
    "_comment": " fy data"
  },
  
  	"xptFyByWardv3": {
    "chartName": "NATIONAL_DSS_PT_PROPERTIES_BY_FINANCIAL_YEAR_Ward",
    "queries": [
       {
      
        "module": "PT",
		"requestQueryMap": "{\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\"}",
        "dateRefField": "date",
        "indexName": "pt-national-dashboard",	
        "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{}},\"aggs\":{\"ward \":{\"terms\":{\"field\":\"ward.keyword\",\"size\":200},\"aggs\":{\"Fys\":{\"terms\":{\"field\":\"financialYear.keyword\",\"min_doc_count\":0,\"order\":{\"_term\":\"asc\"}},\"aggs\":{\"sum\":{\"sum\":{\"field\":\"propertiesRegisteredForFinancialYear\"}}}}}}}}}}"
      },
      {
        "module": "PT",
        "requestQueryMap": "{\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\"}",
        "dateRefField": "date",
        "indexName": "pt-national-dashboard",
        "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{}},\"aggs\":{\"ward \":{\"terms\":{\"field\":\"ward.keyword\",\"size\":200},\"aggs\":{\"Total\":{\"sum\":{\"field\":\"propertiesRegisteredForFinancialYear\"}}}}}}}}"
      }
    ],
    "isMdmsEnabled": false,
    "filterKeys": [
    ],
    "chartType": "xtable",
    "valueType": "number",
    "drillChart": "",
    "plotLabel": "Ward",
    "insight": {
    },
    "_comment": " fy data"
  },
  "avgTaxCollectedPerProperty": {
    "chartName": "NATIONAL_PT_DSS_AVG_TAX_COLLECTION",
    "queries": [
      {
        "module": "PT",
        "dateRefField": "date",
        "requestQueryMap": "{\"ward\" : \"ward.keyword\",\"ulb\" : \"ulb.keyword\", \"state\" : \"state.keyword\"}",
        "indexName": "pt-national-dashboard",
        "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{}},\"aggs\":{\"ND_Total_Collection\":{\"sum\":{\"field\":\"todaysCollectionForUsageCategory\"}},\"No of properties paid\":{\"sum\":{\"field\":\"noOfPropertiesPaidToday\"}}}}}}"
      }
    ],
    "chartType": "metric",
    "valueType": "amount",
    "action": "division",
    "drillChart": "none",
    "aggregationPaths": [
      "ND_Total_Collection",
      "No of properties paid"
    ],
    "computedFields": [
      {
        "postAggregationTheory": "",
        "actionName": "DivisionComputedField",
        "fields": [
          "ND_Total_Collection",
          "No of properties paid"
        ],
        "newField": "Avg Tax Collected per property",
        "_comments": "fields are field names picked from its aggregation query to use post aggregation newField value with given new field name  "
      }
    ],
    "insight": {
      "chartResponseMap": "avgTaxCollectedPerProperty",
      "action": "differenceOfNumbers",
      "upwardIndicator": "positive",
      "downwardIndicator": "negative",
      "textMessage": "$indicator$value% than last $insightInterval",
      "colorCode": "#228B22",
      "insightInterval": "year",
      "isRoundOff": true
    },
    "_comment": "Average tax collected per property"
  }

Click here to check the complete configuration

Master Dashboard Configuration:

Master Dashboard Configuration is the main configuration which defines as which are the Dashboards which are to be painted on screen.

It includes all the Visualizations, their groups, the charts which comes within them and even their dimensions as what should be their height and width.

Code Block

{
      "name": "NATIONAL_DSS_PROPERTY_TAX_DASHBOARD",
      "id": "national-propertyTax",
      "isActive": "",
      "style": "linear",
      "visualizations": [
        {
          "dateRefFieldrow": "date"1,
          "indexNamename": "pt-national-dashboardNATIONAL_DSS_REVENUE",
        "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{}},\"aggs\":{\"ulb \":{\"terms\":{\"field\":\"ulb.keyword\",\"size\":200},\"aggs\":{\"Total\":{\"sum\":{\"field\":\"propertiesRegisteredForFinancialYear\"}}}}}}}}"
 "vizArray": [
            {
    }     ],     "isMdmsEnabledid": false211,
      "filterKeys": [       {"keyname": "ulbNATIONAL_DSS_OVERVIEW",
              "columndimensions": "Ulb"} {
           ],     "chartTypeheight": "xtable",350,
        "valueType": "number",        "drillChartwidth": "xptFyByWardv3",5
    "drillFields": [       "ward",  },
    ""     ],     "plotLabelvizType": "Ulbmetric-collection",

   "insight": {     },     "_commentnoUnit": true,
  "  fy data"   },      	"xptFyByWardv3isCollapsible": { false,
              "chartNamelabel": "NATIONAL_DSS_PT_PROPERTIES_BY_FINANCIAL_YEAR_Ward",OVERVIEW",
              "queriescharts": [
       {         {
      "module": "PT", 		"requestQueryMap": "{\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\"}",
        "dateRefFieldid": "datetodaysCollectionv3",
        "indexName": "pt-national-dashboard",	         "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{}},\"aggs\":{\"ward \":{\"terms\":{\"field\":\"ward.keyword\",\"size\":200},\"aggs\":{\"Fys\":{\"terms\":{\"field\":\"financialYear.keyword\",\"min_doc_count\":0,\"order\":{\"_term\":\"asc\"}},\"aggs\":{\"sum\":{\"sum\":{\"field\":\"propertiesRegisteredForFinancialYear\"}}}}}}}}}}" "name": "NATIONAL_DSS_TOTAL_COLLECTION_TODAY",
                  "code": "",
                  "chartType": "metric",
                  "filter": {"title": "TODAY"},
                  "headers": []
                },
                {
                  "moduleid": "PTtotalCollectionv3",
   
    "requestQueryMap": "{\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\"}",         "dateRefFieldname": "dateNATIONAL_PT_DSS_TOTAL_COLLECTION",
        "indexName": "pt-national-dashboard",         "aggrQuerycode": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{}},\"aggs\":{\"ward \":{\"terms\":{\"field\":\"ward.keyword\",\"size\":200},\"aggs\":{\"Total\":{\"sum\":{\"field\":\"propertiesRegisteredForFinancialYear\"}}}}}}}}",
        }     ],     "isMdmsEnabledchartType": false,"metric",
       "filterKeys": [     ],     "chartTypefilter": "xtable",
    "valueType": "number",              "drillChartheaders": "",[]
    "plotLabel": "Ward",     "insight": {     },
        "_comment": " fy data"   }

Click here to check the complete configuration

Master Dashboard Configuration:

Master Dashboard Configuration is the main configuration which defines as which are the Dashboards which are to be painted on screen.

It includes all the Visualizations, their groups, the charts which comes within them and even their dimensions as what should be their height and width.

Code Block

 { {
          "name": "NATIONAL_DSS_PROPERTY_TAX_DASHBOARD",       "id": "national-propertyTaxtargetCollectionv3",
          "isActive": "",       "stylename": "linearNATIONAL_PT_DSS_TARGET_COLLECTION",
      "visualizations": [         {    "code": "",
      "row": 1,           "namechartType": "NATIONAL_DSS_REVENUEmetric",
          "vizArray": [       "filter": "",
    {               "idheaders": 211,[]
               "name": "NATIONAL_DSS_OVERVIEW" },
              "dimensions":  {
                  "heightid": 350"targetAchievedv3",
                  "widthname": 5
          "NATIONAL_DSS_TARGET_ACHIEVED",
   },               "vizTypecode": "metric-collection",
                  "noUnitchartType": true"metric",
                  "isCollapsiblefilter": false,"",
                  "labelheaders": "NATIONAL_DSS_OVERVIEW", []
               "charts": [ },
                {
                  "id": "todaysCollectionv3avgTaxCollectedPerProperty",
                  "name": "NATIONAL_PT_DSS_AVG_TOTALTAX_COLLECTION_TODAY",
                  "code": "",
                  "chartType": "metric",
                  "filter": {"title": "TODAY"},
                  "headers": []
                },
              ]
 {           },
       "id": "totalCollectionv3",    {
              "nameid": "NATIONAL_DSS_TOTAL_COLLECTION",
   212,
              "codename": "",
   NATIONAL_DSS_TOTAL_CUMULATIVE_COLLECTION",
              "chartTypedimensions": "metric",
 {
                "filterheight": ""350,

                 "headerswidth": []7
                },
                {
  "vizType": "chart",
               "idnoUnit": "targetCollectionv3"true,
 
                "nameisCollapsible": "NATIONAL_DSS_TARGET_COLLECTION",
   false,
              "codecharts": "",[
                  "chartType": "metric",{
                  "filterid": "cumulativeCollectionv3",
                  "headersname": []"Monthly",
                },                 {"code": "",
                  "idchartType": "targetAchievedv3line",
                  "namefilter": "NATIONAL_DSS_TARGET_ACHIEVED",
                  "codeheaders": "", []
                }
         "chartType": "metric",    ]
            }
 "filter": "",        ]
        },
 "headers": []      {
          }
"row": 2,
          "name": "NATIONAL_DSS_REVENUE",
 ]         "vizArray": [
  },             {
              "id": 212221,
              "name": "NATIONAL_DSS_PT_TOTALCOLLECTION_BY_CUMULATIVEUSAGE_COLLECTIONTYPE",
              "dimensions": {
                "height": 350250,
                "width": 74
              },
              "vizType": "chart",
              "noUnit": true,
              "isCollapsible": false,
              "charts": [
                {
                  "id": "cumulativeCollectionv3collectionByUsageTypev3",
                  "name": "MonthlyNATIONAL_DSS_PT_COLLECTION_BY_USAGE_TYPE",
                  "code": "",
                  "chartType": "linedonut",
                  "filter": "",
                  "headers": []
                }
              ]
            }
          ]
        },
        {
          "row":
2,           "name": "NATIONAL_DSS_REVENUE",
          "vizArray": [
           	   {
              "id": 221222,
              "name": "NATIONAL_DSS_PT_TOP_3_COLLECTIONPERFORMING_BYSTATES_USAGETARGET_TYPEACHIEVEMENT",
              "dimensions": {
                "height": 250,
                "width": 4
              },
              "vizType": "chartperforming-metric",
              "noUnit": truefalse,
              "isCollapsible": false,
              "label": "",
              "charts": [
                {
                  "id": "collectionByUsageTypev3topPerformingStatesv3",
                  "name": "NATIONAL_DSS_PT_TOP_3_COLLECTIONPERFORMING_BYSTATES_USAGETARGET_TYPEACHIEVEMENT",
                  "code": "",
                  "chartType": "donutbar",
                  "filter": "",
                  "headers": []
                }
              ]
            },
            {
              "id": 222223,
              "name": "NATIONAL_DSS_PT_TOPBOTTOM_3_PERFORMING_STATES_TARGET_ACHIEVEMENT",
              "dimensions": {
                "height": 250,
                "width": 4
              },
              "vizType": "performing-metric",
              "noUnit": false,
              "isCollapsible": false,
              "label": "",
              "charts": [
                {
                  "id": "topPerformingStatesv3bottomPerformingStatesv3",
                  "name": "NATIONAL_DSS_PT_TOPBOTTOM_3_PERFORMING_STATES_TARGET_ACHIEVEMENT",
                  "code": "",
             
    "chartType": "bar",
                  "filter": "",
                  "headers": []
                }
              ]
            },
            {
              "id": 223,               "namechartType": "NATIONAL_DSS_PT_BOTTOM_3_PERFORMING_STATES_TARGET_ACHIEVEMENTbar",
                  "dimensionsfilter": "",
{                  "heightheaders": 250,[]
                "width":}
4              ]
},            }
  "vizType": "performing-metric",       ]
       "noUnit": false},
        {
          "isCollapsiblerow": false3,
          "name": "NATIONAL_DSS_REVENUE",
  "charts": [       "vizArray": [
        {    {
              "id": "bottomPerformingStatesv3",
   231,
              "name": "NATIONAL_DSS_PT_BOTTOMKEY_3_PERFORMING_STATES_TARGET_ACHIEVEMENT",
   FY_INDICATORS",
              "codedimensions": "",
 {
                "chartTypeheight": "bar"350,

                 "filterwidth": "",12
              },
   "headers": []          "vizType": "chart",
     }         "noUnit": false,
    ]          "isCollapsible": false,
 }           ]      "charts": [
  },         {     {
     "row": 3,             "nameid": "NATIONAL_DSS_REVENUEdemandCollectionIndexStatesRevenuev3",
          "vizArray": [         "name": "NATIONAL_DSS_PT_DEMAND_COLLECTION_STATES",
   {               "idcode": 231,"",
                  "namechartType": "NATIONAL_DSS_PT_KEY_FY_INDICATORStable",
                  "dimensionsfilter": "",
{                  "heightheaders": 350[],
                  "widthtabName": "Boundary"
12                },
                {
  "vizType": "chart",               "noUnitid": false,"demandCollectionIndexUsageRevenuev3",
                  "isCollapsiblename": false,"NATIONAL_DSS_PT_DEMAND_COLLECTION_USAGETYPE",
                  "chartscode": "",
  [                 {"chartType": "table",
                  "idfilter": "demandCollectionIndexStatesRevenuev3",
                  "nameheaders": "NATIONAL_DSS_PT_DEMAND_COLLECTION_STATES"[],
                  "codetabName": "Usage",
                }
      "chartType": "table",       ]
           "filter": "", }
          ]
       "headers": [] },
        {
          "tabNamerow": "Boundary"4,
          "name": "NATIONAL_DSS_REVENUE",
    },      "vizArray": [
         {    {
              "id": "demandCollectionIndexUsageRevenuev3"231,
                  "name": "NATIONAL_DSS_PT_DEMANDTAX_COLLECTION_USAGETYPEHEAD",
   
              "codedimensions": "",
{
                 "chartTypeheight": "table"350,
 
                "filterwidth": "", 12
              },
              "headersvizType": [],
   "chart",
              "tabNamelabel": "Usage",
              "noUnit": false,
}               ]"isCollapsible": true,
            }  "charts": [
       ]         },
{
       {           "rowid": 4,"taxHeadsBreakupStatesRevenuev3",
                  "name": "NATIONAL_DSS_PT_TAX_HEAD_BREAKUP_REVENUE",
                  "vizArraycode": [ "",
                  "chartType": "table",
   {               "idfilter": 231"",
                  "nameheaders": "NATIONAL_DSS_PT_TAX_HEAD"[],
                  "dimensionstabName": "Boundary"
 {               },
  "height": 350,             {
   "width": 12               },"id": "taxHeadsBreakupUsagev3",
                  "vizTypename": "chartNATIONAL_DSS_PT_TAX_HEAD_BREAKUP_USAGE",
                  "labelcode": "",
                  "noUnitchartType": false"table",
                  "isCollapsiblefilter": true"",
                  "chartsheaders": [],
                 { "tabName": "Usage"
                "id": "taxHeadsBreakupStatesRevenuev3",}
              ]
    "name": "NATIONAL_DSS_PT_TAX_HEAD_BREAKUP_REVENUE",       }
          ]
"code": "",       },
        {
  "chartType": "table",       "row": 5,
          "filtername": "NATIONAL_DSS_SERVICE",
          "vizArray": [
       "headers": [],    {
              "tabNameid": "Boundary"241,
                }"name": "NATIONAL_DSS_OVERVIEW",
              "dimensions":  {
 
                "idheight": "taxHeadsBreakupUsagev3"350,
 
                "namewidth": "NATIONAL_DSS_PT_TAX_HEAD_BREAKUP_USAGE",5
                  "code": "",
  },
               "chartTypevizType": "tablemetric-collection",
   
              "filterisCollapsible": "",
   false,
              "headerslabel": [],
   "NATIONAL_DSS_OVERVIEW",
              "tabNamecharts": "Usage"[
                }{
              ]    "id": "totalApplicationsv3",
       }           ]
 "name": "NATIONAL_DSS_PT_TOTAL_APPLICATIONS",
      },         {   "code": "",
      "row": 5,           "namechartType": "NATIONAL_DSS_SERVICEmetric",
          "vizArray": [         "filter": "",
   {               "idheaders": []
241,               "name": "NATIONAL_DSS_OVERVIEW", },
               "dimensions": {
                  "heightid": 350"totalPropertiesv3",
                  "widthname": 5 "NATIONAL_DSS_PT_TOTAL_PROPERTIES",
                   },"code": "",
                  "vizTypechartType": "metric-collection",
                  "isCollapsiblefilter": false"",
                  "labelheaders": "NATIONAL_DSS_OVERVIEW", []
               "charts": [ },
                {
                  "id": "totalPropertiesv3propertiesAssessedv3",
                  "name": "NATIONAL_DSS_PT_TOTAL_PROPERTIES_ASSESSED",
                  "code": "",
                  "chartType": "metric",
                  "filter": "",
                  "headers": []
                },
                {
                  "id": "propertiesAssessedv3totalAssessmentv3",
                  "name": "NATIONAL_DSS_PT_TOTAL_PROPERTIES_ASSESSEDASSESSMENTS",
                  "code": "",
                  "chartType": "metric",
                  "filter": "",
                  "headers": []
                },
                {
                  "id": "totalAssessmentv3completionRateV3",
                  "name": "NATIONAL_DSS_PT_TOTALCOMPLETION_ASSESSMENTSRATE",
                  "code": "",
                  "chartType": "metric",
                  "filter": "",
                  "headers": []
                }
              ]
            },
            {
              "id": 242,
              "name": "NATIONAL_DSS_PT_CUMULATIVE_PROPERTIES_ASSESSED",
              "dimensions": {
                "height": 350,
                "width": 7
              },
              "vizType": "chart",
              "isCollapsible": false,
              "charts": [
                {
                  "id": "cumulativePropertiesAssessedv3",
                  "name": "Monthly",
                  "code": "",
                  "chartType": "line",
                  "filter": "",
                  "headers": []
                }
              ]
            }
          ]
        },
        {
          "row": 6,
          "name": "NATIONAL_DSS_SERVICE",
          "vizArray": [
            {
              "id": 251,
              "name": "NATIONAL_DSS_PT_PROPERTIES_BY_USAGE_TYPE",
              "dimensions": {
                "height": 250,
                "width": 4
              },
              "vizType": "chart",
              "isCollapsible": false,
              "charts": [
                {
                  "id": "propertiesByUsageTypev3",
                  "name": "NATIONAL_DSS_PT_PROPERTIES_BY_USAGE_TYPE",
                  "code": "",
                  "chartType": "donut",
                  "filter": "",
                  "headers": []
                }
              ]
            },
            {
              "id": 252,
              "name": "NATIONAL_DSS_PT_TOP_3_PERFORMING_STATES_COMPLETION_RATE",
              "dimensions": {
                "height": 250,
                "width": 4
              },
              "vizType": "performing-metric",
              "isCollapsible": false,
              "label": "",
              "charts": [
                {
                  "id": "topPerformingStatesCompletionRatev3",
                  "name": "NATIONAL_DSS_PT_TOP_3_PERFORMING_STATES_COMPLETION_RATE",
                  "code": "",
                  "chartType": "bar",
                  "filter": "",
                  "headers": []
                }
              ]
            },
            {
              "id": 253,
              "name": "NATIONAL_DSS_PT_BOTTOM_3_PERFORMING_STATES_COMPLETION_RATE",
              "dimensions": {
                "height": 250,
                "width": 4
              },
              "vizType": "performing-metric",
              "isCollapsible": false,
              "charts": [
                {
                  "id": "bottomPerformingStatesCompletionRatev3",
                  "name": "NATIONAL_DSS_PT_BOTTOM_3_PERFORMING_STATES_COMPLETION_RATE",
                  "code": "",
                  "chartType": "bar",
                  "filter": "",
                  "headers": []
                }
              ]
            }          ]
        },
        {
          "row": 7,
          "name": "NATIONAL_DSS_SERVICE",
          "vizArray": [
            {
              "id": 231,
              "name": "NATIONAL_DSS_PT_PROPERTIES_BY_FINANCIAL_YEAR",
              "dimensions": {
                "height": 350,
                "width": 12
              },
              "vizType": "chart",
              "label": "",
              "noUnit": false,
              "isCollapsible": true,
              "charts": [
                {
                  
                  "id": "xptFyByStatesv3",
                  "name": "NATIONAL_DSS_PT_PROPERTIES_BY_FINANCIAL_YEAR",
                  "code": "",
                  "chartType": "table",
                  "filter": "",
                  "headers": [],
                  "tabName": "Boundary"
                }
              ]
            }
          ]
        }
      ]
    },

...

Collection on : This represents the today’s collection amount.
Total Collection : This represents the total collection amount.
Target Collection : This represents the target collection amount.
Target Achievement : This represents the target achieved in percentage. This is calculated by formula- (Total Collection/Target Collection)*100%

...

Average Property Tax Collected : This represents the average tax collected by each property. This is calculated by formula- (Total property tax collected / Total number of properties paid)

...

Total Cumulative Collection:

...

Overview graph contains multiple data information as below in the selected time period.

Total Applications: This represents the total number of applications.
Total Properties : This represents the total number of properties Register.
Total Properties Assessed : This represents the total Properties Assessed.
Total Assessments : This represents the total Assessements of Properties.
Completion Rate: This represents Total Properties Assessed / Total Properties.

...

Total Cumulative Properties Assessed:

...

Attributes	Definition	Breakup
`state`	It represents the state name. for ex. Punjab	Nil
`ulb`	It represents the ulb name of state . for ex. for state Punjab, ulb can be `"pb.amritsar"`, `"pb.longowal" etc.`	Nil
`ward`	It represents the ward name of particular ulb of particular state. for ex. for ulb `"pb.amritsar"`, ward name can we “Ram Nagar”, “Ajith Nagar” etc.	Nil
`usageCategory`	It represents the category like “RESIDENCIAL”, INDUSTRIAL”, “COMMERCIAL” etc.	Nil
`transactionsForUsageCategory`	It represents total transactions based on the usageCategory on given date.	Breakup by usageCategory(RESIDENCIAL, INDUSTRIAL,COMMERCIAL etc. )
`assessedPropertiesForUsageCategory`	It represents total properties assessed based on the usageCategory on given date.	Breakup by usageCategory(RESIDENCIAL, INDUSTRIAL,COMMERCIAL etc. )
`todaysCollectionForUsageCategory`	It represents the aggregation of fields property tax, cess, penalty, interest, rebate(should be nagative number) for the given date based on the usageCategory.	Breakup by usageCategory(RESIDENCIAL, INDUSTRIAL,COMMERCIAL etc. )
`propertyTaxForUsageCategory`	It represents the collection done as part of property tax for given date based on the usageCategory.	Breakup by usageCategory(RESIDENCIAL, INDUSTRIAL,COMMERCIAL etc. )
`cessForUsageCategory`	It represents the collection done as part of cess for given date based on the usageCategory.	Breakup by usageCategory(RESIDENCIAL, INDUSTRIAL,COMMERCIAL etc. )
`rebateForUsageCategory`	It represents the rebate given based on the usageCategory.	Breakup by usageCategory(RESIDENCIAL, INDUSTRIAL,COMMERCIAL etc. )
`penaltyForUsageCategory`	It represents the collection done as part of panalty for given date based on the usageCategory.	Breakup by usageCategory(RESIDENCIAL, INDUSTRIAL,COMMERCIAL etc. )
`interestForUsageCategory`	It represents the collection done as part of interest for given date based on the usageCategory.	Breakup by usageCategory(RESIDENCIAL, INDUSTRIAL,COMMERCIAL etc. )
`assessments`	It represents number of assessments done.	Nil
`todaysTotalApplications`	It represents number of applications created as part of property tax on given date	Nil
`todaysClosedApplications`	It represents number of closed applications as part of property tax on given date.	Nil
`date`	It represents date for which data is ingesting	Nil
`financialYear`	it represents financial year which which data is inserting.	Nil
`propertiesRegisteredForFinancialYear`	It represents number of properties registered in the system for the given financial year.	Breakup by financialYear(“2021-22”, “2022-23” etc.)

Postman collection for National Property Tax.

https://www.getpostman.com/collections/4fe5a883ea653bfe07a2

Versions Compared

Old Version 7

New Version Current

Key

Description :

Attributes

Definition

Breakup