Page Comparison

"tradeLicenseTodaysCollectionv2": {
      "chartName": "DSS_TODAYS_COLLECTION",
      "queries": [
        {
          "module": "COMMON",
          "dateRefField": "date",
          "requestQueryMap": "{\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\"}",
          "indexName": "tl-national-dashboard",
          "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must\":[{\"range\":{\"date\":{\"gt\":\"now-1d\/d\",\"lte\":\"now\"}}}]}},\"aggs\":{\"Todays Collection\":{\"sum\":{\"field\":\"todaysCollectionForTradeType\"}}}}}}"
        }
      ],
      "chartType": "metric",
      "valueType": "Amount",
      "drillChart": "none",
      "documentType": "_doc",
      "action": "",
      "aggregationPaths": [
        "Todays Collection"
      ],
      "insight": {
        "chartResponseMap" : "tradeLicenseTodaysCollectionv2",
        "action" : "differenceOfNumbers",
        "upwardIndicator" : "positive",
        "downwardIndicator" : "negative",
        "textMessage" : "$indicator$value% than last $insightInterval",
        "colorCode" : "#228B22",
        "insightInterval" : "month"
      },
      "_comment": " "
    },
  
    "tradeLicenseTotalCollectionv2": {
      "chartName": "DSS_TOTAL_COLLECTION",
      "queries": [
        {
          "module": "COMMON",
          "dateRefField": "date",
          "requestQueryMap": "{\"state\" : \"state.keyword\",\"tenantId\" : \"ulb.keyword\"}",
          "indexName": "tl-national-dashboard",
          "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{}},\"aggs\":{\"Total Collection\":{\"sum\":{\"field\":\"todaysCollectionForTradeType\"}}}}}}"
        }
      ],
      "chartType": "metric",
      "valueType": "Amount",
      "drillChart": "none",
      "documentType": "_doc",
      "action": "",
      "aggregationPaths": [
        "Total Collection"
      ],
      "insight": {
        "chartResponseMap" : "tradeLicenseTotalCollectionv2",
        "action" : "differenceOfNumbers",
        "upwardIndicator" : "positive",
        "downwardIndicator" : "negative",
        "textMessage" : "$indicator$value% than last $insightInterval",
        "colorCode" : "#228B22",
        "insightInterval" : "year"
      },
      "_comment": " "
    },
  
    "totalLicensesIssuedv2": {
      "chartName": "DSS_TOTAL_LICENSES",
      "queries": [
        {
          "module": "COMMON",
          "dateRefField": "date",
          "requestQueryMap": "{\"state\" : \"state.keyword\",\"tenantId\" : \"ulb.keyword\"}",
          "indexName": "tl-national-dashboard",
          "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{}},\"aggs\":{\"Total Licenses\":{\"sum\":{\"field\":\"todaysTradeLicensesForStatus\"}}}}}}"
        }
      ],
      "chartType": "metric",
      "valueType": "number",
      "drillChart": "none",
      "documentType": "_doc",
      "action": "",
      "aggregationPaths": [
        "Total Licenses"
      ],
      "insight": {
        "chartResponseMap" : "totalLicensesIssuedv2",
        "action" : "differenceOfNumbers",
        "upwardIndicator" : "positive",
        "downwardIndicator" : "negative",
        "textMessage" : "$indicator$value% than last $insightInterval",
        "colorCode" : "#228B22",
        "insightInterval" : "year"
      }
    },

    "tlMonthlyCumulativeCollectionv2": {
      "chartName": "DSS_TL_MONTHLY_CUMULATIVE",
      "queries": [
        {
          "module": "COMMON",
          "dateRefField": "date",
          "requestQueryMap": "{\"state\" : \"state.keyword\",\"tenantId\" : \"ulb.keyword\"}",
          "indexName": "tl-national-dashboard",
          "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must_not\":[]}},\"aggs\":{\"Collections\":{\"date_histogram\":{\"field\":\"date\",\"interval\":\"month\"},\"aggs\":{\"Sum\":{\"sum\":{\"field\":\"todaysCollectionForTradeType\"}}}}}}}}"
        }
      ],
      "chartType": "line",
      "valueType": "amount",
      "action": "",
      "drillChart": "none",
      "documentType": "_doc",
      "aggregationPaths": [
        "Collections"
      ],
      "isCumulative": true,
      "interval": "month",
      "insight": {},
      "_comment": " "
    },
  
    "totalTransactionsv2": {
      "chartName": "DSS_TOTAL_TRANSACTIONS",
      "queries": [
        {
          "module": "COMMON",
          "dateRefField": "date",
          "requestQueryMap": "{\"state\" : \"state.keyword\",\"tenantId\" : \"ulb.keyword\"}",
          "indexName": "tl-national-dashboard",
          "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{}},\"aggs\":{\"Total Transactionsstate\":{\"sumterms\":{\"field\":\"transactionsstate.keyword\"}}}}}}"
        }
      ],
      "chartType": "metric",
      "valueType": "number",
      "drillChart": "none",
      "documentType": "_doc",
      "action": "",
      "aggregationPaths": [
        "Total Transactions"
      ],
      "insight": {
        "chartResponseMap" : "totalTransactionsv2",
        "action" : "differenceOfNumbers",
        "upwardIndicator" : "positive",
        "downwardIndicator" : "negative",
        "textMessage" : "$indicator$value% than last $insightInterval",
        "colorCode" : "#228B22",
        "insightInterval" : "year"
      }
    },
  
    "totalApplicationsv2": {
      "chartName": "DSS_TOTAL_APPLICATIONS",\"aggs\":{\"intermediateAggrULB\":{\"terms\":{\"field\":\"ulb.keyword\"},\"aggs\":{\"intermediateAggrWard\":{\"terms\":{\"field\":\"ward.keyword\"},\"aggs\":{\"days\":{\"terms\":{\"field\":\"date\"},\"aggs\":{\"applications\":{\"avg\":{\"field\":\"transactions\"}}}},\"wardapplications\":{\"sum_bucket\":{\"buckets_path\":\"days.applications\"}}}},\"ulbApplications\":{\"sum_bucket\":{\"buckets_path\":\"intermediateAggrWard.wardapplications\"}}}},\"stateApplications\":{\"sum_bucket\":{\"buckets_path\":\"intermediateAggrULB.ulbApplications\"}}}},\"Total Transactions\":{\"sum_bucket\":{\"buckets_path\":\"state.stateApplications\"}}}}}}"
        }
      ],
      "querieschartType": ["metric",
        {
  "valueType": "number",
       "moduledrillChart": "COMMONnone",
   
      "dateRefFielddocumentType": "date_doc",
   
      "requestQueryMapaction": "{\"state\" : \"state.keyword\",\"tenantId\" : \"ulb.keyword\"}",
",
      "aggregationPaths": [
        "Total Transactions"indexName": "tl-national-dashboard",
      ],
      "aggrQueryinsight": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{}},\"aggs\":{\"Total Applications\":{\"sum\":{\"field\":\"todaysApplications\"}}}}}}"{
        "chartResponseMap"  }
    : "totalTransactionsv2",
 ],       "chartTypeaction" : "metricdifferenceOfNumbers",
        "valueTypeupwardIndicator" : "numberpositive",
        "drillChartdownwardIndicator" : "nonenegative",
        "documentTypetextMessage" : "_doc$indicator$value% than last $insightInterval",
        "actioncolorCode" : "#228B22",
        "aggregationPathsinsightInterval" : ["year"
      }
 "Total Applications"  },
  
 ],       "insighttotalApplicationsv2": {

       "chartResponseMapchartName" : "totalApplicationsv2DSS_TOTAL_APPLICATIONS",
 
      "actionqueries" : "differenceOfNumbers",[
        "upwardIndicator"{
: "positive",         "downwardIndicatormodule" : "negativeCOMMON",
          "textMessagedateRefField" : "$indicator$value% than last $insightInterval",
        "colorCode" : "#228B22",
        "insightInterval" : "year"
      }
    },
  
    "tlCollectionByTradeTypev2": {
      "chartName": "DSS_TL_COLLECTION_BY_TRADE_TYPE",date",
          "queries": [
        {
          "module": "COMMON",
          "dateRefField": "date",
          "requestQueryMap": "{\"state\" : \"state.keyword\",\"tenantId\" : \"ulb.keyword\"}",
          "indexName": "tl-national-dashboard",
          "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must_not\":[]}},\"aggs\":{\"Trade Typestate\":{\"terms\":{\"field\":\"tradeTypestate.keyword\"},\"aggs\":{\"Total collectionintermediateAggrULB\":{\"sumterms\":{\"field\":\"todaysCollectionForTradeTypeulb.keyword\"}}}}}}}}"
        }
      ],
      "chartType": "pie",
      "valueType": "amount",
      "drillChart": "none",
      "documentType": "_doc",
      "action": "",
      "aggregationPaths": [
        "Trade Type"
      ],
      "insight": {,\"aggs\":{\"intermediateAggrWard\":{\"terms\":{\"field\":\"ward.keyword\"},\"aggs\":{\"days\":{\"terms\":{\"field\":\"date\"},\"aggs\":{\"applications\":{\"avg\":{\"field\":\"todaysApplications\"}}}},\"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\"}}}}}}"
        }
      }],
      "_commentchartType": "metric",
  "     }"valueType": "number",
       "tlTradeLicenseByStatusv2drillChart": {"none",
      "chartNamedocumentType": "DSS_TL_COLLECTION_BY_TRADE_TYPE_doc",
      "queriesaction": ["",
      "aggregationPaths": [
{        "Total Applications"
 "module": "COMMON",    ],
      "dateRefFieldinsight": "date",{
        "chartResponseMap" : "requestQueryMap": "{\"state\totalApplicationsv2",
        "action" : \"state.keyword\differenceOfNumbers",\"tenantId\
        "upwardIndicator" : \"ulb.keyword\"}"positive",

         "indexNamedownwardIndicator" : "tl-national-dashboardnegative",
 
        "aggrQuerytextMessage" : "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must_not\":[]}},\"aggs\":{\"Status\":{\"terms\":{\"field\":\"status.keyword\"},\"aggs\":{\"Total Licenses\":{\"sum\":{\"field\":\"todaysTradeLicensesForStatus\"}}}}}}}}"
$indicator$value% than last $insightInterval",
        "colorCode" : "#228B22",
        "insightInterval" : "year"
      }
    },
  
    "tlCollectionByTradeTypev2": {
      "chartName": "DSS_TL_COLLECTION_BY_TRADE_TYPE",
      "queries": [
       }   {
   ],       "chartTypemodule": "pieCOMMON",
          "valueTypedateRefField": "numberdate",
          "drillChartrequestQueryMap": "{\"none",
      "documentType"state\" : "_doc",
      "action": "\"state.keyword\",\"tenantId\" : \"ulb.keyword\"}",
      "aggregationPaths": [         "Status""indexName": "tl-national-dashboard",
      ],       "insight"aggrQuery": "{\"aggs\": {
        
      }{\"AGGR\":{\"filter\":{\"bool\":{\"must_not\":[]}},\"aggs\":{\"Trade Type\":{\"terms\":{\"field\":\"tradeType.keyword\"},\"aggs\":{\"Total collection\":{\"sum\":{\"field\":\"todaysCollectionForTradeType\"}}}}}}}}"
        }
      ],
      "_commentchartType": "pie",
 "      }"valueType": "amount",
      "tlTargetAchieveddrillChart": {"none",
      "chartNamedocumentType": "DSS_TARGET_ACHIEVEDdoc",
      "queriesaction": ["",
      "aggregationPaths": [
{        "Trade Type"
 "module": "COMMON",    ],
      "requestQueryMapinsight": "{\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\"}{
        
      },
      "_comment": " "
    },
  
    "tlTradeLicenseByStatusv2": {
      "chartName": "DSS_TL_COLLECTION_BY_TRADE_TYPE",
      "queries": [
        {
          "module": "COMMON",
          "dateRefField": "date",
          "requestQueryMap": "{\"state\" : "indexName": "master-national-dashboard\"state.keyword\",\"tenantId\" : \"ulb.keyword\"}",
          "indexName": "tl-national-dashboard",
          "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"termbool\":{\"module.keywordmust_not\":[]}},\"TL\"}},\"aggsaggs\":{\"Target CollectionStatus\":{\"terms\":{\"field\":\"state.keyword\",\"size\":\"200\",\"order\":{\"Sum\":\"descstatus.keyword\"}},\"aggs\":{\"SumTotal Licenses\":{\"sum\":{\"field\":\"budgetProposedForMunicipalCorporationtodaysTradeLicensesForStatus\"}}}}}}}}"
        },
      ],
   {   "chartType": "pie",
      "modulevalueType": "COMMONnumber",
      "drillChart": "none",
      "dateRefFielddocumentType": "date_doc",
  
       "requestQueryMapaction": "{\"state\" : \"state.keyword\",\"tenantId\" : \"ulb.keyword\"}",
 ",
      "aggregationPaths": [
        "indexNameStatus": "tl-national-dashboard",
      ],
     "aggrQuery": "{\"aggs\insight":{\"Total Collection\":{\"sum\":{\"field\":\"todaysCollectionForTradeType\"}}}}"
        }
         ]},
      "chartType_comment": "metric ",
      "valueType": "percentage",
},

    "drillCharttlTargetAchieved": "none",{
      "documentTypechartName": "DSS_TARGET_docACHIEVED",
      "actionqueries": "percentage",
  [
   "aggregationPaths": [    {
    "Total Collection",        "module": "Target Collection"
 COMMON",
    ],       "insightrequestQueryMap": {
        "chartResponseMap"{\"state\" : \"tlTargetAchievedstate.keyword\",
        "action\"ulb\" : "differenceOfNumbers\"ulb.keyword\"}",
          "upwardIndicatordateRefField" : "positivedate",
          "downwardIndicatorindexName" : "negativemaster-national-dashboard",

       "textMessage" : "$indicator$value% than
last $insightInterval",         "colorCodeaggrQuery" : "{\"#228B22",
        "insightInterval" : "year"
      },
      "_comment": " aggs\":{\"AGGR\":{\"filter\":{\"term\":{\"module.keyword\":\"TL\"}},\"aggs\":{\"Target Collection\":{\"sum\":{\"field\":\"budgetProposedForMunicipalCorporation\"}}}}}}"
    },    },
   "tlTargetCollection": {    {
  "chartName": "DSS_TARGET_COLLECTION",       "queriesmodule": [
 "COMMON",
      {           "module"dateRefField": "COMMONdate",
          "requestQueryMap": "{\"modulestate\" : \"modulestate.keyword\", \"tenantIdulb\" : \"ulb.keyword\"}",
          "dateRefField": "",
          "indexName": "mastertl-national-dashboard",
          "aggrQuery": "{\"aggs\":{\"TargetTotal Collection\":{\"sum\":{\"field\":\"budgetProposedForMunicipalCorporationtodaysCollectionForTradeType\"}}}}"
        }
  
      ],
      "chartType": "metric",
      "valueType": "amountpercentage",
      "actiondrillChart": "none",
      "drillChartdocumentType": "none_doc",
      "documentTypeaction": "_docpercentage",
      "aggregationPathsisRoundOff": [ true,
      "preActionTheory":{
        "Target Collection":"repsonseToDifferenceOfDates"
      ]},
      "isDayUnitaggregationPaths": true,[
      "postAggregationTheory" : "repsonseToDifferenceOfDatesTotal Collection",
        "insight": {Target Collection"
      }],
      "_commentinsight": "{
"     },   
   "chartResponseMap" : "tlTopPerformingUlbstlTargetAchieved":,
 {       "chartNameaction" : "NATIONAL_DSS_TOP_PERFORMING_STATESdifferenceOfNumbers",
        "queriesupwardIndicator" : ["positive",
        {"downwardIndicator" : "negative",
        "moduletextMessage" : "COMMON$indicator$value% than last $insightInterval",
        "colorCode" : "requestQueryMap": "{\r\n  \"module\" : \"module.keyword\", \n\"tenantId\#228B22",
        "insightInterval" : \"ulb.keyword\"}"year",
 
        "dateRefFieldisRoundOff": "", true
      },
      "indexName_comment": "master-national-dashboard", "
    },
  
    "aggrQuerytlTargetCollection": "{\"aggs\":{\"AGGR\":{\"filter\":{\"term\":{\"module.keyword\":\"TL\"}},\"aggs\":{\"Target Collection\":{\"terms\":{\"field\":\"state.keyword\",\"order\":{\"Sum\":\"desc\"}},\"aggs\":{\"Sum\":{\"sum\":{\"field\":\"budgetProposedForMunicipalCorporation\"}}}}}}}}"
        },
 {
      "chartName": "DSS_TARGET_COLLECTION",
      "queries": [
        {
          "module": "COMMON",
          "dateRefField": "date",
          "requestQueryMap": "{\"state\" : \"state.keyword\", \"ulb\" : \"ulb.keyword\"}",
          "dateRefField": "date",
          "indexName": "tlmaster-national-dashboard",
          "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"boolterm\":{\"must_notmodule.keyword\":[]\"TL\"}},\"aggs\":{\"Total Collection\":{\"terms\":{\"field\":\"state.keyword\",\"order\":{\"Sum\":\"desc\"}},\"aggs\":{\"SumTarget Collection\":{\"sum\":{\"field\":\"todaysCollectionForTradeTypebudgetProposedForMunicipalCorporation\"}}}}}}}}"
        }
      ],
      "chartType": "performmetric",
      "valueType": "percentageamount",
      "drillChartaction": "none",
      "documentTypedrillChart": "_docnone",
      "actiondocumentType": "percentage_doc",
      "plotLabelaggregationPaths": "DSS_TARGET_ACHIEVED", [
        "order": "desc",Target Collection"
      "limit": 3],
      "aggregationPathsisDayUnit": [true,
      "postAggregationTheory" : "Total Collection","Target Collection"
      ]repsonseToDifferenceOfDates",
      "insight": {
      },
      "_comment": " Top Performing Ulbs for target achieved"
    },
  
    "tlBottomPerformingUlbstlTopPerformingUlbs": {
      "chartName": "NATIONAL_DSS_BOTTOMTOP_PERFORMING_STATES",
      "queries": [
        {
          "module": "COMMON",
          "requestQueryMap": "{\r\n  \"module\" : \"module.keyword\", \n\"tenantIdulb\" : \"ulb.keyword\"}",
          "dateRefField": "",
          "indexName": "master-national-dashboard",
          "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"term\":{\"module.keyword\":\"TL\"}},\"aggs\":{\"Target Collection\":{\"terms\":{\"field\":\"state.keyword\",\"order\":{\"Sum\":\"ascdesc\"}},\"aggs\":{\"Sum\":{\"sum\":{\"field\":\"budgetProposedForMunicipalCorporation\"}}}}}}}}"
        },
        {
          "module": "COMMON",
          "dateRefField": "date",
          "requestQueryMap": "{\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\"}",
          "indexName": "tl-national-dashboard",
          "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must_not\":[]}},\"aggs\":{\"Total Collection\":{\"terms\":{\"field\":\"state.keyword\",\"order\":{\"Sum\":\"ascdesc\"}},\"aggs\":{\"Sum\":{\"sum\":{\"field\":\"todaysCollectionForTradeType\"}}}}}}}}"
        }
      ],
      "chartType": "perform",
      "valueType": "percentage",
      "drillChart": "none",
      "documentType": "_doc",
      "action": "percentage",
      "isRoundOff": true,
      "plotLabel": "DSS_TARGET_ACHIEVED",
      "order": "ascdesc",
      "limit": 3,
      "aggregationPaths": [
        "Total Collection","Target Collection"
      ],
      "insight": {
      },
      "_comment": " BottomTop Performing Ulbs for target achieved"
    },
  
    "tlactiveUlbstlBottomPerformingUlbs": {
      "chartName": "NATIONAL_DSS_TLBOTTOM_TOTALPERFORMING_ACTIVE_ULBSSTATES",
      "queries": [
        {
        {           "module": "module": "COMMON",
          "dateRefFieldrequestQueryMap": "date",
          "requestQueryMap": "{\"state{\r\n  \"module\" : \"statemodule.keyword\", \n\"ulb\" : \"ulb.keyword\"}",
          "dateRefField": "",
          "indexName": "tlmaster-national-dashboard",
          "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"boolterm\":{\"must_notmodule.keyword\":[]\"TL\"}},\"aggs\":{\"ActiveTarget ULBsCollection\":{\"cardinalityterms\":{\"field\":\"ulbstate.keyword\",\"order\":{\"Sum\":\"asc\"}},\"aggs\":{\"Sum\":{\"sum\":{\"field\":\"budgetProposedForMunicipalCorporation\"}}}}}}}}"
        },
      ],   {
   "chartType": "metric",       "valueTypemodule": "numberCOMMON",
          "actiondateRefField": "date",
      "documentType": "_doc",       "drillChartrequestQueryMap": "none",
      "aggregationPaths": [
        "Active ULBs"
  {\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\"}",
   ],       "insightindexName": {
        "chartResponseMaptl-national-dashboard",
: "tlactiveUlbs",         "actionaggrQuery" : "{\"differenceOfNumbers",
        "upwardIndicator" : "positive",
        "downwardIndicator" : "negative",
        "textMessage" : "$indicator$value% than last $insightInterval",
        "colorCode" : "#228B22",aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must_not\":[]}},\"aggs\":{\"Total Collection\":{\"terms\":{\"field\":\"state.keyword\",\"order\":{\"Sum\":\"asc\"}},\"aggs\":{\"Sum\":{\"sum\":{\"field\":\"todaysCollectionForTradeType\"}}}}}}}}"
        "insightInterval" : "month"}
      }],
      "_commentchartType": "perform",
total ULBs count"     },"valueType": "percentage",
      "licenseIssuedBoundaryRevenuev3drillChart": {"none",
      "chartNamedocumentType": "DSS_TL_DEMAND_COLLECTION_BOUNDARY_doc",
      "queriesaction": "percentage",
  [    "isRoundOff": true,
   {   "plotLabel": "DSS_TARGET_ACHIEVED",
      "moduleorder": "COMMONasc",
      "limit": 3,
   "requestQueryMap": "{\"stateId\" : \"state.keyword\"}",
aggregationPaths": [
        "Total Collection"dateRefField,":Target "date",Collection"
      ],
      "indexNameinsight": {
      },
      "_comment": "tl-national-dashboard", Bottom Performing Ulbs for target achieved"
    },
  
    "aggrQuerytlactiveUlbs": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must_not\":[]}},\"aggs\":{\"States\":{\"terms\":{\"field\":{
      "chartName": "DSS_TL_TOTAL_ACTIVE_ULBS",
      "queries": [
        
        {
          "module": "COMMON",
          "dateRefField": "date",
          "requestQueryMap": "{\"state\" : \"state.keyword\"},\"aggsulb\" :{\"Total Collection\":{\"sum\":{\"field\":\"todaysCollectionForTradeType\"}},\"Transactionsulb.keyword\"}",
          "indexName": "tl-national-dashboard",
          "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"sumbool\":{\"fieldmust_not\":[]}},\"transactionsaggs\"}},:{\"Total_Licence_IssuedActive ULBs\":{\"sumcardinality\":{\"field\":\"todaysTradeLicensesForStatusulb.keyword\"}}}}}}}}"
        },
      ],
   {   "chartType": "metric",
      "modulevalueType": "COMMONnumber",
      "action": "",
      "requestQueryMapdocumentType": "{\"stateId\" : \"state.keyword\"}",
 "_doc",
      "drillChart": "none",
      "aggregationPaths": [
        "dateRefField": "",Active ULBs"
      ],
      "indexNameinsight": "master-national-dashboard",{
          "aggrQuerychartResponseMap" : "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must_not\":[]}},\"aggs\":{\"States\":{\"terms\":{\"field\":\"state.keyword\"},\"aggs\":{\"Target_Collection\":{\"sum\":{\"field\":\"budgetProposedForMunicipalCorporation\"}}}}}}}}"tlactiveUlbs",
        }"action" : "differenceOfNumbers",
        "upwardIndicator" :  "positive",
 ],       "filterKeysdownwardIndicator" : ["negative",
        {"key": "stateId", "column""textMessage" : "States"}$indicator$value% than last $insightInterval",
   ],
      "postAggregationTheorycolorCode" : "repsonseToDifferenceOfDates#228B22",
        "chartTypeinsightInterval" : "xtablemonth",
        "valueTypeisRoundOff": "number",true
      "drillChart": "licenseIssuedTenantRevenuev3"},
      "documentType_comment": "_doc", total ULBs count"
   "action": "",
      "plotLabel": "States", },
    
    "aggregationPathslicenseIssuedBoundaryRevenuev3": [
 {
      "Total Collection",
        "Transactions",
        "Total_Licence_Issued",
        "Target_Collection"
      ]chartName": "DSS_TL_DEMAND_COLLECTION_BOUNDARY",
      "pathDataTypeMappingqueries": [
        {
          "Total Collectionmodule": "amount"
        },
        {COMMON",
          "TransactionsrequestQueryMap": "{\"numberstate\"         },
        {: \"state.keyword\"}",
          "Total_Licence_IssueddateRefField": "numberdate",
        },  "indexName": "tl-national-dashboard",
     {           "Target_Collection": "amount"
        }
      ],
      "computedFields": [
        {
          "postAggregationTheory" : "repsonseToDifferenceOfDates",
          "actionName": "PercentageComputedField",
          "fields" : ["Total Collection", "Target_Collection"],
          "newField" : "Target_Achieved",
  "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must_not\":[]}},\"aggs\":{\"States\":{\"terms\":{\"field\":\"state.keyword\"},\"aggs\":{\"TL_Total_Collection\":{\"sum\":{\"field\":\"todaysCollectionForTradeType\"}},\"Total_Licence_Issued\":{\"sum\":{\"field\":\"todaysTradeLicensesForStatus\"}},\"intermediateAggrULB\":{\"terms\":{\"field\":\"ulb.keyword\"},\"aggs\":{\"intermediateAggrWard\":{\"terms\":{\"field\":\"ward.keyword\"},\"aggs\":{\"days\":{\"terms\":{\"field\":\"date\"},\"aggs\":{\"applications\":{\"avg\":{\"field\":\"transactions\"}}}},\"wardapplications\":{\"sum_bucket\":{\"buckets_path\":\"days.applications\"}}}},\"ulbApplications\":{\"sum_bucket\":{\"buckets_path\":\"intermediateAggrWard.wardapplications\"}}}},\"Transactions\":{\"sum_bucket\":{\"buckets_path\":\"intermediateAggrULB.ulbApplications\"}}}}}}}}"
        },
        {
          "module": "COMMON",
          "requestQueryMap": "{\"state\" : \"state.keyword\"}",
          "dateRefField": "date",
          "indexName": "master-national-dashboard",
          "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must_not\":[],\"must\":[{\"term\":{\"module.keyword\":\"TL\"}}]}},\"aggs\":{\"States\":{\"terms\":{\"field\":\"state.keyword\"},\"aggs\":{\"Target_Collection\":{\"sum\":{\"field\":\"budgetProposedForMunicipalCorporation\"}}}}}}}}"
        }
        
      ],
      "filterKeys": [
        {"key": "state", "column": "States"}
      ],
      "postAggregationTheory" : "repsonseToDifferenceOfDates",
      "chartType": "xtable",
      "valueType": "number",
      "drillChart": "licenseIssuedTenantRevenuev3",
      "documentType": "_doc",
      "action": "",
      "plotLabel": "States",
      "aggregationPaths": [
        "TL_Total_Collection",
        "Transactions",
        "Total_Licence_Issued",
        "Target_Collection"
      ],
      "pathDataTypeMapping": [
        {
          "TL_Total_Collection": "amount"
        },
        {
          "Target_Collection": "amount"
        },
        {
          "Transactions": "number"
        },
        {
          "Total_Licence_Issued": "number"
        },
        {
          "TL_Target_Collection": "amount"
        }
      ],
      "computedFields": [
       {
          "postAggregationTheory" : "repsonseToDifferenceOfDates",
          "actionName": "AdditiveComputedField",
          "fields" : ["Target_Collection"],
          "newField" : "TL_Target_Collection",
          "_comments": "fields are field names picked from its aggregation query to use post aggregation newField value with given new field name  "
        },
        {
          "postAggregationTheory" : "",
          "actionName": "PercentageComputedField",
          "fields" : ["TL_Total_Collection", "TL_Target_Collection"],
          "newField" : "TL_Target_Achieved",
          "isRoundOff": true,
          "_comments": "fields are field names picked from its aggregation query to use post aggregation newField value with given new field name  "
        }
        
      ],
      "excludedColumns":["Target_Collection"],
      "insight": {
      },
      "_comment": ""
    },
  
    "licenseIssuedDDDRRevenuev3": {
      "chartName": "DSS_TL_DEMAND_COLLECTION_BOUNDARY",
      "queries": [
        {
          "module": "COMMON",
          "requestQueryMap": "{\"state\" : \"state.keyword\", \"regionId\" : \"region.keyword\"}",
          "dateRefField": "date",
          "indexName": "tl-national-dashboard",
          "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must_not\":[]}},\"aggs\":{\"Regions\":{\"terms\":{\"field\":\"region.keyword\"},\"aggs\":{\"Total Collection\":{\"sum\":{\"field\":\"todaysCollectionForTradeType\"}},\"Transactions\":{\"sum\":{\"field\":\"transactions\"}},\"Total Licence Issued\":{\"sum\":{\"field\":\"todaysTradeLicensesForStatus\"}}}}}}}}"
        },
        {
          "module": "COMMON",
          "requestQueryMap": "{\"state\" : \"state.keyword\", \"regionId\" : \"region.keyword\"}",
          "dateRefField": "",
          "indexName": "master-national-dashboard",
          "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must_not\":[]}},\"aggs\":{\"Regions\":{\"terms\":{\"field\":\"region.keyword\"},\"aggs\":{\"Target Collection\":{\"sum\":{\"field\":\"budgetProposedForMunicipalCorporation\"}}}}}}}}"
        }
      ],
      "filterKeys": [
        {"key": "regionId", "column": "Regions"}
      ],
      "postAggregationTheory" : "repsonseToDifferenceOfDates",
      "chartType": "xtable",
      "valueType": "number",
      "drillChart": "licenseIssuedTenantRevenuev3",
      "documentType": "_doc",
      "action": "",
      "plotLabel": "Regions",
      "aggregationPaths": [
        "Total Collection",
        "Transactions",
        "Total Licence Issued",
        "Target Collection"
      ],
      "pathDataTypeMapping": [
        {
          "Total Collection": "amount"
        },
        {
          "Transactions": "number"
        },
        {
          "Total Licence Issued": "number"
        },
        {
          "Target Collection": "amount"
        }
      ],
      "computedFields": [
        {
          "postAggregationTheory" : "repsonseToDifferenceOfDates",
          "actionName": "PercentageComputedField",
          "fields" : ["Total Collection", "Target Collection"],
          "newField" : "Target Achieved",
          "_comments": "fields are field names picked from its aggregation query to use post aggregation newField value with given new field name  "
        }
        
      ],
      "insight": {
      },
      "_comment": ""
    },
  
    "licenseIssuedDDDRRevenuev3licenseIssuedTenantRevenuev3": {
      "chartName": "DSS_TL_DEMAND_COLLECTION_BOUNDARY",
      "queries": [
        {
          "module": "COMMON",
          "requestQueryMap": "{\"stateIdstate\" : \"state.keyword\", \"regionId\" : \"region.keyword\", \"ulb\" : \"ulb.keyword\"}",
          "dateRefField": "date",
          "indexName": "tl-national-dashboard",
           "dateRefField": "date",
          "indexName": "tl-national-dashboard",
          "aggrQuery": "{\"aggs"aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must_not\":[]}},\"aggs\":{\"Tenants\":{\"terms\":{\"field\":\"ulb.keyword\"},\"aggs\":{\"TL_Total_Collection\":{\"sum\":{\"field\":\"todaysCollectionForTradeType\"}},\"Total_Licence_Issued\":{\"sum\":{\"AGGRfield\":{\"todaysTradeLicensesForStatus\"}},\"filterintermediateAggrWard\":{\"boolterms\":{\"must_notfield\":[]}}\"ward.keyword\"},\"aggs\":{\"Regionsdays\":{\"terms\":{\"field\":\"region.keyworddate\"},\"aggs\":{\"Total Collectionapplications\":{\"sumavg\":{\"field\":\"todaysCollectionForTradeTypetransactions\"}}}},\"Transactionswardapplications\":{\"sum_bucket\":{\"fieldbuckets_path\":\"transactionsdays.applications\"}}}},\"Total Licence IssuedTransactions\":{\"sum_bucket\":{\"fieldbuckets_path\":\"todaysTradeLicensesForStatusintermediateAggrWard.wardapplications\"}}}}}}}}"
        },
        {
          "module": "COMMON",
          "requestQueryMap": "{\"stateIdstate\" : \"state.keyword\", \"regionId\" : \"region.keyword\", \"ulb\" : \"ulb.keyword\"}",
          "dateRefField": "date",
          "indexName": "master-national-dashboard",
          "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must_not\":[\":[],\"must\":[{\"term\":{\"module.keyword\":\"TL\"}}]}},\"aggs\":{\"RegionsTenants\":{\"terms\":{\"field\":\"regionulb.keyword\"},\"aggs\":{\"Target _Collection\":{\"sum\":{\"field\":\"budgetProposedForMunicipalCorporation\"}}}}}}}}"
        }
      ],
      "filterKeys": [
        {"key": "regionIdulb", "column": "RegionsULB"}
      ],
      "postAggregationTheory" : "repsonseToDifferenceOfDates",
      "chartType": "xtable",
      "valueType": "number",
      "drillChart": "licenseIssuedTenantRevenuev3licenseIssuedWardRevenuev3",
      "documentType": "_doc",",
      "action": "",
      "plotLabel": "ULB",
      "aggregationPaths": [
        "TL_Total_Collection",
        "Transactions",
        "Total_Licence_Issued",
        "Target_Collection"
      ],
      "pathDataTypeMapping": [
        {
          "TL_Total_Collection": "amount"
        },
        {
  "action": "",       "plotLabelTarget_Collection": "Regionsamount",
        "aggregationPaths": [},
        {
"Total Collection",         "Transactions",": "number"
        },
  "Total Licence Issued",    {
    "Target Collection"     "Total_Licence_Issued": "number"
],       "pathDataTypeMapping": [ },
        {
          "Total TL_Target_Collection": "amount"
        },
        {
  ],
       "TransactionscomputedFields": "number"[
       {
 },         {"postAggregationTheory" : "repsonseToDifferenceOfDates",
        "Total Licence Issued"actionName": "numberAdditiveComputedField",
          "fields"  },: ["Target_Collection"],
          "newField"  {: "TL_Target_Collection",
          "Target Collection_comments": "amount"
        }
      ],fields are field names picked from its aggregation query to use post aggregation newField value with given new field name  "
      "computedFields": [  },
        {
          "postAggregationTheory" : "repsonseToDifferenceOfDates",
          "actionName": "PercentageComputedField",
          "fields" : ["TL_Total _Collection", "TL_Target _Collection"],
          "newField" : "TL_Target Achieved"_Achieved",
          "isRoundOff": true,
          "_comments": "fields are field names picked from its aggregation query to use post aggregation newField value with given new field name  "
        }
        
      ],
      "excludedColumns":["Target_Collection"],
      "insight": {
      },
      "_comment": ""
    },
  
    "licenseIssuedTenantRevenuev3licenseIssuedWardRevenuev3": {
      "chartName": "DSS_TL_DEMAND_COLLECTION_BOUNDARY",
      "queries": [
        {
          "module": "COMMON",
          "requestQueryMap": "{\"stateIdstate\" : \"state.keyword\", \"regionId\" : \"region.keyword\", \"tenantIdulb\" : \"ulb.keyword\",\"ward\" : \"ward.keyword\" }",
          "dateRefField": "date",
          "indexName": "tl-national-dashboard",
          "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must_not\":[]}},\"aggs\":{\"TenantsWards\":{\"terms\":{\"field\":\"ulbward.keyword\"},\"aggs\":{\"TL_Total _Collection\":{\"sum\":{\"field\":\"todaysCollectionForTradeType\"}},\"TransactionsTotal_Licence_Issued\":{\"sum\":{\"field\":\"todaysTradeLicensesForStatus\"}},\"days\":{\"terms\":{\"field\":\"date\"},\"aggs\":{\"applications\":{\"avg\":{\"field\":\"transactions\"}}}},\"Total_Licence_IssuedTransactions\":{\"sum_bucket\":{\"fieldbuckets_path\":\"todaysTradeLicensesForStatusdays.applications\"}}}}}}}}"
        },
        {
          "module": "COMMON",
          "requestQueryMap": "{\"stateId"{\"state\" : \"state.keyword\", \"regionId\" : \"stateregion.keyword\", \"regionIdulb\" : \"regionulb.keyword\", \"tenantIdward\" : \"ulbward.keyword\"}",
          "dateRefField": "date",
          "indexName": "master-national-dashboard",
          "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must_not\":[],\"must\":[{\"term\":{\"module.keyword\":\"TL\"}}]}},\"aggs\":{\"TenantsWards\":{\"terms\":{\"field\":\"ulbward.keyword\"},\"aggs\":{\"Target_Collection\":{\"sum\":{\"field\":\"budgetProposedForMunicipalCorporation\"}}}}}}}}"
        }
      ],
      "filterKeys": [
        {"key": "tenantIdward", "column": "TenantsWards"}
      ],
      "postAggregationTheory" : "repsonseToDifferenceOfDates",
      "chartType": "xtable",
      "valueType": "number",
      "drillChart": "licenseIssuedWardRevenuev3none",
      "documentType": "_doc",
      "action": "",
      "plotLabel": "TenantsWards",
      "aggregationPaths": [
        "TL_Total _Collection",
        "Transactions",
        "Total_Licence_Issued",
        "Target_Collection"
      ],
      "pathDataTypeMapping": [
        {
          "pathDataTypeMapping": ["TL_Total_Collection": "amount"
        },
        {
          "Target_Collection": "amount"
        },
        {
          "Transactions": "number"
        },
        {
          "Total Collection_Licence_Issued": "amountnumber"
        },
        {
          "TransactionsTL_Target_Collection": "numberamount"
        }
      ],
      "computedFields": [
       {
          "Total_Licence_IssuedpostAggregationTheory" : "numberrepsonseToDifferenceOfDates",
           },"actionName": "AdditiveComputedField",
          "fields" : ["Target_Collection"],
 {         "newField" : "TL_Target_Collection",
          "_comments": "amount"
        }
      ],fields are field names picked from its aggregation query to use post aggregation newField value with given new field name  "
       "computedFields": [ },
        {
          "postAggregationTheory" : "repsonseToDifferenceOfDates",
          "actionName": "PercentageComputedField",
          "fields" : ["TL_Total _Collection", "TL_Target_Collection"],
          "newField" : "TL_Target_Achieved",
          "isRoundOff": true,
          "_comments": "fields are field names picked from its aggregation query to use post aggregation newField value with given new field name  "
        }
        
      ],
      "excludedColumns":["Target_Collection"],
      "insight": {
      },
      "_comment": ""
    },
  
    "licenseIssuedWardRevenuev3licenceTaxHeadsBreakupState": {
      "chartName": "DSS_TL_TAX_DEMANDHEAD_COLLECTIONBREAKUP_BOUNDARY",
      "queries": [
        {
          "module": "COMMON",
          "requestQueryMap": "{\"stateIdstate\" : \"state.keyword\", \"regionId\" : \"region.keyword\", \"tenantId\" : \"ulb.keyword\",\"ward\" : \"ward.keyword\" }",
          "dateRefField": "date",
          "indexName": "tl-national-dashboard",
          "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must_not\":[]}},\"aggs\":{\"WardsStates\":{\"terms\":{\"field\":\"wardstate.keyword\"},\"aggs\":{\"Total CollectionintermediateAggrULB\":{\"sumterms\":{\"field\":\"todaysCollectionForTradeTypeulb.keyword\"},\"aggs\":{\"intermediateAggrWard\":{\"terms\":{\"field\":\"ward.keyword\"},\"aggs\":{\"Transactionsdays\":{\"sumterms\":{\"field\":\"transactionsdate\"}},\"aggs\":{\"Total_Licence_IssuedapplicationsTax\":{\"sumavg\":{\"field\":\"todaysTradeLicensesForStatustlTax\"}}}}}}}}"
        },
        {
          "module": "COMMON",
          "requestQueryMap": "{\"stateId\" : \"state.keyword\", \"regionId\" : \"region.keyword\", \"tenantId\" : \"ulb.keyword\",\"ward\" : \"ward.keyword\"}",
          "dateRefField": "",
          "indexName": "master-national-dashboard",
          "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must_not\":[]}},\"aggs\":{\"Wards\":{\"terms\":{\"field\":\"ward.keyword\"},\"aggs\":{\"Target_Collection,\"applicationsPenalty\":{\"avg\":{\"field\":\"adhocPenalty\"}},\"applicationsRebate\":{\"avg\":{\"field\":\"adhocRebate\"}}}},\"wardapplicationsTax\":{\"sum_bucket\":{\"buckets_path\":\"days.applicationsTax\"}},\"wardapplicationsPenalty\":{\"sum_bucket\":{\"buckets_path\":\"days.applicationsPenalty\"}},\"wardapplicationsRebate\":{\"sum_bucket\":{\"buckets_path\":\"days.applicationsRebate\"}}}},\"ulbApplicationsTax\":{\"sum_bucket\":{\"buckets_path\":\"intermediateAggrWard.wardapplicationsTax\"}},\"ulbApplicationsPenalty\":{\"sum_bucket\":{\"buckets_path\":\"intermediateAggrWard.wardapplicationsPenalty\"}},\"ulbApplicationsRebate\":{\"sum_bucket\":{\"buckets_path\":\"intermediateAggrWard.wardapplicationsRebate\"}}}},\"TL_Tax\":{\"sum_bucket\":{\"fieldbuckets_path\":\"budgetProposedForMunicipalCorporationintermediateAggrULB.ulbApplicationsTax\"}}}}}}}}"
        }
      ],
      "filterKeys": [
        {"key": "ward", "column": "Wards"}
      ],
      "postAggregationTheory" : "repsonseToDifferenceOfDates",
      "chartType": "xtable",
      "valueType": "number",
      "drillChart": "none",
      "documentType": "_doc",
      "action": "",
      "plotLabel": "Wards",
      "aggregationPaths": [
        "Total Collection",
        "Transactions",
        "Total_Licence_Issued",,\"Adhoc_Penalty\":{\"sum_bucket\":{\"buckets_path\":\"intermediateAggrULB.ulbApplicationsPenalty\"}},\"Adhoc_Rebate\":{\"sum_bucket\":{\"buckets_path\":\"intermediateAggrULB.ulbApplicationsRebate\"}},\"Total_Amount\":{\"bucket_script\":{\"buckets_path\":{\"Adhoc_Rebate\":\"Adhoc_Rebate\",\"TL_Tax\":\"TL_Tax\",\"Adhoc_Penalty\":\"Adhoc_Penalty\"},\"script\":{\"source\":\" params.TL_Tax + params.Adhoc_Penalty - params.Adhoc_Rebate\"}}}}}}}}}"
        "Target_Collection"}
      ],
      "pathDataTypeMappingfilterKeys": [
        {
          "Total Collection"key": "state", "column": "amountStates"}
      ],
  },    "chartType": "xtable",
   {   "valueType": "amount",
      "TransactionsdrillChart": "numberlicenceTaxHeadsBreakupTenant",
      "documentType": "_doc",
  },    "action": "",
   {   "plotLabel": "States",
      "Total_Licence_IssuedaggregationPaths": "number"[
        }"TL_Tax",
        {
 "Adhoc_Penalty",
        "TargetAdhoc_CollectionRebate":,
"amount"         }"Total_Amount"
      ],
      "computedFieldspathDataTypeMapping": [
        {
          "postAggregationTheoryTL_Tax" : "repsonseToDifferenceOfDates",amount"
        },
        {
          "actionNameAdhoc_Penalty": "PercentageComputedFieldamount",
        },
    "fields" : ["Total Collection", "Target_Collection"], {
          "newFieldAdhoc_Rebate" : "Target_Achievedamount",
        },
 "_comments": "fields are field names picked from its{
aggregation query to use post aggregation newField value with given new field name  " "Total_Amount":"amount"
        }
   }   ],
  
      
  ],
      "insight": {
      },
      "_comment": ""
    },
  
    "licenceTaxHeadsBreakupStatelicenceTaxHeadsBreakupDDRv3": {
      "chartName": "DSS_TL_TAX_HEAD_BREAKUP_BOUNDARY",
      "queries": [
        {
          "module": "COMMON",
          "requestQueryMap": "{\"stateIdstate\" : \"state.keyword\", \"regionId\" : \"region.keyword\"}",
          "dateRefField": "date",
          "indexName": "tl-national-dashboard",
          "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must_not\":[]}},\"aggs\":{\"StatesRegions\":{\"terms\":{\"field\":\"stateregion.keyword\"},\"aggs\":{\"TL_ Tax\":{\"sum\":{\"field\":\"tlTax\"}},\"Adhoc Penalty\":{\"Adhoc_Penalty\":{\"sum\":{\"field\":\"adhocPenalty\"}},\"Adhoc_Rebate\":{\"sum\":{\"field\":\"adhocRebate\"}} , \"Total_Amount\": {\"bucket_script\": {\"buckets_path\": {\"Adhoc_Rebate\": \"Adhoc_Rebate\",\"TL_Tax\":\"TL_Tax\" , \"Adhoc_Penalty\" : \"Adhoc_Penalty\" },\"script\": {\"source\": \" params.TL_Tax + params.Adhoc_Penalty - params.Adhoc_Rebate\"}}}}}}}}}""sum\":{\"field\":\"adhocPenalty\"}},\"Adhoc Rebate\":{\"sum\":{\"field\":\"adhocRebate\"}}}}}}}}"
        }
      ],
      "filterKeys": [
        {"key": "regionId", "column": "Regions"}
      ],
      "chartType": "xtable",
      "valueType": "amount",
      "drillChart": "licenceTaxHeadsBreakupTenant",
      "documentType": "_doc",
      "action": "",
      "plotLabel": "Regions",
      "aggregationPaths": [
        "TL Tax",
        "Adhoc Penalty",
        "Adhoc }Rebate"
      ],
      "filterKeyspathDataTypeMapping": [
        {"key
          "TL Tax": "stateIdamount",
"column": "States"}       ]},
        {
  "chartType": "xtable",       "valueTypeAdhoc Penalty": "amount"
        },
        {
  "drillChart": "licenceTaxHeadsBreakupTenant",       "documentTypeAdhoc Rebate": "_docamount",
      "action": "", }
     "plotLabel": "States" ],
      "aggregationPathscomputedFields": [
        {
"TL_Tax",          "postAggregationTheory" : "",
         "Adhoc_Penalty", "actionName": "AdditiveComputedField",
          "fields" : ["TL Tax", "Adhoc Penalty", "Adhoc_ Rebate"],
          "Total_AmountnewField" : "Total Amount",
   ],       "pathDataTypeMapping_comments": ["fields are field names picked from its aggregation query {to use post aggregation newField value with given new field name "TL_Tax": "amount"
        }
      ],
  
      "insight": {
      },
      "Adhoc_Penaltycomment": "amount"
  
     },
  
    "licenceTaxHeadsBreakupTenant": {
   
      "Adhoc_RebatechartName": "amount"DSS_TL_TAX_HEAD_BREAKUP_BOUNDARY",
        },"queries": [
        {
          "Total_Amountmodule": "amountCOMMON",
        }  "requestQueryMap": "{\"state\" : \"state.keyword\", \"regionId\" : \"region.keyword\",  ]\"ulb\" : \"ulb.keyword\"}",
           "dateRefField": "date",
          "insightindexName": {"tl-national-dashboard",
      },       "_comment": ""
    },
  
    "licenceTaxHeadsBreakupDDRv3": {
      "chartName": "DSS_TL_TAX_HEAD_BREAKUP_BOUNDARY",
      "queries": [
        {
          "module": "COMMON",
          "requestQueryMap": "{\"stateId\" : \"state.keyword\", \"regionId\" : \"region.keyword\"}",
          "dateRefField": "date",
          "indexName": "tl-national-dashboard",
          "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must_not\":[]}},\"aggs\":{\"Regions\":{\"terms\":{\"field\":\"region.keyword\"},\"aggs\":{\"TL Tax\":{\"sum\":{\"field\":\"tlTax\"}},\"Adhoc Penalty\":{\"sum\":{\"field\":\"adhocPenalty\"}},\"Adhoc Rebate\":{\"sum\":{\"field\":\"adhocRebate\""aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must_not\":[]}},\"aggs\":{\"ULBs\":{\"terms\":{\"field\":\"ulb.keyword\"},\"aggs\":{\"intermediateAggrWard\":{\"terms\":{\"field\":\"ward.keyword\"},\"aggs\":{\"days\":{\"terms\":{\"field\":\"date\"},\"aggs\":{\"applicationsTax\":{\"avg\":{\"field\":\"tlTax\"}},\"applicationsPenalty\":{\"avg\":{\"field\":\"adhocPenalty\"}},\"applicationsRebate\":{\"avg\":{\"field\":\"adhocRebate\"}}}},\"wardapplicationsTax\":{\"sum_bucket\":{\"buckets_path\":\"days.applicationsTax\"}},\"wardapplicationsPenalty\":{\"sum_bucket\":{\"buckets_path\":\"days.applicationsPenalty\"}},\"wardapplicationsRebate\":{\"sum_bucket\":{\"buckets_path\":\"days.applicationsRebate\"}}}},\"TL_Tax\":{\"sum_bucket\":{\"buckets_path\":\"intermediateAggrWard.wardapplicationsTax\"}},\"Adhoc_Penalty\":{\"sum_bucket\":{\"buckets_path\":\"intermediateAggrWard.wardapplicationsPenalty\"}},\"Adhoc_Rebate\":{\"sum_bucket\":{\"buckets_path\":\"intermediateAggrWard.wardapplicationsRebate\"}},\"Total_Amount\":{\"bucket_script\":{\"buckets_path\":{\"Adhoc_Rebate\":\"Adhoc_Rebate\",\"TL_Tax\":\"TL_Tax\",\"Adhoc_Penalty\":\"Adhoc_Penalty\"},\"script\":{\"source\":\" params.TL_Tax + params.Adhoc_Penalty - params.Adhoc_Rebate\"}}}}}}}}}"
        }
      ],
      "filterKeys": [
        {"key": "regionIdulb", "column": "RegionsULB"}
      ],
      "chartType": "xtable",
      "valueType": "amount",
      "drillChart": "licenceTaxHeadsBreakupTenantlicenceTaxHeadsBreakupWardv3",
      "documentType": "_doc",
      "action": "",
      "plotLabel": "RegionsULB",
      "aggregationPaths": [
        "TL _Tax",
        "Adhoc _Penalty",
        "Adhoc _Rebate"
    ,
 ],       "pathDataTypeMapping": [Total_Amount"
        {
   ],
      "TL TaxpathDataTypeMapping": "amount"
        },[
        {
          "Adhoc PenaltyTL_Tax": "amount"
        },
        {
          "Adhoc Rebate_Penalty": "amount"
        }
      ],
    
 "computedFields": [         {
          "postAggregationTheory" : "",
          "actionName": "AdditiveComputedField",
          "fields" : ["TL Tax", "Adhoc Penalty", "Adhoc Rebate"],
          "newField" : "Total Amount",Adhoc_Rebate": "amount"
          "_comments": "fields are field names picked from its aggregation query to use post aggregation newField value with given new field name    },
        {
          "Total_Amount": "amount"
        }
      ],
      
  
      "insight": {
      },
      "_comment": ""
    },
  
    "licenceTaxHeadsBreakupTenantlicenceTaxHeadsBreakupWardv3": {
      "chartName": "DSS_TL_TAX_HEAD_BREAKUP_BOUNDARY",
      "queries": [
        {
          "module": "COMMON",
          "requestQueryMap": "{\"stateIdstate\" : \"state.keyword\", \"regionId\" : \"region.keyword\", \"tenantIdulb\" : \"ulb.keyword\",\"ward\" : \"ward.keyword\" }",
          "dateRefField": "date",
          "indexName": "tl-national-dashboard",
          "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must_not\":[]}},\"aggs\":{\"Wards\":{\"terms\":{\"ULBs\"field\":\"ward.keyword\"},\"aggs\":{\"days\":{\"terms\":{\"field\":\"date\"},\"aggs\":{\"applicationsTax\":{\"avg\":{\"field\":\"tlTax\"}},\"applicationsPenalty\":{\"avg\":{\"field\":\"adhocPenalty\"}},\"applicationsRebate\":{\"termsavg\":{\"field\":\"ulb.keywordadhocRebate\"}}}},\"aggs\":{\"TL_Tax\":{\"sum_bucket\":{\"fieldbuckets_path\":\"tlTaxdays.applicationsTax\"}},\"Adhoc_Penalty\":{\"sum_bucket\":{\"fieldbuckets_path\":\"adhocPenaltydays.applicationsPenalty\"}},\"Adhoc_Rebate\":{\"sum_bucket\":{\"fieldbuckets_path\":\"adhocRebatedays.applicationsRebate\"}} , \"Total_Amount\": {\"bucket_script\": {\"buckets_path\": {\"Adhoc_Rebate\": \"Adhoc_Rebate\",\"TL_Tax\":\"TL_Tax\" , \"Adhoc_Penalty\" : \"Adhoc_Penalty\" },\"script\": {\"source\": \" params.TL_Tax + params.Adhoc_Penalty - params.Adhoc_Rebate\"}}}}}}}}}"
        }
      ],
      "filterKeys": [
        {"key": "tenantIdward", "column": "TenantsWards"}
      ],
      "chartType": "xtable",
      "valueType": "amount",
      "drillChart": "licenceTaxHeadsBreakupWardv3none",
      "documentType": "_doc",
      "action": "",
      "plotLabel": "TenantsWards",
      "aggregationPaths": [
        "TL_Tax",
        "Adhoc_Penalty",
        "Adhoc_Rebate",
        "Total_Amount"
      ],
      "pathDataTypeMapping": [
        {
          "TL_Tax": "amount"
        },
        {
          "Adhoc_Penalty": "amount"
        },
        {
          "Adhoc_Rebate": "amount"
        },
        {
          "Total_Amount" : "amount"
   "amount"
        }
      ],
      
  
      "insight": {
      },
      "_comment": ""
    },

    "tlTopPerformingUlbsCompletionRate": {
      "chartName": "NATIONAL_DSS_TOP_3_PERFORMING_STATES_COMPLETION_RATE",
      "queries": [
    }    
  ],      {
          "insightmodule": {
  "COMMON",
   },       "_commentrequestQueryMap": "{\"state\" : \"state.keyword\",\"ulb\"   },
  
 : \"ulb.keyword\"}",
  "licenceTaxHeadsBreakupWardv3": {       "chartNamedateRefField": "DSS_TL_TAX_HEAD_BREAKUP_BOUNDARYdate",
      "queries": [   "indexName": "tl-national-dashboard",
    {      "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must_not\":[]}},\"aggs\":{\"Licenses    "module": "COMMON",
          "requestQueryMap": "{\"stateId\" : \"state.keyword\", \"regionId\" : \"region.keyword\", \"tenantId\" : \"ulb.keyword\",\"ward\" : Within SLA\":{\"terms\":{\"field\":\"state.keyword\"},\"aggs\":{\"intermediateAggrULB\":{\"terms\":{\"field\":\"ulb.keyword\"},\"aggs\":{\"intermediateAggrWard\":{\"terms\":{\"field\":\"ward.keyword\" }",
          "dateRefField": "date",
          "indexName": "tl-national-dashboard",
          "aggrQuery": "{,\"aggs\":{\"days\":{\"terms\":{\"field\":\"date\"},\"aggs\":{\"AGGRapplications\":{\"filteravg\":{\"boolfield\":{\"must_nottodaysLicenseIssuedWithinSLA\":[]}}}},\"aggswardapplications\":{\"Wardssum_bucket\":{\"buckets_path\":\"days.applications\"}}}},\"termsulbApplications\":{\"fieldsum_bucket\":{\"ward.keywordbuckets_path\"},:\"aggsintermediateAggrWard.wardapplications\":{\"TL_Tax}}}},\"Licenses Within SLA\":{\"sum_bucket\":{\"fieldbuckets_path\":\"tlTaxintermediateAggrULB.ulbApplications\"}}}},\"Adhoc_PenaltyTotal Licenses\":{\"sumterms\":{\"field\":\"adhocPenaltystate.keyword\"}},\"aggs\":{\"Adhoc_RebateintermediateAggrULB\":{\"sumterms\":{\"field\":\"adhocRebateulb.keyword\"}} , \"Total_Amountaggs\": {\"bucket_scriptintermediateAggrWard\": {\"buckets_pathterms\": {\"Adhoc_Rebatefield\": \"Adhoc_Rebateward.keyword\"},\"TL_Taxaggs\":{\"TL_Taxdays\" , \"Adhoc_Penalty\" : \"Adhoc_Penalty\" },\"script:{\"terms\": {\"sourcefield\": \" params.TL_Tax + params.Adhoc_Penalty - params.Adhoc_Rebate\"}}}}}}}}}"
        }
      ],
      "filterKeys": [
        {"key": "ward", "column": "Wards"}
      ],
      "chartType": "xtable",
      "valueType": "amount",
      "drillChart": "none",
      "documentType": "_doc",
      "action": "",
      "plotLabel": "Wards",
      "aggregationPaths": [date\"},\"aggs\":{\"licenses\":{\"sum\":{\"field\":\"todaysTradeLicensesForStatus\"}}}},\"wardlicenses\":{\"sum_bucket\":{\"buckets_path\":\"days.licenses\"}}}},\"ulblicenses\":{\"sum_bucket\":{\"buckets_path\":\"intermediateAggrWard.wardlicenses\"}}}},\"totalLicenses\":{\"sum_bucket\":{\"buckets_path\":\"intermediateAggrULB.ulblicenses\"}}}}}}}}"
        "TL_Tax",}
        "Adhoc_Penalty"],
       "chartType": "Adhoc_Rebateperform",
       "valueType": "Total_Amount"
      ]percentage",
      "pathDataTypeMappingdrillChart": ["none",
        {
   "documentType": "_doc",
      "TL_Taxaction": "amountpercentage",
        },
        {
  "isRoundOff": true,
       "Adhoc_PenaltyplotLabel": "amount"
        },
        {
   DSS_COMPLETION_RATE",
      "Adhoc_Rebateorder": "amountdesc",
        }"limit": 3,
      "aggregationPaths": [
{        "Licenses Within  "Total_Amount" : "amount"SLA",
        "Total Licenses"
}       ],
      
 
       "insight": {
      },
      "_comment": " Top Performing Ulbs for Completion rate""
    },

    "tlTopPerformingUlbsCompletionRatetlBottomPerformingUlbsCompletionRate": {
      "chartName": "NATIONAL_DSS_TOPBOTTOM_3_PERFORMING_STATES_COMPLETION_RATE",
      "queries": [
        
        {
          "module": "COMMON",
          "requestQueryMap": "{\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\"}",
          "dateRefField": "date",
          "indexName": "tl-national-dashboard",
          "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must_not\":[]}},\"aggs\":{\"Licenses Within SLA\":{\"terms\":{\"field\":\"state.keyword\",\"order\":{\"Sum\":\"desc\"}},\"aggs\":{\"Sum\":{\"sum\":{\"field\":\"todaysLicenseIssuedWithinSLA\"}}}}, \"Total Licenses\":{\"terms\":{\"field\":\"state.keyword\",\"order\":{\"Sum\":\"desc\"}},\"aggs\":{\"Sum\":{\"sum\":{\"field\":\"todaysTradeLicensesForStatus\"}}}} }}}}"
        }
      ],
      "chartType": "perform",
      "valueType": "percentage",
      "drillChart": "none",
      "documentType": "_doc",
      "action": "percentage",
      "plotLabel": "DSS_COMPLETION_RATE",
      "order": "desc",
      "limit": 3,
      "aggregationPaths": [
        "Licenses Within SLA",
        "Total Licenses"
      ],
      "insight": {
      },
      "_comment": " Top Performing Ulbs for Completion rate"
    },

    "tlBottomPerformingUlbsCompletionRate": {
      "chartName": "NATIONAL_DSS_BOTTOM_3_PERFORMING_STATES_COMPLETION_RATE",
      "queries": [
        
        {
          "module": "COMMON",
          "requestQueryMap": "{\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\"}",
          "dateRefField": "date",
          "indexName": "tl-national-dashboard",
          "aggrQuery": "{\":{\"intermediateAggrULB\":{\"terms\":{\"field\":\"ulb.keyword\"},\"aggs\":{\"intermediateAggrWard\":{\"terms\":{\"field\":\"ward.keyword\"},\"aggs\":{\"days\":{\"terms\":{\"field\":\"date\"},\"aggs\":{\"applications\":{\"avg\":{\"field\":\"todaysLicenseIssuedWithinSLA\"}}}},\"wardapplications\":{\"sum_bucket\":{\"buckets_path\":\"days.applications\"}}}},\"ulbApplications\":{\"sum_bucket\":{\"buckets_path\":\"intermediateAggrWard.wardapplications\"}}}},\"Licenses Within SLA\":{\"sum_bucket\":{\"buckets_path\":\"intermediateAggrULB.ulbApplications\"}}}},\"Total Licenses\":{\"terms\":{\"field\":\"state.keyword\"},\"aggs\":{\"AGGRintermediateAggrULB\":{\"filterterms\":{\"boolfield\":{\"must_notulb.keyword\":[]}},\"aggs\":{\"Licenses Within SLAintermediateAggrWard\":{\"terms\":{\"field\":\"stateward.keyword\"},\"orderaggs\":{\"days\":{\"terms\":{\"Sumfield\":\"ascdate\"}},\"aggs\":{\"Sumlicenses\":{\"sum\":{\"field\":\"todaysLicenseIssuedWithinSLAtodaysTradeLicensesForStatus\"}}}}, \"Total Licenseswardlicenses\":{\"termssum_bucket\":{\"fieldbuckets_path\":\"state.keyword\",\"orderdays.licenses\"}}}},\"ulblicenses\":{\"sum_bucket\":{\"Sumbuckets_path\":\"ascintermediateAggrWard.wardlicenses\"}}}},\"aggs\":{\"SumtotalLicenses\":{\"sum_bucket\":{\"fieldbuckets_path\":\"todaysTradeLicensesForStatusintermediateAggrULB.ulblicenses\"}}}} }}}}"
        }
      ],
      "chartType": "perform",
      "valueType": "percentage",
      "drillChart": "none",
      "documentType": "_doc",
      "action": "percentage",
      "isRoundOff": true,
      "plotLabel": "DSS_COMPLETION_RATE",
      "order": "asc",
      "limit": 3,
      "aggregationPaths": [
        "Licenses Within SLA",
        "Total Licenses"
      ],
      "insight": {
      },
      "_comment": " Top Performing Ulbs for Completion rate"
    },

    "ordercumulativeLicenseIssuedv2": "asc",{
      "limitchartName": 3"DSS_TL_CUMULATIVE_LICENSE_ISSUED",
      "aggregationPathsqueries": [
        "Licenses{
Within SLA",         "module"Total: Licenses"COMMON"
 ,
    ],       "insightindexName": {"tl-national-dashboard",
      },    "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must_not\":[]}},\"aggs\":{\"Trade Licence Issued\":{\"_comment": " Top Performing Ulbs for Completion rate"date_histogram\":{\"field\":\"date\",\"interval\":\"month\"},\"aggs\":{\"Count\":{\"sum\":{\"field\":\"todaysTradeLicensesForStatus\"}}}}}}}}",
          },
    "cumulativeLicenseIssuedv2": {"requestQueryMap": "{\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\"}",
          "chartNamedateRefField": "DSS_TL_CUMULATIVE_LICENSE_ISSUED",date"
       "queries": [ },
        {
          "module": "COMMON",
          "indexName": "tl-national-dashboard",
          "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must_not\":[]}},\"aggs\":{\"TradeTotal Licence IssuedApplication\":{\"date_histogram\":{\"field\":\"date\",\"interval\":\"month\"},\"aggs\":{\"Countstate\":{\"sumterms\":{\"field\":\"todaysTradeLicensesForStatusstate.keyword\"}}}}}}}}",
          "requestQueryMap": ",\"aggs\":{\"stateintermediateAggrULB\" : {\"state.keywordterms\",:{\"tenantIdfield\" : \"ulb.keyword\"}",
          "dateRefField": "date"
        },
        {
          "module": "COMMON",
          "indexName": "tl-national-dashboard",
          "aggrQuery": "{\"aggs\":{\"AGGR,\"aggs\":{\"intermediateAggrWard\":{\"terms\":{\"field\":\"ward.keyword\"},\"aggs\":{\"days\":{\"terms\":{\"field\":\"date\"},\"aggs\":{\"filterapplications\":{\"boolavg\":{\"must_notfield\":[]\"todaysApplications\"}}}},\"aggswardapplications\":{\"Total Applicationsum_bucket\":{\"datebuckets_histogrampath\":{\"days.applications\"}}}},\"fieldulbApplications\":{\"datesum_bucket\",:{\"intervalbuckets_path\":\"monthintermediateAggrWard.wardapplications\"}}}},\"stateApplications\"aggs:{\"sum_bucket\":{\"Count\"buckets_path\":\"intermediateAggrULB.ulbApplications\"}}}},\"allApplications\":{\"sum_bucket\":{\"fieldbuckets_path\":\"todaysApplicationsstate.stateApplications\"}}}}}}}}",
          "requestQueryMap": "{\"state\" : \"state.keyword\",\"tenantIdulb\" : \"ulb.keyword\"}",
          "dateRefField": "date"
        }
      ],
      "chartType": "line",
      "valueType": "number",
      "action": "",
      "documentType": "_doc",
      "drillChart": "none",
      "aggregationPaths": [
        "Trade Licence Issued",
        "Total Application"
      ],
      "isCumulative": true,
      "interval": "month",
      "insight": {
      },
      "_comment": " Total Number of License having issued""
    },
    },
    "tlStatusByState": {
    "chartName": "DSS_TL_STATUS_BY_STATE",
    "queries": [
      {
        "module": "COMMON",
        "requestQueryMap": "{\"state\" : \"state.keyword\"} ",
        "dateRefField": "date",
        "indexName": "tl-national-dashboard",
        "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must_not\":[{\"term\":{\"ulb.keyword\":\"pb.testing\"}}]}},\"aggs\":{\"State\":{\"terms\":{\"field\":\"state.keyword\",\"size\":1000},\"aggs\":{\"Status\":{\"terms\":{\"field\":\"status.keyword\",\"size\":1000,\"min_doc_count\":0},\"aggs\":{\"License Issued\":{\"sum\":{\"field\":\"todaysTradeLicensesForStatus\"}}}}}}}}}}"
        
      }
    ],
    "filterKeys": [
      {"key": "state", "column": "State"}
    ],
    "chartType": "xtable",
    "valueType": "number",
    "drillChart": "tlStatusByUlb",
    "drillFields": [
      ""
    ],
    "pathDataTypeMapping": [
      
      {
        "INITIATED": "number"
      },
      {
        "FIELDINSPECTION": "number"
      },
      {
        "REJECTED": "number"
      },
      {
        "APPROVED": "number"
      },
      {
        "APPLIED": "number"
      },
      {
        "PENDINGAPPROVAL": "number"
      },
      {
        "CANCELLED": "number"
      },
      {
        "PENDINGPAYMENT": "number"
      },
      {
        "PAID": "number"
      }
    ],

    "documentType": "_doc",
    "action": "",
    "plotLabel": "State",
    
    


    "insight": {
    },
    "_comment": ""
  },

  "tlStatusByUlb": {
    "chartName": "DSS_TL_STATUS_BY_WARD",
    "queries": [
      {
        "module": "COMMON",
        "requestQueryMap": "{\"state\" : \"state.keyword\" , \"ulb\" : \"ulb.keyword\" } ",
        "dateRefField": "date",
        "indexName": "tl-national-dashboard",
        "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must_not\":[{\"term\":{\"ulb.keyword\":\"pb.testing\"}}]}},\"aggs\":{\"ULB\":{\"terms\":{\"field\":\"ulb.keyword\",\"size\":1000},\"aggs\":{\"Status\":{\"terms\":{\"field\":\"status.keyword\",\"size\":1000,\"min_doc_count\":0},\"aggs\":{\"License Issued\":{\"sum\":{\"field\":\"todaysTradeLicensesForStatus\"}}}}}}}}}}"
        
      }
    ],
    "filterKeys": [
      {"key": "ulb", "column": "ULB"}
    ],
    "chartType": "xtable",
    "valueType": "number",
    "drillChart": "tlStatusByWard",
    "drillFields": [
      ""
    ],
    "pathDataTypeMapping": [
      
      {
        "INITIATED": "number"
      },
      {
        "FIELDINSPECTION": "number"
      },
      {
        "REJECTED": "number"
      },
      {
        "APPROVED": "number"
      },
      {
        "APPLIED": "number"
      },
      {
        "PENDINGAPPROVAL": "number"
      },
      {
        "CANCELLED": "number"
      },
      {
        "PENDINGPAYMENT": "number"
      },
      {
        "PAID": "number"
      }
    ],

    "documentType": "_doc",
    "action": "",
    "plotLabel": "ULB",
    
    


    "insight": {
    },
    "_comment": ""
  },

  "tlStatusByWard": {
    "chartName": "DSS_TL_STATUS_BY_WARD",
    "queries": [
      {
        "module": "COMMON",
        "requestQueryMap": "{\"state\" : \"state.keyword\" , \"ulb\" : \"ulb.keyword\" , \"ward\" : \"ward.keyword\" } ",
        "dateRefField": "date",
        "indexName": "tl-national-dashboard",
        "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must_not\":[{\"term\":{\"ulb.keyword\":\"pb.testing\"}}]}},\"aggs\":{\"Ward\":{\"terms\":{\"field\":\"ward.keyword\",\"size\":1000},\"aggs\":{\"Status\":{\"terms\":{\"field\":\"status.keyword\",\"size\":1000,\"min_doc_count\":0},\"aggs\":{\"License Issued\":{\"sum\":{\"field\":\"todaysTradeLicensesForStatus\"}}}}}}}}}}"
        
      }
    ],
    "filterKeys": [
      {"key": "ward", "column": "Ward"}
    ],
    "chartType": "table",
    "valueType": "number",
    "drillChart": "none",
    "drillFields": [
      ""
    ],
    "pathDataTypeMapping": [
      
      {
        "INITIATED": "number"
      },
      {
        "FIELDINSPECTION": "number"
      },
      {
        "REJECTED": "number"
      },
      {
        "APPROVED": "number"
      },
      {
        "APPLIED": "number"
      },
      {
        "PENDINGAPPROVAL": "number"
      },
      {
        "CANCELLED": "number"
      },
      {
        "PENDINGPAYMENT": "number"
      },
      {
        "PAID": "number"
      }
    ],

    "documentType": "_doc",
    "action": "",
    "plotLabel": "Ward",
    
    


    "insight": {
    },
    "_comment": ""
  }