...
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\":{\"Fys\":{\"terms\":{\"field\":\"financialYear.keyword\",\"min_doc_count\":0,\"order\":{\"_term\":\"asc\"}},\"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", "dateRefFieldorder": "dateasc", "limit": 3, "indexNameisRoundOff": "pt-national-dashboard"true, "aggregationPaths": [ "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{}},\"aggs\":{\"ulb \":{\"terms\":{\"field\":\"ulb.keyword\",\"size\":200},\"aggs\":{\"Total\":{\"sum\":{\"field\":\"propertiesRegisteredForFinancialYear\"}}}}}}}}" "Closed Application", "Total }Application" ], "isMdmsEnabledinsight": false { }, "filterKeys_comment": [" Bottom Performing states for Completion {"keyrate": "ulb", "column": "Ulb"}, ], "propertiesByUsageTypev3": { "chartTypechartName": "xtableNATIONAL_DSS_PT_PROPERTIES_BY_USAGE_TYPE", "valueTypequeries": "number", "drillChart": "xptFyByWardv3", "drillFields": [ "ward", "" ], "plotLabel": "Ulb", "insight": { }, "_commentmodule": " 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\":{\"wardUsage Type\":{\"terms\":{\"field\":\"wardusageCategory.keyword\",\"size\":200},\"aggs\":{\"FysAssessed Properties\":{\"termssum\":{\"field\":\"financialYear.keyword\",\"min_doc_count\":0,\"order\":{\"_term\":\"asc\"}},\"aggs\":{\"sum\":{\"sum\":{\"field\":\"propertiesRegisteredForFinancialYear\"}}}}}}}}}}" }, {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": [ { "row": 1, "name": "NATIONAL_DSS_REVENUE", "vizArray": [ { "id": 211, "name": "NATIONAL_DSS_OVERVIEW", "dimensions": { "height": 350, "width": 5 }, "vizType": "metric-collection", "noUnit": true, "isCollapsible": false, "label": "NATIONAL_DSS_OVERVIEW", "charts": [ { "id": "todaysCollectionv3", "name": "NATIONAL_DSS_TOTAL_COLLECTION_TODAY", "code": "", "modulechartType": "PTmetric", "requestQueryMapfilter": "{\"state\title" : \"state.keyword\TODAY",\"ulb\" : \"ulb.keyword\"}",}, "headers": [] }, { "dateRefFieldid": "datetotalCollectionv3", "indexName "name": "pt-national-dashboard",NATIONAL_PT_DSS_TOTAL_COLLECTION", "aggrQuerycode": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{}},\"aggs\":{\"ward \":{\"terms\":{\"field\":\"ward.keyword\",\"size\":200},\"aggs\":{\"Total\":{\"sum\":{\"field\":\"propertiesRegisteredForFinancialYear\"}}}}}}}}", } ], "isMdmsEnabledchartType": false,"metric", "filterKeys": [ ],"filter": "", "chartType": "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"}, "name": "NATIONAL_DSS_TOTAL_COLLECTION", { "codeid": "", 212, "chartTypename": "metricNATIONAL_DSS_TOTAL_CUMULATIVE_COLLECTION", "filterdimensions": "", { "headersheight": []350, }, "width": 7 { }, "idvizType": "targetCollectionv3chart", "namenoUnit": "NATIONAL_DSS_TARGET_COLLECTION", true, "codeisCollapsible": "", false, "chartTypecharts": "metric",[ { "filter": "", "id": "cumulativeCollectionv3", "headers": [] },"name": "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, "name": "NATIONAL_DSS_PT_BOTTOM_3_PERFORMING_STATES_TARGET_ACHIEVEMENT", "dimensions": { "height": 250, ] "width": 4 } }, ] }, "vizType": "performing-metric", { "noUnitrow": false3, "isCollapsiblename": false, "NATIONAL_DSS_REVENUE", "chartsvizArray": [ { "id": "bottomPerformingStatesv3", 231, "name": "NATIONAL_DSS_PT_BOTTOMKEY_3_PERFORMING_STATES_TARGET_ACHIEVEMENT", FY_INDICATORS", "dimensions": { "codeheight": ""350, "chartTypewidth": "bar", 12 }, "filtervizType": "chart", "noUnit": false, "headersisCollapsible": [] false, "charts": [ } { ] }"id": "demandCollectionIndexStatesRevenuev3", ] }, "name": "NATIONAL_DSS_PT_DEMAND_COLLECTION_STATES", { "rowcode": 3"", "name "chartType": "NATIONAL_DSS_REVENUEtable", "vizArray": [ "filter": "", { "idheaders": 231[], "nametabName": "NATIONAL_DSS_PT_KEY_FY_INDICATORS",Boundary" "dimensions": {}, { "height": 350, "widthid": 12 "demandCollectionIndexUsageRevenuev3", },"name": "NATIONAL_DSS_PT_DEMAND_COLLECTION_USAGETYPE", "vizTypecode": "chart", "noUnitchartType": false,"table", "isCollapsiblefilter": false,"", "chartsheaders": [], "tabName": "Usage" { } "id": "demandCollectionIndexStatesRevenuev3", ] "name": "NATIONAL_DSS_PT_DEMAND_COLLECTION_STATES", } ] "code": "", }, { "chartTyperow": "table", 4, "filtername": "NATIONAL_DSS_REVENUE", "vizArray": [ "headers": [], { "tabNameid": "Boundary"231, }"name": "NATIONAL_DSS_PT_TAX_HEAD", "dimensions": { "idheight": "demandCollectionIndexUsageRevenuev3"350, "namewidth": "NATIONAL_DSS_PT_DEMAND_COLLECTION_USAGETYPE", 12 }, "codevizType": "chart", "chartTypelabel": "table", "filternoUnit": ""false, "headersisCollapsible": []true, "tabNamecharts": "Usage"[ }{ ] "id": "taxHeadsBreakupStatesRevenuev3", } ] "name": "NATIONAL_DSS_PT_TAX_HEAD_BREAKUP_REVENUE", }, { "code": "", "row": 4, "namechartType": "NATIONAL_DSS_REVENUEtable", "vizArray": [ "filter": "", { "idheaders": 231,[], "nametabName": "NATIONAL_DSS_PT_TAX_HEAD",Boundary" "dimensions": {}, { "height": 350, "widthid": 12 "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:
...