Versions Compared

Old Version 13

changes.mady.by.user Hina Makhija

Saved on

compared with

New Version Current

changes.mady.by.user Hina Makhija

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

  • devOps changes for KPIs:

Info

Definitions:

  • todaysApplicationsWithinSLA: It denotes the number of applications that have been closed/ have completed the workflow today.

  • todaysMovedApplications: It is an array of application statuses moved today.

  • todaysMovedApplicationsForApplicationStatus: It represents the number of applications(total count) that have been moved today for a particular application status.

  • applicationStatus: It is a string value that contains the current status of the application. Eg:
    ”applicationStatus” : “APPROVED“

Changes for Citizen-Feedback-National-Dashboard

Reference: https://github.com/egovernments/DIGIT-DevOps/blob/b8a15d760b91314399c2f31f25931fa5cb053928/deploy-as-code/helm/environments/uat.yaml#L341

  • Step 3: Add master-module-fields-mapping

Reference: https://github.com/egovernments/DIGIT-DevOps/blob/b8a15d760b91314399c2f31f25931fa5cb053928/deploy-as-code/helm/environments/uat.yaml#L341yaml#L342

  • Step 3: Add groupby mapping for Channel

    Code Block
    "CF":{"channel"}

...

Code Block
PUT pt-national-dashboard/_mapping/nss
{
  "properties" : {
          "applicationStatus" : {
            "type" : "text",
            "fields" : {
              "keyword" : {
                "type" : "keyword",
                "ignore_above" : 256
              }
            }
          },
          "assessedPropertiesForUsageCategory" : {
            "type" : "long"
          },
          "assessments" : {
            "type" : "long"
          },
          "avgTaxCollectedPerProperty" : {
            "type" : "long"
          },
          "cessForUsageCategory" : {
            "type" : "long"
          },
          "createdBy" : {
            "type" : "text",
            "fields" : {
              "keyword" : {
                "type" : "keyword",
                "ignore_above" : 256
              }
            }
          },
          "createdTime" : {
            "type" : "long"
          },
          "date" : {
            "type" : "date",
            "format" : "dd-MM-yyyy HH:mm:ss||dd-MM-yyyy||epoch_millis||dd-MM-yyyy'T'HH:mm:ss.SSSZ"
          },
          "financialYear" : {
            "type" : "text",
            "fields" : {
              "keyword" : {
                "type" : "keyword",
                "ignore_above" : 256
              }
            }
          },
          "interestForUsageCategory" : {
            "type" : "long"
          },
          "lastModifiedBy" : {
            "type" : "text",
            "fields" : {
              "keyword" : {
                "type" : "keyword",
                "ignore_above" : 256
              }
            }
          },
          "lastModifiedTime" : {
            "type" : "long"
          },
          "module" : {
            "type" : "text",
            "fields" : {
              "keyword" : {
                "type" : "keyword",
                "ignore_above" : 256
              }
            }
          },
          "noOfPropertiesPaidToday" : {
            "type" : "long"
          },
          "nonTaxCollections" : {
            "type" : "text",
            "fields" : {
              "keyword" : {
                "type" : "keyword",
                "ignore_above" : 256
              }
            }
          },
          "penaltyForUsageCategory" : {
            "type" : "long"
          },
          "propertiesRegisteredForFinancialYear" : {
            "type" : "long"
          },
          "propertyTaxForUsageCategory" : {
            "type" : "long"
          },
          "rebateForUsageCategory" : {
            "type" : "long"
          },
          "region" : {
            "type" : "text",
            "fields" : {
              "keyword" : {
                "type" : "keyword",
                "ignore_above" : 256
              }
            }
          },
          "state" : {
            "type" : "text",
            "fields" : {
              "keyword" : {
                "type" : "keyword",
                "ignore_above" : 256
              }
            }
          },
          "taxCollections" : {
            "type" : "text",
            "fields" : {
              "keyword" : {
                "type" : "keyword",
                "ignore_above" : 256
              }
            }
          },
          "todaysApplicationsWithinSLA" : {
            "type" : "long"
          },
          "todaysClosedApplications" : {
            "type" : "long"
          },
          "todaysCollectionForNonTaxCollections" : {
            "type" : "long"
          },
          "todaysCollectionForTaxCollections" : {
            "type" : "long"
          },
          "todaysCollectionForUsageCategory" : {
            "type" : "long"
          },
          "todaysMovedApplications" : {
            "type" : "long"
          },
          "todaysMovedApplicationsForApplicationStatus" : {
            "type" : "long"
          },
          "todaysTotalApplications" : {
            "type" : "long"
          },
          "totalApplicationsPaidTheTax" : {
            "type" : "long"
          },
          "transactionsForUsageCategory" : {
            "type" : "long"
          },
          "ulb" : {
            "type" : "text",
            "fields" : {
              "keyword" : {
                "type" : "keyword",
                "ignore_above" : 256
              }
            }
          },
          "usageCategory" : {
            "type" : "text",
            "fields" : {
              "keyword" : {
                "type" : "keyword",
                "ignore_above" : 256
              }
            }
          },
          "ward" : {
            "type" : "text",
            "fields" : {
              "keyword" : {
                "type" : "keyword",
                "ignore_above" : 256
              }
            }
          }
        }
}

  • Citizen

    • Ingest API -

    feedback

      • Port-forward national

    -dashboard

    A new national dashboard index for citizen feedback is created. 

    Code BlockPUT citizen-feedback-national-dashboard {}  PUT citizen-feedback-national-dashboard/_mapping/nss { "properties":

      • dashboard ingest service and hit the below curl.

      • This should result in ingestion of data for the date provided in the request body.

        Code Block
        curl --location 'http://localhost:8081/national-dashboard/metric/_ingest' \
--header 'Content-Type: application/json' \
--data '{
    "
    ulb
      • RequestInfo": {
        "
    type
      • apiId": "
    text
      • asset-services",
        "
    fields
      • ver":
    {
      • null,
        "
    keyword
      • ts":
    {
      • null,
        
      • "
    type
      • action":
    "keyword"
      • null,
      • 
        "
    ignore_above
      • did":
    256
      • null,
    } 
      • "key": null,
    }
      •    "msgId": "search
    },
      • with from and to
    "state": {
      • values",
        "
    type
      • authToken": "
    text
      • f5f22a04-ba52-4616-9e13-734bce63a15c",
        "
    fields
      • userInfo": {
            "
    keyword
      • id":
    {
      • 11227,
            "
    type
      • uuid": "
    keyword
      • 151cb3c7-3713-4e15-b9a1-3babd6d5e5a9",
            "
    ignore_above
      • userName":
    256
      • "UATPTSU",
    }
      •     "name": "PT
    }
      • Super User",
    },
      •      "
    ward
      • mobileNumber":
    {
      •  "8990877667",
            "
    type
      • emailId": "
    text
      • ",
    "fields": {
      •       
      • "
    keyword
      • locale":
    {
      • null,
            "type": "
    keyword
      • EMPLOYEE",
            "
    ignore_above
      • roles": [
    256
      •
    }
      •     {
    }
      •
    },
      •
    "region":
      •
    {
      •        "
    type
      • name": "
    text
      • NDA SYSTEM",
    "fields":
      •
    {
      •
    "keyword":
      •
    {
      •    "code": "NDA_SYSTEM",
    "type
      •            "tenantId": "
    keyword",
      • pg.citya"
    "ignore_above":
      •
    256
      •    },
    }
      •
    }
      •     {
    },
      •
    "module":{
      •
    "type":
      •
    "text",
      •        "
    fields
      • name":
    {
      •  "PT Counter Employee",
    "keyword":
      •
    {
      •            "
    type
      • code": "
    keyword
      • PT_CEMP",
    "ignore_above":
      •
    256
      •
    }
      • "tenantId": "pg.citya"
    }
      •
    },
      •     },
    "serviceType":{
      •
    "type":
      •
    "text",
      •
    "fields":
      •  {
    "keyword":
      •
    {
      •            "
    type
      • name": "
    keyword
      • Property Approver",
    "ignore_above":
      •
    256
      •
    } 
      • "code": "PROPERTY_APPROVER",
    }
      •
    },
      •
    "serviceModule":{
      •      
      • "
    type
      • tenantId": "
    text
      • pg.citya"
    ,
      •
    "fields":
      •
    {
      •
    "keyword": {
      • },
    "type":
      •
    "keyword",
      •     {
    "ignore_above":
      •
    256
      •
    }
      •     "name": "PT
    } }
      • Doc Verifier",
    "channel":
      •
    {
      •
    "type":
      •
    "text",
      •        "
    fields
      • code":
    {
      • "PT_DOC_VERIFIER",
    "keyword":
      •
    {
      •            "
    type
      • tenantId": "
    keyword
      • pg.citya"
    ,
      •
    "ignore_above":
      •
    256
      •      },
    }
      •
    }
      •
    },
      •  {
    "todaysNoOfCitizenResponsesForChannel":
      •
    {
      •
    "type":
      •
    "long" 
      •
    },
      •      "
    todaysAverageCitizenRating
      • name":
    {
      • "Property Tax Receipt Cancellator",
                    "
    type
      • code": "
    long"
      • CR_PT",
    },
      •
    "date":
      •
    {
      •        "
    type
      • tenantId": "
    date",
      • pg.citya"
                },
    "format":
      •
    "dd-MM-yyyy
      •
    HH:mm:ss||dd-MM-yyyy||epoch_millis||dd-MM-yyyy'T'HH:mm:ss.SSSZ"
      •     {
    }
      •
    }
      •
    }

  • Follow this document National Dashboard Ingest Service to set up ingest API for Citizen Feedback National Dashboard Index

  • Ingest API -

    • Port-forward national dashboard ingest service and hit the below curl.

    • This should result in ingestion of data for the date provided in the request body.

      Code Blockcurl --location 'http://localhost:8081/national-dashboard/metric/_ingest' \ --header 'Content-Type: application/json' \ --data '{
      •                 "
      RequestInfo
      • name":
      {
      • "PT Counter Approver",
      "apiId":
      •
      "asset-services",
      •          "
      ver
      • code":
      null
      • "PT_APPROVER",
      "ts": null,
      •             "
      action
      • tenantId":
      null,
      • "pg.citya"
      "did":
      •
      null,
      •        },
      "key":
      •
      null,
      •
      "msgId":
      •
      "search
      •
      with
      •
      from
      •
      and
      • {
      to
      •
      values",
      •
      "authToken":
      •
      "641ab660-3057-4593-b68b-95ea2ac6f653",
      •          "
      userInfo
      • name":
      {
      • "PT Field Inspector",
      "id":
      •
      11227,
      •              "
      uuid
      • code": "
      151cb3c7-3713-4e15-b9a1-3babd6d5e5a9", 
      • PT_FIELD_INSPECTOR",
      "userName": "UATPTSU",
      •              "
      name
      • tenantId": "
      PT Super User",
      • pg.citya"
      "mobileNumber":
      •
      "8990877667",
      •    },
      "emailId":
      •
      "",
      •       {
      "locale":
      •
      null,
      •              "
      type
      • name": "
      EMPLOYEE
      • Property Verifier",
      "roles":
      •
      [
      •        "code": "PROPERTY_VERIFIER",
      {
      •             "tenantId": "pg.citya"
      "name": "NDA SYSTEM",
      •          }
            ],
      "code": "NDA_SYSTEM",
      •            "active": true,
            "tenantId": "pg.citya",
            "permanentCity": null
      },
      •       }
    },
    "Data":
      {
      • [
        {
            "
      name
      • date": "
      PT Counter Employee
      • 03-04-2023",
      • 
            
      • "
      code
      • module": "PT
      _CEMP
      • ",
      "tenantId
      • "ward": "
      pg.citya"
      • Block 1",
            "ulb": "pb.amritsar",
      },
      •           "region": "Amritsar-MC",
      {
      •        "state": "Punjab",
            "
      name
      • metrics":
      "Property
      • {
      Approver",
      •                 "assessments": 29,
                "
      code
      • todaysTotalApplications":
      "PROPERTY_APPROVER"
      • 62,
                
      • "
      tenantId
      • todaysClosedApplications":
      "pg.citya"
      •  21,
                "noOfPropertiesPaidToday":
      }
      • 10,
      {
      • "todaysApplicationsWithinSLA" : 
      • 12,
                "
      name
      • propertiesRegistered":
      "PT
      • [
      Doc
      •
      Verifier",
      •                    {
      "code": "PT_DOC_VERIFIER",
      •                        "
      tenantId
      • groupBy": "
      pg.citya
      • financialYear",
      }, 
      •         "buckets": [
      {
      •              {
      "name":
      •
      "Property
      •
      Tax
      •
      Receipt
      •
      Cancellator",
      •                      "
      code
      • name": "
      CR_PT
      • 2018-19",
      "tenantId": "pg.citya"
      •             "value": 12
      },
      •
      {
      •      },
      "name":
      •
      "PT
      •
      Counter
      •
      Approver",
      •           {
      "code":
      •
      "PT_APPROVER",
      •                      "
      tenantId
      • name": "
      pg.citya"
      • 2019-20",
      },
      •               "value": 18
      {
      •
      "name":
      •
      "PT
      •
      Field
      •
      Inspector",
      •    },
      "code":
      •
      "PT_FIELD_INSPECTOR",
      •           {
      "tenantId":
      •
      "pg.citya"
      •
      },
      •     "name": "2020-21",
      {
      •                      "
      name
      • value":
      "Property Verifier",
      • 21
      "code":
      •
      "PROPERTY_VERIFIER",
      •    },
      "tenantId":
      •
      "pg.citya"
      •           {
      }
      •
      ],
      •              "
      active
      • name":
      true
      • "2021-22",
      "tenantId":
      •
      "pg.citya",
      •
      "permanentCity":
      •
      null
      •      "value": 43
      }
      •
      },
      •
      "Data":
      •
      [
      •
      {
      •       },
      "date": "01-04-2023",
      •
      "module":
      •
      "CF",
      •          {
      "ward":
      •
      "Block
      •
      1",
      •
      "ulb":
      •
      "pb.amritsar",
      •              "
      region
      • name": "
      Amritsar
      • 2022-
      MC
      • 23",
      •
      "state":
      •
      "Punjab",
      •
      "metrics":
      •
      {
      •       "value": 64
      "serviceModule":"PT",
      •
      "serviceType": "PT_CREATE",
      •   }
      "todaysNoOfCitizenResponses":
      •
      [
      •          ]
      {
      •          }
      "groupBy": "channel"
      •  ],
      "buckets
      • "assessedProperties": [
                    {
      {
      •                  "groupBy": "usageCategory",
      "name":
      •
      "ONLINE",
      •          "buckets": [
      "value":
      •
      12
      •      {
      },
      •          "name": "RESIDENTIAL",
      {
      •               "value": 21
      "name":
      •
      "COUNTER",
      •           },
      "value":
      •
      5
      •      {
      }
      •          "name": "COMMERCIAL",
      ]
      •                   "value": 11
      }
      •
      ],
      •           },
      "todaysAverageCitizenRating":
      •
      4.5
      •
      }
      •
      }
      •  {
      ] }'

    Configs:
    ChartApiConfigs.json:
    MasterChart
    Add following configs

    Code Block"nssPtSlaAchieved":
      •
    {
      •
    "chartName":
      •
    "NATIONAL_DSS_PT_SLA_ACHIEVED",
      •
    "queries":
      •
    [
      •
    {
      •          "
    module
      • name": "
    PT
      • INDUSTRIAL",
    "requestQueryMap": "{\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\",\"ward\" : \"ward.keyword\"}",
      •                         "value": 13
                            }
    "dateRefField":
      •
    "date",
      •     ]
    "indexName":
      •
    "pt-national-dashboard",
      •
    "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must\":[{\"term\":{\"applicationStatus.keyword\":\"APPROVED\"}}]}},\"aggs\":{\"stateApplicationsWithinSla\":{\"terms\":{\"field\":\"state.keyword\"},\"aggs\":{\"intermediateAggrULB\":{\"terms\":{\"field\":\"ulb.keyword\"},\"aggs\":{\"intermediateAggrWard\":{\"terms\":{\"field\":\"ward.keyword\"},\"aggs\":{\"days\":{\"terms\":{\"field\":\"date\"},\"aggs\":{\"applicationsSubmittedWithInSla\":{\"avg\":{\"field\":\"todaysApplicationsWithinSLA\"}}}},\"wardapplications\":{\"sum_bucket\":{\"buckets_path\":\"days.applicationsSubmittedWithInSla\"}}}},\"ulbApplications\":{\"sum_bucket\":{\"buckets_path\":\"intermediateAggrWard.wardapplications\"}}}},\"stateApplications\":{\"sum_bucket\":{\"buckets_path\":\"intermediateAggrULB.ulbApplications\"}}}},\"Total_Applications_Within_SLA\":{\"sum_bucket\":{\"buckets_path\":\"stateApplicationsWithinSla.stateApplications\"}},\"stateMovedApplications\"
      •       }
                ],
                "transactions": [
                    {
                        "groupBy": "usageCategory",
                        "buckets": [
                            {
                                "name": "RESIDENTIAL",
                                "value": 19
                            },
                            {
                                "name": "COMMERCIAL",
                                "value": 13
                            },
                            {
                                "name": "INDUSTRIAL",
                                "value": 13
                            }
                        ]
                    }
                ],
                "todaysCollection": [
                    {
                        "groupBy": "usageCategory",
                        "buckets": [
                            {
                                "name": "RESIDENTIAL",
                                "value": 16000
                            },
                            {
                                "name": "COMMERCIAL",
                                "value": 22500
                            },
                            {
                                "name": "INDUSTRIAL",
                                "value": 26000
                            }
                        ]
                    }
                ],
                "todaysMovedApplications": [
                    {
                        "groupBy": "applicationStatus",
                        "buckets": [
                            {
                                "name": "APPROVED",
                                "value": 21
                            },
                            {
                                "name": "CORRECTIONPENDING",
                                "value": 12
                            },
                            {
                                "name": "DOCVERIFIED",
                                "value": 5
                            },
                            {
                                "name": "FIELDVERIFIED",
                                "value": 2
                            },
                            {
                                "name": "OPEN",
                                "value": 11
                            },
                            {
                                "name": "PAID",
                                "value": 3
                            },
                            {
                                "name": "REJECTED",
                                "value": 2
                            },
                            {
                                "name": "INITIATED",
                                "value": 6
                            }
                        ]
                    }
                ],
                "propertyTax": [
                    {
                        "groupBy": "usageCategory",
                        "buckets": [
                            {
                                "name": "RESIDENTIAL",
                                "value": 1200
                            },
                            {
                                "name": "COMMERCIAL",
                                "value": 2100
                            },
                            {
                                "name": "INDUSTRIAL",
                                "value": 100
                            }
                        ]
                    }
                ],
                "cess": [
                    {
                        "groupBy": "usageCategory",
                        "buckets": [
                            {
                                "name": "RESIDENTIAL",
                                "value": 1300
                            },
                            {
                                "name": "COMMERCIAL",
                                "value": 1900
                            },
                            {
                                "name": "INDUSTRIAL",
                                "value": 1000
                            }
                        ]
                    }
                ],
                "rebate": [
                    {
                        "groupBy": "usageCategory",
                        "buckets": [
                            {
                                "name": "RESIDENTIAL",
                                "value": -500
                            },
                            {
                                "name": "COMMERCIAL",
                                "value": -1200
                            },
                            {
                                "name": "INDUSTRIAL",
                                "value": -900
                            }
                        ]
                    }
                ],
                "penalty": [
                    {
                        "groupBy": "usageCategory",
                        "buckets": [
                            {
                                "name": "RESIDENTIAL",
                                "value": 1300
                            },
                            {
                                "name": "COMMERCIAL",
                                "value": 1500
                            },
                            {
                                "name": "INDUSTRIAL",
                                "value": 1500
                            }
                        ]
                    }
                ],
                "interest": [
                    {
                        "groupBy": "usageCategory",
                        "buckets": [
                            {
                                "name": "RESIDENTIAL",
                                "value": 1900
                            },
                            {
                                "name": "COMMERCIAL",
                                "value": 1800
                            },
                            {
                                "name": "INDUSTRIAL",
                                "value": 600
                            }
                        ]
                    }
                ]
            }
        }
    ]
}'

  • Citizen-feedback-national-dashboard

    A new national dashboard index for citizen feedback is created. 

    Code Block
    PUT citizen-feedback-national-dashboard
{} 

