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",
          "_comments": "fields are field names picked from its aggregation query to use post aggregation newField value with given new field name  "
        }
        
      ],
      "insight": {
      },
      "_comment": ""
    },
  
    "licenseIssuedDDDRRevenuev3": {
      "chartName": "DSS_TL_DEMAND_COLLECTION_BOUNDARY",
      "queries": [
        {
          "module": "COMMON",
          "requestQueryMap": "{\"stateId\" : \"state.keyword\", \"regionId\" : \"region.keyword\"}",
          "dateRefField": "date",
          "indexName": "tl-national-dashboard",
          "aggrQuery": "{"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\":{\"AGGRdays\":{\"filterterms\":{\"boolfield\":{\"must_notdate\":[]}},\"aggs\":{\"Regionsapplications\":{\"termsavg\":{\"field\":\"region.keywordtransactions\"}}}},\"aggs\":{\"Total Collectionwardapplications\":{\"sum_bucket\":{\"fieldbuckets_path\":\"todaysCollectionForTradeTypedays.applications\"}}}},\"TransactionsulbApplications\":{\"sum_bucket\":{\"fieldbuckets_path\":\"transactionsintermediateAggrWard.wardapplications\"}}}},\"Total Licence IssuedTransactions\":{\"sum_bucket\":{\"fieldbuckets_path\":\"todaysTradeLicensesForStatusintermediateAggrULB.ulbApplications\"}}}}}}}}"
        },
        {
          "module": "COMMON",
          "requestQueryMap": "{\"stateIdstate\" : \"state.keyword\", \"regionId\" : \"region.keyword\"}",
          "dateRefField": "date",
          "indexName": "master-national-dashboard",
          "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must_not\":[],\"must\":[{\"term\":{\"module.keyword\":\"TL\"}}]}},\"aggs\":{\"RegionsStates\":{\"terms\":{\"field\":\"regionstate.keyword\"},\"aggs\":{\"Target _Collection\":{\"sum\":{\"field\":\"budgetProposedForMunicipalCorporation\"}}}}}}}}"
        }
        
      ],
      "filterKeys": [
        {"key": "regionIdstate", "column": "RegionsStates"}
      ],
      "postAggregationTheory" : "repsonseToDifferenceOfDates",
      "chartType": "xtable",
      "valueType": "number",
      "drillChart": "licenseIssuedTenantRevenuev3",
      "documentType": "_doc",
      "action": "",
      "plotLabel": "RegionsStates",
      "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"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": ""
    },
  
    "licenseIssuedTenantRevenuev3": {
      "chartName": "DSS_TL_DEMAND_COLLECTION_BOUNDARY",
      "queries": [
        {
          "module": "COMMON",
          "requestQueryMap": "{\"state\" : \"state.keyword\", \"regionId\" : \"region.keyword\", \"ulb\" : \"ulb.keyword\"}",
          "dateRefField": "date",
          "indexName": "tl-national-dashboard",
          "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must_not\":[]}},\"aggs\":{\"Tenants\":{\"terms\":{\"field\":\"ulb.keyword\"},\"aggs\":{\"TL_Total_Collection\":{\"sum\":{\"field\":\"todaysCollectionForTradeType\"}},\"Total_Licence_Issued\":{\"sum\":{\"field\":\"todaysTradeLicensesForStatus\"}},\"intermediateAggrWard\":{\"terms\":{\"field\":\"ward.keyword\"},\"aggs\":{\"days\":{\"terms\":{\"field\":\"date\"},\"aggs\":{\"applications\":{\"avg\":{\"field\":\"transactions\"}}}},\"wardapplications\":{\"sum_bucket\":{\"buckets_path\":\"days.applications\"}}}},\"Transactions\":{\"sum_bucket\":{\"buckets_path\":\"intermediateAggrWard.wardapplications\"}}}}}}}}"
        },
        {
          "module": "COMMON",
          "requestQueryMap": "{\"state\" : \"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\":{\"Tenants\":{\"terms\":{\"field\":\"ulb.keyword\"},\"aggs\":{\"Target_Collection\":{\"sum\":{\"field\":\"budgetProposedForMunicipalCorporation\"}}}}}}}}"
        }
      ],
      "filterKeys": [
        {"key": "ulb", "column": "ULB"}
      ],
      "postAggregationTheory" : "repsonseToDifferenceOfDates",
      "chartType": "xtable",
      "valueType": "number",
      "drillChart": "licenseIssuedWardRevenuev3",
      "documentType": "_doc",
      "action": "",
      "plotLabel": "ULB",
      "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": ""
    },
  
    "licenseIssuedWardRevenuev3": {
      "chartName": "DSS_TL_DEMAND_COLLECTION_BOUNDARY",
      "queries": [
        {
          "module": "COMMON",
          "requestQueryMap": "{\"state\" : \"state.keyword\", \"regionId\" : \"region.keyword\", \"ulb\" : \"ulb.keyword\",\"ward\" : \"ward.keyword\" }",
          "dateRefField": "date",
          "indexName": "tl-national-dashboard",
          "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must_not\":[]}},\"aggs\":{\"Wards\":{\"terms\":{\"field\":\"ward.keyword\"},\"aggs\":{\"TL_Total_Collection\":{\"sum\":{\"field\":\"todaysCollectionForTradeType\"}},\"Total_Licence_Issued\":{\"sum\":{\"field\":\"todaysTradeLicensesForStatus\"}},\"days\":{\"terms\":{\"field\":\"date\"},\"aggs\":{\"applications\":{\"avg\":{\"field\":\"transactions\"}}}},\"Transactions\":{\"sum_bucket\":{\"buckets_path\":\"days.applications\"}}}}}}}}"
        }
      ],
      "computedFields": [
        {
          "postAggregationTheorymodule" : "repsonseToDifferenceOfDatesCOMMON",
          "actionNamerequestQueryMap": "PercentageComputedField",
          "fields{\"state\" : ["Total Collection\"state.keyword\", "Target Collection"],
          "newField\"regionId\" : \"region.keyword\", \"ulb\" : "Target Achieved",
          "_comments": "fields are field names picked from its aggregation query to use post aggregation newField value with given new field name  "
        }\"ulb.keyword\",\"ward\" : \"ward.keyword\"}",
               ],
      "insight"dateRefField": {
  "date",
   },       "_commentindexName": "master-national-dashboard",
    },        "licenseIssuedTenantRevenuev3": {
      "chartName": "DSS_TL_DEMAND_COLLECTION_BOUNDARY",
      "queries": ["aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must_not\":[],\"must\":[{\"term\":{\"module.keyword\":\"TL\"}}]}},\"aggs\":{\"Wards\":{\"terms\":{\"field\":\"ward.keyword\"},\"aggs\":{\"Target_Collection\":{\"sum\":{\"field\":\"budgetProposedForMunicipalCorporation\"}}}}}}}}"
        }
  {    ],
      "modulefilterKeys": "COMMON",
  [
       "requestQueryMap": "{\"stateId\key" : \"state.keyword\ward", \"regionId\column" : \"region.keyword\", \"tenantId\" : \"ulb.keyword\"}",Wards"}
      ],
      "dateRefFieldpostAggregationTheory" : "daterepsonseToDifferenceOfDates",
   
      "indexNamechartType": "tl-national-dashboardxtable",
   
      "aggrQueryvalueType": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must_not\":[]}},\"aggs\":{\"Tenants\":{\"terms\":{\"field\":\"ulb.keyword\"},\"aggs\":{\"Total Collection\":{\"sum\":{\"field\":\"todaysCollectionForTradeType\"}},\"Transactions\":{\"sum\":{\"field\":\"transactions\"}},\"Total_Licence_Issued\":{\"sum\":{\"field\":\"todaysTradeLicensesForStatus\"}}}}}}}}number",
      "drillChart": "none",
      "documentType": "_doc",
      "action": "",
      "plotLabel": "Wards",
      "aggregationPaths": [
        "TL_Total_Collection",
        "Transactions",
        "Total_Licence_Issued",
        "Target_Collection"
      ],
      "pathDataTypeMapping": [
        {
          "TL_Total_Collection": "amount"
        },
        {
          "Target_Collection": "amount"
        },
        {
          "moduleTransactions": "COMMONnumber",
          "requestQueryMap": "{\"stateId\" : \"state.keyword\", \"regionId\" : \"region.keyword\", \"tenantId\" : \"ulb.keyword\"}",},
        {
          "dateRefFieldTotal_Licence_Issued": "number",
        },
   "indexName": "master-national-dashboard",    {
      "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must_not\":[]}},\"aggs\":{\"Tenants\":{\"terms\":{\"field\":\"ulb.keyword\"},\"aggs\":{\"Target_Collection\":{\"sum\":{\"field\":\"budgetProposedForMunicipalCorporation\"}}}}}}}}    "TL_Target_Collection": "amount"
        }
      ],
      "filterKeyscomputedFields": [
       {
          {"keypostAggregationTheory" : "tenantIdrepsonseToDifferenceOfDates",
          "columnactionName": "Tenants"}AdditiveComputedField",
          "fields" : ["Target_Collection"],
          "postAggregationTheorynewField" : "repsonseToDifferenceOfDatesTL_Target_Collection",
          "chartType_comments": "xtable",fields are field names picked from its aggregation query to use post aggregation newField value with given new field name  "
        },
        {
   "valueType"       "postAggregationTheory" : "number",
          "drillChartactionName": "licenseIssuedWardRevenuev3",PercentageComputedField",
          "documentTypefields" : ["TL_Total_Collection", "TL_Target_docCollection"],
          "actionnewField" : "TL_Target_Achieved",
          "plotLabelisRoundOff": "Tenants",true,
          "aggregationPaths_comments": "fields are [field names picked from its aggregation query to use "Total Collection",
        "Transactions",post aggregation newField value with given new field name  "
        "Total_Licence_Issued",}
        "Target_Collection"
      ],
      "pathDataTypeMappingexcludedColumns": [["Target_Collection"],
      "insight": {
  {    },
      "Total Collection_comment": "amount"
   
    },
  
    "licenceTaxHeadsBreakupState": {
   
      "TransactionschartName": "number"DSS_TL_TAX_HEAD_BREAKUP_BOUNDARY",
        },"queries": [
        {
          "Total_Licence_Issuedmodule": "numberCOMMON",
          "requestQueryMap": "{\"state\" : \"state.keyword\"},
        {",
          "Target_CollectiondateRefField": "amountdate",
        }  "indexName": "tl-national-dashboard",
   ],       "computedFieldsaggrQuery": [
        {
          "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": ""
    },
  
    "licenseIssuedWardRevenuev3": {
      "chartName": "DSS_TL_DEMAND_COLLECTION_BOUNDARY",
      "queries": [
        {
          "module": "COMMON",
          "requestQueryMap": "{\"stateId\" : \"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\":{\"Wards\":{\"terms\":{\"field\":\"ward.keyword\"},\"aggs\":{\"Total Collection\":{\"sum\":{\"field\":\"todaysCollectionForTradeType\"}},\"Transactions\":{\"sum\":{\"field\":\"transactions\"}},\"Total_Licence_Issued\":{\"sum\":{\"field\":\"todaysTradeLicensesForStatus\""{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must_not\":[]}},\"aggs\":{\"States\":{\"terms\":{\"field\":\"state.keyword\"},\"aggs\":{\"intermediateAggrULB\":{\"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\"}}}},\"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\":{\"buckets_path\":\"intermediateAggrULB.ulbApplicationsTax\"}},\"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\"}}}}}}}}}"
        },
        {
  ],
       "modulefilterKeys": "COMMON",
[
         "requestQueryMap": "{\"stateId\" : \"state.keyword\", \"regionId\" : \"region.keyword\", \"tenantId\" : \"ulb.keyword\",\"ward\" : \"ward.keyword\"}",
   "key": "state", "column": "States"}
      ],
      "dateRefFieldchartType": "xtable",
   
      "indexNamevalueType": "master-national-dashboardamount",
   
      "aggrQuerydrillChart": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must_not\":[]}},\"aggs\":{\"Wards\":{\"terms\":{\"field\":\"ward.keyword\"},\"aggs\":{\"Target_Collection\":{\"sum\":{\"field\":\"budgetProposedForMunicipalCorporation\"}}}}}}}}"licenceTaxHeadsBreakupTenant",
      "documentType": "_doc",
      "action": "",
      "plotLabel": "States",
      "aggregationPaths": [
        "TL_Tax",
        "Adhoc_Penalty",
        "Adhoc_Rebate",
        }"Total_Amount"
      ],
      "filterKeyspathDataTypeMapping": [
        {"key
          "TL_Tax": "wardamount",
"column": "Wards"}       ]},
        {
 "postAggregationTheory" : "repsonseToDifferenceOfDates",       "chartTypeAdhoc_Penalty": "xtable",amount"
        },
        {
 "valueType         "Adhoc_Rebate": "numberamount",
       "drillChart": "none", },
        {
  "documentType": "_doc",       "actionTotal_Amount": "amount",
       "plotLabel": "Wards", }
      "aggregationPaths": [],
  
      "Total
Collection",  
      "Transactions",insight": {
      },
      "Total_Licence_Issued"_comment": ""
    },
  
     "Target_Collection"licenceTaxHeadsBreakupDDRv3": {
       ]"chartName": "DSS_TL_TAX_HEAD_BREAKUP_BOUNDARY",
      "pathDataTypeMappingqueries": [
        {
          "Total Collectionmodule": "amountCOMMON",
        },  "requestQueryMap": "{\"state\" : \"state.keyword\", \"regionId\"   {: \"region.keyword\"}",
          "TransactionsdateRefField": "numberdate",
        },  "indexName": "tl-national-dashboard",
     {           "Total_Licence_Issued": "number"
        },
        {
          "Target_Collection": "amount"
        }
      ],
      "computedFields": [
        {
          "postAggregationTheory" : "repsonseToDifferenceOfDates",
          "actionName": "PercentageComputedField","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\"}}}}}}}}"
          "fields" : ["Total Collection", "Target_Collection"],}
      ],
      "newFieldfilterKeys" : "Target_Achieved",[
        {"key": "regionId", "_commentscolumn": "Regions"fields}
 are field names picked from its],
