User enrolment count issue

[Venkatesh-Dayani23]

Hi Team,
Currently we are using 5.1 we are not able to see the user enrolment count in the dashboard. we checked the Kafka topic we didn't noticed any errors there is no pending lag as well in Kafka.we didnt see any error in the Druid as well.Below are the LMS service logs of the druid query.Can you help to fix this issue.

lms-74dbb54946-sj74s lms Druid granularity: 2024-07-22/2024-07-31 & Cache Key: bmetrics:0141035770649968640:20240722:20240731:dist_state
lms-74dbb54946-sj74s lms Druid Query"{\n "queryType": "groupBy",\n "dataSource": "audit-rollup-syncts",\n "dimensions": [\n "edata_type"\n ,\n {"type":"extraction","dimension":"derived_loc_district","outputName":"district","extractionFn":{"type":"registeredLookup","lookup":"districtLookup","retainMissingValue":true}}\n ,\n {"type":"extraction","dimension":"derived_loc_state","outputName":"state","extractionFn":{"type":"registeredLookup","lookup":"stateLookup","retainMissingValue":true}}\n ],\n "aggregations": [\n {\n "fieldName": "actor_id",\n "fieldNames": [\n "actor_id"\n ],\n "type": "cardinality",\n "name": "userCount"\n }\n ],\n "granularity": "all",\n "postAggregations": [],\n "intervals": "2024-07-22/2024-07-31",\n "filter": {\n "type": "and",\n "fields": [\n {\n "type": "or",\n "fields": [\n {\n "type": "selector",\n "dimension": "edata_type",\n "value": "enrol"\n },\n {\n "type": "selector",\n "dimension": "edata_type",\n "value": "certificate-issued"\n }\n ]\n },\n {\n "type": "and",\n "fields": [\n {\n "type": "selector",\n "dimension": "context_cdata_id",\n "value": "0141035770649968640"\n },\n {\n "type": "and",\n "fields": [\n {\n "type": "selector",\n "dimension": "object_rollup_l1",\n "value": "do_1141035697593384961109"\n },\n {\n "type": "selector",\n "dimension": "eid",\n "value": "AUDIT"\n }\n ]\n }\n ]\n }\n ]\n },\n "limitSpec": {\n "type": "default",\n "limit": 10000,\n "columns": [\n {\n "dimension": "userCount",\n "direction": "descending"\n }\n ]\n }\n}"
lms-74dbb54946-sj74s lms =====Druid Response======[]
lms-74dbb54946-sj74s lms 2024-07-22 13:20:04,572 updated body: {"id":"api.collection.summary","ver":"v1","ts":"2024-07-22 13:20:04:571+0000","params":{"resmsgid":null,"msgid":"053df463-8182-4f8a-8430-b90ef7672d25","err":null,"status":"success","errmsg":null},"responseCode":"OK","result":{"lastUpdatedOn":1721654404571,"metrics":null,"groupBy":null,"batchId":"0141035770649968640","collectionId":"do_1141035697593384961109"}}

cc: @raghupathiguduri