PUT citizen-feedback-national-dashboard/_mapping/nss
{
  "properties": {
    "ulb": {
      "type": "text",
      "fields": {
        "keyword": {
          "type": "keyword",
          "ignore_above": 256
        }
      }
    },
    "state": {
      "type": "text",
      "fields": {
        "keyword": {
          "type": "keyword",
          "ignore_above": 256
        }
      }
    },
    "ward": {
      "type": "text",
      "fields": {
        "keyword": {
          "type": "keyword",
          "ignore_above": 256
        }
      }
    },
    "region": {
      "type": "text",
      "fields": {
        "keyword": {
          "type": "keyword",
          "ignore_above": 256
        }
      }
    },
    "module":{
      "type": "text",
      "fields": {
        "keyword": {
          "type": "keyword",
          "ignore_above": 256
        }
      }
    },
    "serviceType":{
      "type": "text",
      "fields": {
        "keyword": {
          "type": "keyword",
          "ignore_above": 256
        }
      }
    },
    "serviceModule":{
      "type": "text",
      "fields": {
        "keyword": {
          "type": "keyword",
          "ignore_above": 256
        }
      }
    },
    "channel": {
      "type": "text",
      "fields": {
        "keyword": {
          "type": "keyword",
          "ignore_above": 256
        }
      }
    },
    "todaysNoOfCitizenResponsesForChannel": {
      "type": "long"
    },
    "todaysAverageCitizenRating": {
      "type": "long"
    },
    "date": {
      "type": "date",
      "format": "dd-MM-yyyy HH:mm:ss||dd-MM-yyyy||epoch_millis||dd-MM-yyyy'T'HH:mm:ss.SSSZ"
    }
  }
}

  • Follow this document National Dashboard Ingest Service to set up ingest API for Citizen Feedback National Dashboard Index

  • Ingest API -

    • Port-forward national dashboard ingest service and hit the below curl.

    • This should result in ingestion of data for the date provided in the request body.

      Code Block
      curl --location 'http://localhost:8081/national-dashboard/metric/_ingest' \
