...
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 :
...
| Code Block |
|---|
"_comment": "NSS-PROPERTYTAX",
"todaysCollectionv3": {
"chartName": "NATIONAL_DSS_TODAYS_COLLECTION",
"queries": [
{
"module": "PT",
"dateRefField": "",
"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": {
},
"_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"
],
"preActionTheory":{
"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": ""
},
"totalApplicationsv3": {
"chartName": "NATIONAL_DSS_PT_TOTAL_APPLICATIONS",
"queries": [
{
"module": "PT",
"indexName": "pt-national-dashboard",
"aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{}},\"aggs\":{\"state\":{\"terms\":{\"field\":\"state.keyword\"},\"aggs\":{\"intermediateAggrULB\":{\"terms\":{\"field\":\"ulb.keyword\"},\"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\"}",
"dateRefField": "date"
}
],
"chartType": "metric",
"valueType": "number",
"action": "",
"documentType": "_doc",
"drillChart": "none",
"aggregationPaths": [
"Total Applications"
],
"insight": {
"chartResponseMap" : "totalApplicationsv3",
"action" : "differenceOfNumbers",
"upwardIndicator" : "positive",
"downwardIndicator" : "negative",
"textMessage" : "$indicator$value% than last $insightInterval",
"colorCode" : "#228B22",
"insightInterval" : "year",
"isRoundOff": true
},
"_comment": " "
},
"totalPropertiesv3": {
"chartName": "NATIONAL_DSS_PT_TOTAL_PROPERTIES",
"queries": [
{
"module": "PT",
"indexName": "pt-national-dashboard",
"aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{}},\"aggs\":{\"Total Application\":{\"sum\":{\"field\":\"propertiesRegisteredForFinancialYear\"}}}}}}",
"requestQueryMap": "{\"state\" : \"state.keyword\",\"ulb\" : \"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",
"isRoundOff": true
},
"_comment": " totol properties count"
},
"propertiesAssessedv3": {
"chartName": "NATIONAL_PT_TOTAL_PROPERTIES_ASSESSED",
"queries": [
{
"module": "PT",
"indexName": "pt-national-dashboard",
"aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{}},\"aggs\":{\"Assessed Properties\":{\"sum\":{\"field\":\"assessedPropertiesForUsageCategory\"}}}}}}",
"requestQueryMap": "{\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\"}",
"dateRefField": "date"
}
],
"chartType": "metric",
"valueType": "number",
"action": "",
"documentType": "_doc",
"drillChart": "none",
"aggregationPaths": [
"Assessed Properties"
],
"insight": {
"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_ASSESSMENTS",
"queries": [
{
"module": "PT",
"indexName": "pt-national-dashboard",
"aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{}},\"aggs\":{\"state\":{\"terms\":{\"field\":\"state.keyword\"},\"aggs\":{\"intermediateAggrULB\":{\"terms\":{\"field\":\"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\"}}}}}}",
"requestQueryMap": "{\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\"}",
"dateRefField": "date"
}
],
"chartType": "metric",
"valueType": "number",
"action": "",
"documentType": "_doc",
"drillChart": "none",
"aggregationPaths": [
"Total Assessments"
],
"insight": {
"chartResponseMap" : "totalAssessmentv3",
"action" : "differenceOfNumbers",
"upwardIndicator" : "positive",
"downwardIndicator" : "negative",
"textMessage" : "$indicator$value% than last $insightInterval",
"colorCode" : "#228B22",
"insightInterval" : "year",
"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\":{\"AGGR\":{\"filter\":{\"bool\":{}},\"aggs\":{\"Closed Application\":{\"terms\":{\"field\":\"state.keyword\"},\"aggs\":{\"sum\":{\"sum\":{\"field\":\"assessedPropertiesForUsageCategory\"}}}},\"Total Application\":{\"terms\":{\"field\":\"state.keyword\"},\"aggs\":{\"sum\":{\"sum\":{\"field\":\"propertiesRegisteredForFinancialYear\"}}}}}}}}"
}
],
"chartType": "metric",
"valueType": "percentage",
"drillChart": "none",
"documentType": "_doc",
"action": "percentage",
"isRoundOff": true,
"aggregationPaths": [
"Closed Application",
"Total Application"
],
"insight": {
"chartResponseMap" : "completionRateV3",
"action" : "differenceOfNumbers",
"upwardIndicator" : "positive",
"downwardIndicator" : "negative",
"textMessage" : "$indicator$value% than last $insightInterval",
"colorCode" : "#228B22",
"insightInterval" : "year",
"isRoundOff": true
},
"_comment": " "
},
"cumulativePropertiesAssessedv3": {
"chartName": "NATIONAL_DSS_PT_CUMULATIVE_PROPERTIES_ASSESSED",
"queries": [
{
"module": "PT",
"indexName": "pt-national-dashboard",
"aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{}},\"aggs\":{\"Assesments\":{\"date_histogram\":{\"field\":\"date\",\"interval\":\"intervalvalue\"},\"aggs\":{\"SUM\":{\"sum\":{\"field\":\"assessedPropertiesForUsageCategory\"}}}}}}}}",
"requestQueryMap": "{\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\"}",
"dateRefField": "date"
}
],
"chartType": "line",
"valueType": "number",
"action": "",
"documentType": "_doc",
"drillChart": "none",
"aggregationPaths": [
"Assesments"
],
"isCumulative": true,
"interval": "month",
"insight": {
},
"_comment": " totol properties having assessmentNumber "
},
"topPerformingStatesCompletionRatev3": {
"chartName": "NATIONAL_DSS_PT_TOP_3_PERFORMING_STATES_COMPLETION_RATE",
"queries": [
{
"module": "PT",
"requestQueryMap": "{\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\"}",
"dateRefField": "date",
"indexName": "pt-national-dashboard",
"aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{}},\"aggs\":{\"Closed Application\":{\"terms\":{\"field\":\"state.keyword\"},\"aggs\":{\"sum\":{\"sum\":{\"field\":\"assessedPropertiesForUsageCategory\"}}}},\"Total Application\":{\"terms\":{\"field\":\"state.keyword\"},\"aggs\":{\"sum\":{\"sum\":{\"field\":\"propertiesRegisteredForFinancialYear\"}}}}}}}}"
}
],
"chartType": "perform",
"valueType": "percentage",
"drillChart": "none",
"documentType": "_doc",
"action": "percentage",
"plotLabel": "NATIONAL_DSS_COMPLETION_RATE",
"order": "desc",
"limit": 3,
"isRoundOff": true,
"aggregationPaths": [
"Closed Application",
"Total Application"
],
"insight": {
},
"_comment": " Top Performing states for Completion rate"
},
"bottomPerformingStatesCompletionRatev3": {
"chartName": "NATIONAL_DSS_PT_BOTTOM_3_PERFORMING_STATES_COMPLETION_RATE",
"queries": [
{
"module": "PT",
"requestQueryMap": "{\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\"}",
"dateRefField": "date",
"indexName": "pt-national-dashboard",
"aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{}},\"aggs\":{\"Closed Application\":{\"terms\":{\"field\":\"state.keyword\"},\"aggs\":{\"sum\":{\"sum\":{\"field\":\"assessedPropertiesForUsageCategory\"}}}},\"Total Application\":{\"terms\":{\"field\":\"state.keyword\"},\"aggs\":{\"sum\":{\"sum\":{\"field\":\"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
...
| Code Block |
|---|
{
"name": "NATIONAL_DSS_PROPERTY_TAX_DASHBOARD",
"id": "national-propertyTax",
"isActive": "",
"style": "linear",
"visualizations": [
{
"row": 1,
"name": "NATIONAL_DSS_REVENUE",",
"vizArray": [
{
"id": 211,
"name": "NATIONAL_DSS_OVERVIEW",
"dimensions": {
"height": 350,
"width": 5
},
"vizArrayvizType": ["metric-collection",
{"noUnit": true,
"idisCollapsible": 211false,
"namelabel": "NATIONAL_DSS_OVERVIEW",
"dimensionscharts": [
{ {
"height": 350, "widthid": 5 "todaysCollectionv3",
},"name": "NATIONAL_DSS_TOTAL_COLLECTION_TODAY",
"vizTypecode": "metric-collection",
"noUnitchartType": true,"metric",
"filter": {"isCollapsibletitle": false"TODAY"},
"labelheaders": "NATIONAL_DSS_OVERVIEW",[]
"charts": [ },
{
"id": "todaysCollectionv3totalCollectionv3",
"name": "NATIONAL_PT_DSS_TOTAL_COLLECTION_TODAY",
"code": "",
"chartType": "metric",
"filter": {"title": "TODAY"},
"headers": []
},
{
"id": "totalCollectionv3targetCollectionv3",
"name": "NATIONAL_PT_DSS_TOTALTARGET_COLLECTION",
"code": "",
"chartType": "metric",
"filter": "",
"headers": []
},
{
"id": "targetCollectionv3targetAchievedv3",
"name": "NATIONAL_PT_DSS_TARGET_COLLECTIONACHIEVED",
"code": "",
"chartType": "metric",
"filter": "",
"headers": []
},
{
"id": "targetAchievedv3avgTaxCollectedPerProperty",
"name": "NATIONAL_PT_DSS_AVG_TARGETTAX_ACHIEVEDCOLLECTION",
"code": "",
"chartType": "metric",
"filter": "",
"headers": []
}
]
},
{
"id": 212,
"name": "NATIONAL_DSS_TOTAL_CUMULATIVE_COLLECTION",
"dimensions": {
"height": 350,
"width": 7
},
"vizType": "chart",
"noUnit": true,
"isCollapsible": false,
"charts": [
{
"id": "cumulativeCollectionv3",
"name": "Monthly",
"code": "",
"chartType": "line",
"filter": "",
"headers": []
}
]
}
]
},
{
"row": 2,
"name": "NATIONAL_DSS_REVENUE",
"vizArray": [
{
"id": 221,
"name": "NATIONAL_DSS_PT_COLLECTION_BY_USAGE_TYPE",
"dimensions": {
"height": 250,
"width": 4
},
"vizType": "chart",
"noUnit": true,
"isCollapsible": false,
"charts": [
{
"id": "collectionByUsageTypev3",
"name": "NATIONAL_DSS_PT_COLLECTION_BY_USAGE_TYPE",
"code": "",
"chartType": "donut",
"filter": "",
"headers": []
}
]
},
{
"id": 222,
"name": "NATIONAL_DSS_PT_TOP_3_PERFORMING_STATES_TARGET_ACHIEVEMENT",
"dimensions": {
"height": 250,
"width": 4
},
"vizType": "performing-metric",
"noUnit": false,
"isCollapsible": false,
"label": "",
"charts": [
{
"id": "topPerformingStatesv3",
"name": "NATIONAL_DSS_PT_TOP_3_PERFORMING_STATES_TARGET_ACHIEVEMENT",
"code": "",
"chartType": "bar",
"filter": "",
"headers": []
}
]
},
{
"id": 223,
"name": "NATIONAL_DSS_PT_BOTTOM_3_PERFORMING_STATES_TARGET_ACHIEVEMENT",
"dimensions": {
"height": 250,
"width": 4
},
"vizType": "performing-metric",
"noUnit": false,
"isCollapsible": false,
"charts": [
{
"id": "bottomPerformingStatesv3",
"name": "NATIONAL_DSS_PT_BOTTOM_3_PERFORMING_STATES_TARGET_ACHIEVEMENT",
"code": "",
"chartType": "bar",
"filter": "",
"headers": []
}
]
}
]
},
{
"row": 3,
"name": "NATIONAL_DSS_REVENUE",
"vizArray": [
{
"id": 231,
"name": "NATIONAL_DSS_PT_KEY_FY_INDICATORS",
"dimensions": {
"height": 350,
"width": 12
},
"vizType": "chart",
"noUnit": false,
"isCollapsible": false,
"charts": [
{
"id": "demandCollectionIndexStatesRevenuev3",
"name": "NATIONAL_DSS_PT_DEMAND_COLLECTION_STATES",
"code": "",
"chartType": "table",
"filter": "",
"headers": [],
"tabName": "Boundary"
},
{
"id": "demandCollectionIndexUsageRevenuev3",
"name": "NATIONAL_DSS_PT_DEMAND_COLLECTION_USAGETYPE",
"code": "",
"chartType": "table",
"filter": "",
"headers": [],
"tabName": "Usage"
}
]
}
]
},
{
"row": 4,
"name": "NATIONAL_DSS_REVENUE",
"vizArray": [
{
"id": 231,
"name": "NATIONAL_DSS_PT_TAX_HEAD",
"dimensions": {
"height": 350,
"width": 12
},
"vizType": "chart",
"label": "",
"noUnit": false,
"isCollapsible": true,
"charts": [
{
"id": "taxHeadsBreakupStatesRevenuev3",
"name": "NATIONAL_DSS_PT_TAX_HEAD_BREAKUP_REVENUE",
"code": "",
"chartType": "table",
"filter": "",
"headers": [],
"tabName": "Boundary"
},
{
"id": "taxHeadsBreakupUsagev3",
"name": "NATIONAL_DSS_PT_TAX_HEAD_BREAKUP_USAGE",
"code": "",
"chartType": "table",
"filter": "",
"headers": [],
"tabName": "Usage"
}
]
}
]
},
{
"row": 5,
"name": "NATIONAL_DSS_SERVICE",
"vizArray": [
{
"id": 241,
"name": "NATIONAL_DSS_OVERVIEW",
"dimensions": {
"height": 350,
"width": 5
},
"vizType": "metric-collection",
"isCollapsible": false,
"label": "NATIONAL_DSS_OVERVIEW",
"charts": [
{
"id": "totalApplicationsv3",
"name": "NATIONAL_DSS_PT_TOTAL_APPLICATIONS",
"code": "",
"chartType": "metric",
"filter": "",
"headers": []
},
{
"id": "totalPropertiesv3",
"name": "NATIONAL_DSS_PT_TOTAL_PROPERTIES",
"code": "",
"chartType": "metric",
"filter": "",
"headers": []
},
{
"id": "propertiesAssessedv3",
"name": "NATIONAL_DSS_PT_TOTAL_PROPERTIES_ASSESSED",
"code": "",
"chartType": "metric",
"filter": "",
"headers": []
},
{
"id": "totalAssessmentv3",
"name": "NATIONAL_DSS_PT_TOTAL_ASSESSMENTS",
"code": "",
"chartType": "metric",
"filter": "",
"headers": []
},
{
"id": "completionRateV3",
"name": "NATIONAL_DSS_PT_COMPLETION_RATE",
"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)
...
Total Cumulative Collection:
...