aggregation query to use post aggregation newField value with given new field name  "
"chartType": "xtable",
      "valueType": "amount",
       }"drillChart": "licenceTaxHeadsBreakupTenant",
      "documentType": "_doc",
       ]"action": "",
      "insightplotLabel": {"Regions",
      "aggregationPaths": [
 },       "_comment": ""TL Tax",
        "Adhoc }Penalty",
        "licenceTaxHeadsBreakupStateAdhoc Rebate":
{       "chartName": "DSS_TL_TAX_HEAD_BREAKUP_BOUNDARY"],
      "queriespathDataTypeMapping": [
        {
          "moduleTL Tax": "COMMON",amount"
        },
     "requestQueryMap": "{\"stateId\" : \"state.keyword\"}", {
          "dateRefFieldAdhoc Penalty": "dateamount",
        },
   "indexName": "tl-national-dashboard",    {
      "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must_not\":[]}},\"aggs\":{\"States\":{\"terms\":{\"field\":\"state.keyword\"},\"aggs\":{\"TL_Tax\":{\"sum\":{\"field\":\"tlTax\"}},\"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\"}}}}}}}}}"    "Adhoc Rebate": "amount"
        }
      ],
      "computedFields": [
        {
          "postAggregationTheory" : "",
          "actionName": "AdditiveComputedField",
          "fields" : ["TL Tax", "Adhoc Penalty", "Adhoc Rebate"],
          }"newField" : "Total Amount",
   ],       "filterKeys": [
        {"key": "stateId", "column": "States"_comments": "fields are field names picked from its aggregation query to use post aggregation newField value with given new field name  "
        }
      ],
  
      "chartTypeinsight": "xtable",{
      "valueType": "amount"},
      "drillChart_comment": "licenceTaxHeadsBreakupTenant"
    },
  
    "documentTypelicenceTaxHeadsBreakupTenant": "_doc",{
      "actionchartName": "DSS_TL_TAX_HEAD_BREAKUP_BOUNDARY",
      "plotLabelqueries": "States", [
        {
 "aggregationPaths": [        "module": "TL_TaxCOMMON",
          "Adhoc_PenaltyrequestQueryMap",
        "Adhoc_Rebate",: "{\"state\" : \"state.keyword\", \"regionId\" : \"region.keyword\", \"ulb\" : \"ulb.keyword\"}",
          "Total_AmountdateRefField"
  : "date",
   ],       "pathDataTypeMappingindexName": ["tl-national-dashboard",
        {           "TL_Tax": "amount"
        },
        {
          "Adhoc_Penalty": "amount"
        },
        {
          "Adhoc_Rebate": "amount"
        },
        {
          "Total_Amount":"amount"
        }
      ],
  
      
  
      "insight": {
      },
      "_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_Rebate",
        "Total_Amount"
      ],
      "pathDataTypeMapping": [
        {
          "TL _Tax": "amount"
        },
        {
          "Adhoc _Penalty": "amount"
        },
        {
          "Adhoc _Rebate": "amount"
        }
      ],
      "computedFields": [
        {
          "postAggregationTheory" : "",
          "actionName": "AdditiveComputedField",
          "fields" : ["TL Tax", "Adhoc Penalty", "Adhoc Rebate"],
          "newField" : "Total 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\":{\"ULBsWards\":{\"terms\":{\"field\":\"ulb.keywordward.keyword\"},\"aggs\":{\"days\":{\"terms\":{\"field\":\"date\"},\"aggs\":{\"applicationsTax\":{\"avg\":{\"field\":\"tlTax\"}},\"applicationsPenalty\":{\"avg\":{\"field\":\"adhocPenalty\"}},\"applicationsRebate\":{\"avg\":{\"field\":\"adhocRebate\"}}}},\"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"
        }
      ],
      
  
      "insight": {
      },
      "_comment": ""
    },
 

    "licenceTaxHeadsBreakupWardv3tlTopPerformingUlbsCompletionRate": {
      "chartName": "NATIONAL_DSS_TOP_TL3_TAXPERFORMING_HEADSTATES_BREAKUPCOMPLETION_BOUNDARYRATE",
      "queries": [
        
        {
          "module": "COMMON",
          "requestQueryMap": "{\"stateIdstate\" : \"state.keyword\", \"regionIdulb\" : \"regionulb.keyword\"}", \"tenantId\" : \"ulb.keyword\",\"ward\" : \"ward.keyword\" }
          "dateRefField": "date",
          "dateRefFieldindexName": "datetl-national-dashboard",
          "indexName": "tl-national-dashboard",
          "aggrQuery": "{   "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must_not\":[]}},\"aggs\":{\"Licenses Within SLA\":{\"terms\":{\"field\":\"state.keyword\"},\"aggs\":{\"intermediateAggrULB\":{\"terms\":{\"field\":\"ulb.keyword\"},\"aggs\":{\"AGGRintermediateAggrWard\":{\"filterterms\":{\"boolfield\":{\"must_notward.keyword\":[]}},\"aggs\":{\"Wardsdays\":{\"terms\":{\"field\":\"ward.keyworddate\"},\"aggs\":{\"TL_Taxapplications\":{\"sumavg\":{\"field\":\"tlTaxtodaysLicenseIssuedWithinSLA\"}}}},\"Adhoc_Penaltywardapplications\":{\"sum_bucket\":{\"fieldbuckets_path\":\"adhocPenaltydays.applications\"}}}},\"Adhoc_RebateulbApplications\":{\"sum_bucket\":{\"fieldbuckets_path\":\"adhocRebateintermediateAggrWard.wardapplications\"}}}} , \"Total_AmountLicenses Within SLA\": {\"sum_bucket_script\": {\"buckets_path\":\"intermediateAggrULB.ulbApplications\"}}}},\"Total Licenses\":{\"terms\":{\"Adhoc_Rebatefield\": \"Adhoc_Rebatestate.keyword\"},\"TL_Taxaggs\":{\"intermediateAggrULB\":{\"terms\":{\"field\":\"TL_Taxulb.keyword\" }, \"Adhoc_Penaltyaggs\" : {\"Adhoc_PenaltyintermediateAggrWard\" },:{\"scriptterms\": {\"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": [
        "TL_Tax",
        "Adhoc_Penalty",
        "Adhoc_Rebate",
        "Total_Amount"
      ],
      "pathDataTypeMapping": [
        {
          "TL_Tax": "amountward.keyword\"},\"aggs\":{\"days\":{\"terms\":{\"field\":\"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\"}}}}}}}}"
        },
        {
   ],
      "Adhoc_PenaltychartType": "amountperform",
        }"valueType": "percentage",
        {
   "drillChart": "none",
      "Adhoc_RebatedocumentType": "amount_doc",
        }"action": "percentage",
        {
   "isRoundOff": true,
      "Total_AmountplotLabel" : "amountDSS_COMPLETION_RATE",
      "order": "desc",
}      "limit": ]3,
      "aggregationPaths": [
        "insight":Licenses {Within SLA",
     },   "Total Licenses"
  "_comment": ""    ],
},      "tlTopPerformingUlbsCompletionRateinsight": {
      "chartName": "NATIONAL_DSS_TOP_3_PERFORMING_STATES_COMPLETION_RATE"},
      "queries_comment": [" Top Performing Ulbs for Completion rate"
       },

  {  "tlBottomPerformingUlbsCompletionRate":  {
      "modulechartName": "COMMONNATIONAL_DSS_BOTTOM_3_PERFORMING_STATES_COMPLETION_RATE",
  
       "requestQueryMapqueries": "{\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\"}", [
        
       "dateRefField": "date", {
          "indexNamemodule": "tl-national-dashboardCOMMON",

         "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"requestQueryMap": "{\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\"}",
          "dateRefField": "date",
          "indexName": "tl-national-dashboard",
          "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"Sumbool\":{\"descmust_not\":[]}},\"aggs\":{\"SumLicenses Within SLA\":{\"sumterms\":{\"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": "{state.keyword\"},\"aggs\":{\"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\"},\"aggs\":{\"days\":{\"orderterms\":{\"Sumfield\":\"ascdate\"}},\"aggs\":{\"Sumlicenses\":{\"sum\":{\"field\":\"todaysLicenseIssuedWithinSLAtodaysTradeLicensesForStatus\"}}}}, \"Total Licenseswardlicenses\":{\"termssum_bucket\":{\"fieldbuckets_path\":\"statedays.keywordlicenses\"}}}},\"ulblicenses\":{\"ordersum_bucket\":{\"Sumbuckets_path\":\"asc"intermediateAggrWard.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"
    },

    "cumulativeLicenseIssuedv2": {
      "orderchartName": "ascDSS_TL_CUMULATIVE_LICENSE_ISSUED",
      "limitqueries": [
  3,      {
"aggregationPaths": [         "module"Licenses Within SLA: "COMMON",
          "indexName"Total Licenses": "tl-national-dashboard",
      ],    "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must_not\":[]}},\"aggs\":{\"Trade Licence "insight": {
  Issued\":{\"date_histogram\":{\"field\":\"date\",\"interval\":\"month\"},\"aggs\":{\"Count\":{\"sum\":{\"field\":\"todaysTradeLicensesForStatus\"}}}}}}}}",
   },       "_commentrequestQueryMap": "{\"state\" Top Performing Ulbs for Completion rate"
    },
    "cumulativeLicenseIssuedv2": {: \"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\":{\"aggssum_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": ""
  }