--header 'Content-Type: application/json' \
--data '{
    "RequestInfo": {
        "apiId": "asset-services",
        "ver": null,
        "ts": null,
        "action": null,
        "did": null,
        "key": null,
        "msgId": "search with from and to values",
        "authToken": "641ab660-3057-4593-b68b-95ea2ac6f653",
        "userInfo": {
            "id": 11227,
            "uuid": "151cb3c7-3713-4e15-b9a1-3babd6d5e5a9",
            "userName": "UATPTSU",
            "name": "PT Super User",
            "mobileNumber": "8990877667",
            "emailId": "",
            "locale": null,
            "type": "EMPLOYEE",
            "roles": [
                {
                    "name": "NDA SYSTEM",
                    "code": "NDA_SYSTEM",
                    "tenantId": "pg.citya"
                },
                {
                    "name": "PT Counter Employee",
                    "code": "PT_CEMP",
                    "tenantId": "pg.citya"
                },
                {
                    "name": "Property Approver",
                    "code": "PROPERTY_APPROVER",
                    "tenantId": "pg.citya"
                },
                {
                    "name": "PT Doc Verifier",
                    "code": "PT_DOC_VERIFIER",
                    "tenantId": "pg.citya"
                },
                {
                    "name": "Property Tax Receipt Cancellator",
                    "code": "CR_PT",
                    "tenantId": "pg.citya"
                },
                {
                    "name": "PT Counter Approver",
                    "code": "PT_APPROVER",
                    "tenantId": "pg.citya"
                },
                {
                    "name": "PT Field Inspector",
                    "code": "PT_FIELD_INSPECTOR",
                    "tenantId": "pg.citya"
                },
                {
                    "name": "Property Verifier",
                    "code": "PROPERTY_VERIFIER",
                    "tenantId": "pg.citya"
                }
            ],
            "active": true,
            "tenantId": "pg.citya",
            "permanentCity": null
        }
    },
    "Data": [
        {
            "date": "01-04-2023",
            "module": "CF",
            "ward": "Block 1",
            "ulb": "pb.amritsar",
            "region": "Amritsar-MC",
            "state": "Punjab",
            "metrics": {
                "serviceModule":"PT",
                "serviceType": "PT_CREATE",
                "todaysNoOfCitizenResponses": [
                    {
                        "groupBy": "channel",
                        "buckets": [
                            {
                                "name": "ONLINE",
                                "value": 12
                            },
                            {
                                "name": "COUNTER",
                                "value": 5
                            }
                        ]
                    }
                ],
                "todaysAverageCitizenRating": 4.5
            }
        }
    ]
}'

  • Configs:
    ChartApiConfigs.json:
    MasterChart
    Add following configs

    Code Block
    "nssPtSlaAchieved": {
    "chartName": "NATIONAL_DSS_PT_SLA_ACHIEVED",
    "queries": [
      {
        "module": "PT",
        "requestQueryMap": "{\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\",\"ward\" : \"ward.keyword\"}",
        "dateRefField": "date",
        "indexName": "pt-national-dashboard",
        "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must\":[{\"term\":{\"applicationStatus.keyword\":\"APPROVED\"}}]}},\"aggs\":{\"stateApplicationsWithinSla\":{\"terms\":{\"field\":\"state.keyword\"},\"aggs\":{\"intermediateAggrULB\":{\"terms\":{\"field\":\"ulb.keyword\"},\"aggs\":{\"intermediateAggrWard\":{\"terms\":{\"field\":\"ward.keyword\"},\"aggs\":{\"days\":{\"terms\":{\"field\":\"date\"},\"aggs\":{\"applicationsSubmittedWithInSla\":{\"avg\":{\"field\":\"todaysApplicationsWithinSLA\"}}}},\"wardapplications\":{\"sum_bucket\":{\"buckets_path\":\"days.applicationsSubmittedWithInSla\"}}}},\"ulbApplications\":{\"sum_bucket\":{\"buckets_path\":\"intermediateAggrWard.wardapplications\"}}}},\"stateApplications\":{\"sum_bucket\":{\"buckets_path\":\"intermediateAggrULB.ulbApplications\"}}}},\"Total_Applications_Within_SLA\":{\"sum_bucket\":{\"buckets_path\":\"stateApplicationsWithinSla.stateApplications\"}},\"stateMovedApplications\":{\"terms\":{\"field\":\"state.keyword\"},\"aggs\":{\"intermediateAggrULB\":{\"terms\":{\"field\":\"ulb.keyword\"},\"aggs\":{\"intermediateAggrWard\":{\"terms\":{\"field\":\"ward.keyword\"},\"aggs\":{\"days\":{\"terms\":{\"field\":\"date\"},\"aggs\":{\"totalMovedApplications\":{\"avg\":{\"field\":\"todaysMovedApplicationsForApplicationStatus\"}}}},\"wardapplications\":{\"sum_bucket\":{\"buckets_path\":\"days.totalMovedApplications\"}}}},\"ulbApplications\":{\"sum_bucket\":{\"buckets_path\":\"intermediateAggrWard.wardapplications\"}}}},\"stateApplications\":{\"sum_bucket\":{\"buckets_path\":\"intermediateAggrULB.ulbApplications\"}}}},\"Total_Moved_Applications\":{\"sum_bucket\":{\"buckets_path\":\"stateMovedApplications.stateApplications\"}}}}}}"
      }
    ],
    "chartType": "metric",
    "valueType": "percentage",
    "drillChart": "none",
    "documentType": "nss",
    "action": "percentage",
    "isRoundOff": true,
    "aggregationPaths": [
      "Total_Applications_Within_SLA",
      "Total_Moved_Applications"
    ],
    "insight": {
      "chartResponseMap" : "nssPtSlaAchieved",
      "action" : "differenceOfNumbers",
      "upwardIndicator" : "positive",
      "downwardIndicator" : "negative",
      "textMessage" : "$indicator$value% than last $insightInterval",
      "colorCode" : "#228B22",
      "insightInterval" : "year",
      "isRoundOff": true
    },
    "_comment": " "
  },

  "nssPtPendancy": {
    "chartName": "NATIONAL_DSS_PT_PENDANCY",
    "queries": [
      {
        "module": "PT",
        "requestQueryMap": "{\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\",\"ward\" : \"ward.keyword\"}",
        "dateRefField": "date",
        "indexName": "pt-national-dashboard",
        "aggrQuery": "{\"aggs\":{\"all_matching_docs\":{\"filters\":{\"filters\":{\"all\":{\"match_all\":{}}}},\"aggs\":{\"stateClosedApplications\":{\"terms\":{\"field\":\"state.keyword\"},\"aggs\":{\"intermediateAggrULB\":{\"terms\":{\"field\":\"ulb.keyword\"},\"aggs\":{\"intermediateAggrWard\":{\"terms\":{\"field\":\"ward.keyword\"},\"aggs\":{\"days\":{\"terms\":{\"field\":\"date\"},\"aggs\":{\"totalMovedApplicationsapplications\":{\"avg\":{\"field\":\"todaysMovedApplicationsForApplicationStatustodaysClosedApplications\"}}}},\"wardapplications\":{\"sum_bucket\":{\"buckets_path\":\"days.totalMovedApplicationsapplications\"}}}},\"ulbApplications\":{\"sum_bucket\":{\"buckets_path\":\"intermediateAggrWard.wardapplications\"}}}},\"stateApplications\":{\"sum_bucket\":{\"buckets_path\":\"intermediateAggrULB.ulbApplications\"}}}},\"Total_MovedClosed_Applications\":{\"sum_bucket\":{\"buckets_path\":\"stateMovedApplicationsstateClosedApplications.stateApplications\"}}}}}}"
      }
    ],
    "chartType": "metric",
    "valueType": "percentage",
    "drillChart": "none",
    "documentType": "nss",
    "action": "percentage",
    "isRoundOff": true,
    "aggregationPaths": [
      "Total_Applications_Within_SLA",
      "Total_Moved_Applications"
    ],
    "insight": {
      "chartResponseMap" : "nssPtSlaAchieved",
      "action" : "differenceOfNumbers",
      "upwardIndicator" : "positive",
      "downwardIndicator" : "negative",
      "textMessage" : "$indicator$value% than last $insightInterval",
      "colorCode" : "#228B22",
      "insightInterval" : "year",
      "isRoundOff": true
    },
    "_comment": " "
  },

  "nssPtPendancy": {
    "chartName": "NATIONAL_DSS_PT_PENDANCY",
    "queries": [
      {
        "module": "PT",
        "requestQueryMap": "{\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\",\"ward\" : \"ward.keyword\"}",
        "dateRefField": "date",
        "indexName": "pt-national-dashboard",
        "aggrQuery": "{\"aggs\":{\"all_matching_docs\":{\"filters\":{\"filters\":{\"all\":{\"match_all\":{}}}},\"aggs\":{\"stateClosedApplications\":{\"terms\":{\"field\":\"state.keyword\"},\"aggs\":{\"intermediateAggrULB\":{\"terms\":{\"field\":\"ulb.keyword\"},\"aggs\":{\"intermediateAggrWard\":{\"terms\":{\"field\":\"ward.keyword\"},\"aggs\":{\"days\":{\"terms\":{\"field\":\"date\"},\"aggs\":{\"applications\":{\"avg\":{\"field\":\"todaysClosedApplications\"}}}},\"wardapplications\":{\"sum_bucket\":{\"buckets_path\":\"days.applications\"}}}},\"ulbApplications\":{\"sum_bucket\":{\"buckets_path\":\"intermediateAggrWard.wardapplications\"}}}},\"stateApplications\":{\"sum_bucket\":{\"buckets_path\":\"intermediateAggrULB.ulbApplications\"}}}},\"Total_Closed_Applications\":{\"sum_bucket\":{\"buckets_path\":\"stateClosedApplications.stateApplications\"}},\"stateTotalApplications,\"stateTotalApplications\":{\"terms\":{\"field\":\"state.keyword\"},\"aggs\":{\"intermediateAggrULB\":{\"terms\":{\"field\":\"ulb.keyword\"},\"aggs\":{\"intermediateAggrWard\":{\"terms\":{\"field\":\"ward.keyword\"},\"aggs\":{\"days\":{\"terms\":{\"field\":\"date\"},\"aggs\":{\"applications\":{\"avg\":{\"field\":\"todaysTotalApplications\"}}}},\"wardapplications\":{\"sum_bucket\":{\"buckets_path\":\"days.applications\"}}}},\"ulbApplications\":{\"sum_bucket\":{\"buckets_path\":\"intermediateAggrWard.wardapplications\"}}}},\"stateApplications\":{\"sum_bucket\":{\"buckets_path\":\"intermediateAggrULB.ulbApplications\"}}}},\"Total_Applications\":{\"sum_bucket\":{\"buckets_path\":\"stateTotalApplications.stateApplications\"}},\"Applications_Pending\":{\"bucket_script\":{\"buckets_path\":{\"total\":\"Total_Applications\",\"closed\":\"Total_Closed_Applications\"},\"script\":\"(params.total - params.closed) \"}}}}}}"
      }
    ],
    "chartType": "metric",
    "valueType": "percentage",
    "drillChart": "none",
    "documentType": "nss",
    "action": "percentage",
    "isRoundOff": true,
    "aggregationPaths": [
      "Applications_Pending",
      "Total_Applications"
    ],
    "insight": {
      "chartResponseMap" : "nssPtPendancy",
      "action" : "differenceOfNumbers",
      "upwardIndicator" : "positive",
      "downwardIndicator" : "negative",
      "textMessage" : "$indicator$value% than last $insightInterval",
      "colorCode" : "#228B22",
      "insightInterval" : "year",
      "isRoundOff": true
    },
    "_comment": " "
  },

  "nssOverviewPendancy": {
    "chartName": "NATIONAL_DSS_OVERVIEW_PENDANCY",
    "queries": [
      {
        "module": "PT",
        "requestQueryMap": "{\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\",\"ward\" : \"ward.keyword\"}",
        "dateRefField": "date",
        "indexName": "pt-national-dashboard",
        "aggrQuery": "{\"aggs\":{\"all_matching_docs\":{\"filters\":{\"filters\":{\"all\":{\"match_all\":{}}}},\"aggs\":{\"stateClosedApplications\":{\"terms\":{\"field\":\"state.keyword\"},\"aggs\":{\"intermediateAggrULB\":{\"terms\":{\"field\":\"ulb.keyword\"},\"aggs\":{\"intermediateAggrWard\":{\"terms\":{\"field\":\"ward.keyword\"},\"aggs\":{\"days\":{\"terms\":{\"field\":\"date\"},\"aggs\":{\"applications\":{\"avg\":{\"field\":\"todaysTotalApplicationstodaysClosedApplications\"}}}},\"wardapplications\":{\"sum_bucket\":{\"buckets_path\":\"days.applications\"}}}},\"ulbApplications\":{\"sum_bucket\":{\"buckets_path\":\"intermediateAggrWard.wardapplications\"}}}},\"stateApplications\":{\"sum_bucket\":{\"buckets_path\":\"intermediateAggrULB.ulbApplications\"}}}},\"Total_Closed_Applications\":{\"sum_bucket\":{\"buckets_path\":\"stateTotalApplicationsstateClosedApplications.stateApplications\"}},\"Applications_PendingstateTotalApplications\":{\"bucket_scriptterms\":{\"buckets_path\"field\":\"state.keyword\"},\"aggs\":{\"totalintermediateAggrULB\":{\"Total_Applicationsterms\",:{\"closedfield\":\"Total_Closed_Applicationsulb.keyword\"},\"script\"aggs\":{\"intermediateAggrWard\":{\"terms\":{\"field\":\"(params.total - params.closed) ward.keyword\"}}}}}}"
      }
    ],
    "chartType": "metric",
    "valueType": "percentage",
    "drillChart": "none",
    "documentType": "nss",
    "action": "percentage",
    "isRoundOff": true,
    "aggregationPaths": [
      "Applications_Pending",
      "Total_Applications"
    ],
    "insight": {
      "chartResponseMap" : "nssPtPendancy",
      "action" : "differenceOfNumbers",
      "upwardIndicator" : "positive",
      "downwardIndicator" : "negative",
      "textMessage" : "$indicator$value% than last $insightInterval",
      "colorCode" : "#228B22",
      "insightInterval" : "year",
      "isRoundOff": true
    },
    "_comment": " "
  },

  "nssOverviewPendancy": {
    "chartName": "NATIONAL_DSS_OVERVIEW_PENDANCY",
    "queries": [,\"aggs\":{\"days\":{\"terms\":{\"field\":\"date\"},\"aggs\":{\"applications\":{\"avg\":{\"field\":\"todaysTotalApplications\"}}}},\"wardapplications\":{\"sum_bucket\":{\"buckets_path\":\"days.applications\"}}}},\"ulbApplications\":{\"sum_bucket\":{\"buckets_path\":\"intermediateAggrWard.wardapplications\"}}}},\"stateApplications\":{\"sum_bucket\":{\"buckets_path\":\"intermediateAggrULB.ulbApplications\"}}}},\"Total_Applications\":{\"sum_bucket\":{\"buckets_path\":\"stateTotalApplications.stateApplications\"}},\"Applications_Pending\":{\"bucket_script\":{\"buckets_path\":{\"total\":\"Total_Applications\",\"closed\":\"Total_Closed_Applications\"},\"script\":\"(params.total - params.closed) \"}}}}}}"
      },
      {
        "module": "PTTL",
        "requestQueryMap": "{\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\",\"ward\" : \"ward.keyword\"}",
        "dateRefField": "date",
        "indexName": "pttl-national-dashboard",
        "aggrQuery": "{\"aggs\":{\"all_matching_docs\":{\"filters\":{\"filters\":{\"all\":{\"match_all\":{}}}},\"aggs\":{\"stateClosedApplications\":{\"terms\":{\"field\":\"state.keyword\"},\"aggs\":{\"intermediateAggrULB\":{\"terms\":{\"field\":\"ulb.keyword\"},\"aggs\":{\"intermediateAggrWard\":{\"terms\":{\"field\":\"ward.keyword\"},\"aggs\":{\"days\":{\"terms\":{\"field\":\"date\"},\"aggs\":{\"applications\":{\"avg\":{\"field\":\"todaysClosedApplications\"}}}},\"wardapplications\":{\"sum_bucket\":{\"buckets_path\":\"days.applications\"}}}},\"ulbApplications\":{\"sum_bucket\":{\"buckets_path\":\"intermediateAggrWard.wardapplications\"}}}},\"stateApplications\":{\"sum_bucket\":{\"buckets_path\":\"intermediateAggrULB.ulbApplications\"}}}},\"Total_Closed_Applications\":{\"sum_bucket\":{\"buckets_path\":\"stateClosedApplications.stateApplications\"}},\"stateTotalApplications\":{\"terms\":{\"field\":\"state.keyword\"},\"aggs\":{\"intermediateAggrULB\":{\"terms\":{\"field\":\"ulb.keyword\"},\"aggs\":{\"intermediateAggrWard\":{\"terms\":{\"field\":\"ward.keyword\"},\"aggs\":{\"days\":{\"terms\":{\"field\":\"date\"},\"aggs\":{\"applications\":{\"avg\":{\"field\":\"todaysTotalApplicationstodaysApplications\"}}}},\"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\":\"stateTotalApplications.stateApplications\"}},\"Applications_Pending\":{\"bucket_script\":{\"buckets_path\":{\"total\":\"Total_Applications\",\"closed\":\"Total_Closed_Applications\"},\"script\":\"(params.total - params.closed) \"}}}}}}"
      }
    ],
    "chartType": "metric",
    "valueType": "percentage",
    "drillChart": "none",
    "documentType": "nss",
    "action": "percentage",
    "isRoundOff": true,
    "aggregationPaths": [
      "Applications_Pending",
      "Total_Applications"
    ],
    "insight": {
      "chartResponseMap" : "nssOverviewPendancy",
      "action" : "differenceOfNumbers",
      "upwardIndicator" : "positive",
      "downwardIndicator" : "negative",
      "textMessage" : "$indicator$value% than last $insightInterval",
      "colorCode" : "#228B22",
      "insightInterval" : "year",
      "isRoundOff": true
    },
    "_comment": " "
  },

  "nssPtCitizenFeedbackScore": {
    "chartName": "NATIONAL_DSS_PT_CITIZEN_FEEDBACK_SCORE",
    "queries": [
      {
        "module": "CF",
        "requestQueryMap": "{\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\",\"ward\" : \"ward.keyword\"}",
        "dateRefField": "date",
        "indexName": "citizen-feedback-national-dashboard",
        "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must\":[{\"term\":{\"serviceModule.keyword\":\"PT\"}}]}},\"aggs\":{\"Total Feedback Score\":{\"sum\":{\"script\":{\"lang\":\"painless\",\"inline\":\"doc['todaysAverageCitizenRating'].value * doc['todaysNoOfCitizenResponsesForChannel'].value\"}}},\"Total Number of Responses\":{\"sum\":{\"field\":\"todaysNoOfCitizenResponsesForChannel\"}}}}}}"
      }
    ],
    "chartType": "metric",
    "valueType": "number",
    "drillChart": "none",
    "documentType": "nss",
    "action": "division",
    "isRoundOff": true,
    "aggregationPaths": [
      "Total Feedback Score",
      "Total Number of Responses"
    ],
    "insight": {
      "chartResponseMap" : "nssPtCitizenFeedbackScore",
      "action" : "differenceOfNumbers",
      "upwardIndicator" : "positive",
      "downwardIndicator" : "negative",
      "textMessage" : "$indicator$value% than last $insightInterval",
      "colorCode" : "#228B22",
      "insightInterval" : "year",
      "isRoundOff": true
    },
    "_comment": " "
  },
  
  "nssOverviewCitizenFeedbackScore": {
    "chartName": "NATIONAL_DSS_OVERVIEW_CITIZEN_FEEDBACK_SCORE",
    "queries": [
      {
        "module": "CF",
        "requestQueryMap": "{\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\",\"ward\" : \"ward.keyword\"}",
        "dateRefField": "date",
        "indexName": "citizen-feedback-national-dashboard",
        "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\":{\"must\":[{\"term\":{\"serviceModule.keyword\":\"PT\"}}]}},\"aggs\":{\"Total Feedback Score\":{\"sum\":{\"script\":{\"lang\":\"painless\",\"inline\":\"doc['todaysAverageCitizenRating'].value * doc['todaysNoOfCitizenResponsesForChannel'].value\"}}},\"Total Number of Responses\":{\"sum\":{\"field\":\"todaysNoOfCitizenResponsesForChannel\"}}}}}}"
      }
    ],
    "chartType": "metric",
    "valueType": "number",
    "drillChart": "none",
    "documentType": "nss",
    "action": "division",
    "isRoundOff": true,
    "aggregationPaths": [
      "Total Feedback Score",
      "Total Number of Responses"
    ],
    "insight": {
      "chartResponseMap" : "nssOverviewCitizenFeedbackScore",
      "action" : "differenceOfNumbers",
      "upwardIndicator" : "positive",
      "downwardIndicator" : "negative",
      "textMessage" : "$indicator$value% than last $insightInterval",
      "colorCode" : "#228B22",
      "insightInterval" : "year",
      "isRoundOff": true
    },
    "_comment": " "
  },
  
   "nssPtCitizenServiceDeliveryIndex": {
    "chartName": "NATIONAL_DSS_PT_CITIZEN_SERVICE_DELIVERY_INDEX",
    "queries": [
      {
        "module": "PT",
        "requestQueryMap": "{\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\",\"ward\" : \"ward.keyword\"}",
        "dateRefField": "date",
        "indexName": "pt-national-dashboard",
        "aggrQuery": "{\"aggs\": {\"all_matching_docs\": {\"filters\": {\"filters\": {\"all\": {\"match_all\": {}}}},\"aggs\": {\"state\":{\"terms\": {\"field\": \"state.keyword\",\"size\": 10000},\"aggs\": {\"ulb\": {\"terms\": {\"field\": \"ulb.keyword\",\"size\": 10000},\"aggs\": {\"ward\": {\"terms\": {\"field\": \"ward.keyword\",\"size\": 10000},\"aggs\": {\"SlaintermediateAggr\": {\"terms\": {\"field\": \"date\",\"size\": 10000},\"aggs\": {\"applicationsSubmittedWithInSla\": {\"avg\": {\"field\": \"todaysApplicationsWithinSLA\"}}}},\"Total_Applications_Within_SLA\": {\"sum_bucket\": {\"buckets_path\": \"SlaintermediateAggr.applicationsSubmittedWithInSla\"}},\"app\": {\"filter\": {\"bool\": {\"must\":[{\"match\":{\"applicationStatus.keyword\" : \"APPROVED\"}}]}},\"aggs\": {\"totalapplication\": {\"sum\": {\"field\": \"todaysMovedApplicationsForApplicationStatus\"}}}},\"aggregatedsla\": {\"bucket_script\": {\"buckets_path\": {\"total\": \"app.totalapplication\",\"withinsla\": \"Total_Applications_Within_SLA\"},\"script\": \"((params.withinsla / params.total) * 100)*0.5\"}}}}}}}}}}}}"
      },
      {
        "module": "CF",
        "requestQueryMap": "{\"state\" : \"state.keyword\",\"ulb\" : \"ulb.keyword\",\"ward\" : \"ward.keyword\"}",
        "dateRefField": "date",
        "indexName": "citizen-feedback-national-dashboard",
        "aggrQuery": "{\"aggs\":{\"AGGR\":{\"filter\":{\"bool\": {\"must\": [{\"term\": {\"serviceModule.keyword\": \"PT\"}}]}},\"aggs\": {\"all_matching_docs\": {\"filters\": {\"filters\": {\"all\": {\"match_all\": {}}}},\"aggs\": {\"state\": {\"terms\": {\"field\": \"state.keyword\",\"size\": 10000},\"aggs\": {\"ulb\": {\"terms\": {\"field\": \"ulb.keyword\",\"size\": 10000},\"aggs\": {\"ward\": {\"terms\": {\"field\": \"ward.keyword\",\"size\": 10000},\"aggs\": {\"TotalFeedbackScore\": {\"sum\": {\"script\": {\"lang\": \"painless\",\"inline\": \"doc['todaysAverageCitizenRating'].value * doc['todaysNoOfCitizenResponsesForChannel'].value\"}}},\"TotalNumberofResponses\": {\"sum\": {\"field\": \"todaysNoOfCitizenResponsesForChannel\"}},\"avgfeedback\": {\"bucket_script\": {\"buckets_path\": {\"response\": \"TotalNumberofResponses\",\"feedbak\": \"TotalFeedbackScore\"},\"script\": \"((params.response / params.feedbak) * 100)*0.5\"}}}}}}}}}}}}}}"
      }
    ],
    "chartType": "metric",
    "valueType": "number",
    "drillChart": "none",
    "documentType": "nss",
    "action": "",
    "isRoundOff": true,
    "aggregationPaths": [
      "aggregatedsla",
      "avgfeedback"
    ],
    "insight": {
      "chartResponseMap" : "nssPtCitizenServiceDeliveryIndex",
      "action" : "differenceOfNumbers",
      "upwardIndicator" : "positive",
      "downwardIndicator" : "negative",
      "textMessage" : "$indicator$value% than last $insightInterval",
      "colorCode" : "#228B22",
      "insightInterval" : "year",
      "isRoundOff": true
    },
    "_comment": " "
  }


    MasterDashboardConfig.json

...