Hi, i will created the all pipeline to required for my project:
[
{"$addFields":{"convertedMemberId":{"$convert":{"input":"$memberId","to":"objectId"}}}},
{"$addFields":{"convertedInsurerId":{"$convert":{"input":"$insurer","to":"objectId"}}}},
{"$addFields":{"convertedClientId":{"$convert":{"input":"$clientId","to":"objectId"}}}},
{"$addFields":{"convertedUserId":{"$convert":{"input":"$userId","to":"objectId"}}}},
{"$addFields":{"convertedPolicyId":{"$convert":{"input":"$policyName","to":"objectId"}}}},
{"$lookup":{"from":"status","localField":"status","foreignField":"value","as":"ClaimStatusValue"}},
{"$lookup":{"from":"employees","localField":"convertedMemberId","foreignField":"_id","as":"claimedMembersValue"}},
{"$lookup":{"from":"employees","localField":"convertedMemberId","foreignField":"_id","as":"claimedMembersValueDOB"}},
{"$lookup":{"from":"clients","localField":"convertedClientId","foreignField":"_id","as":"claimedClientValue"}},
{"$lookup":{"from":"insurances","localField":"convertedInsurerId","foreignField":"_id","as":"claimedInsurerValue"}},
{"$lookup":{"from":"policies","localField":"convertedPolicyId","foreignField":"_id","as":"claimedPolicyValue"}},
{"$unwind":{"path":"$ClaimStatusValue","preserveNullAndEmptyArrays":true}},
{"$unwind":{"path":"$claimedMembersValue","preserveNullAndEmptyArrays":true}},
{"$unwind":{"path":"$claimedMembersValueDOB","preserveNullAndEmptyArrays":true}},
{"$unwind":{"path":"$claimedClientValue","preserveNullAndEmptyArrays":true}},
{"$unwind":{"path":"$claimedInsurerValue","preserveNullAndEmptyArrays":true}},
{"$unwind":{"path":"$claimedPolicyValue","preserveNullAndEmptyArrays":true}},
{"$unwind": {"path": "$claimedMembersValue.layout"}},
{"$unwind": {"path": "$claimedMembersValue.layout.children", "preserveNullAndEmptyArrays": true}},
{"$unwind": {"path": "$claimedMembersValue.layout.children.children", "preserveNullAndEmptyArrays": true}},
{"$unwind": {"path": "$claimedMembersValue.layout.children.children.children", "preserveNullAndEmptyArrays": true}},
{"$unwind": {"path": "$claimedMembersValue.layout.children.children.children.children", "preserveNullAndEmptyArrays": true}},
{"$unwind": {"path": "$claimedMembersValueDOB.layout"}},
{"$unwind": {"path": "$claimedMembersValueDOB.layout.children", "preserveNullAndEmptyArrays": true}},
{"$unwind": {"path": "$claimedMembersValueDOB.layout.children.children", "preserveNullAndEmptyArrays": true}},
{"$unwind": {"path": "$claimedMembersValueDOB.layout.children.children.children", "preserveNullAndEmptyArrays": true}},
{"$unwind": {"path": "$claimedMembersValueDOB.layout.children.children.children.children", "preserveNullAndEmptyArrays": true}},
{"$match": {"claimedMembersValue.layout.children.children.children.children.field_lable": "Relationship With Employee"}},
{"$match": {"claimedMembersValueDOB.layout.children.children.children.children.field_lable": "Date Of Birth"}},
{"$project":{
"_id": 0,
"Claim_Id": "$_id",
"Claim_ClientName": "$clientName",
"Claim_CreatedBy": "$createdBy",
"Claim_CreatedAt": "$createdAt",
"Claim_UpdatedAt": "$updatedAt",
"Claim_ClaimAmt": "$claimAmt",
"Claim_Paid": "$paid",
"Claim_Outstanding": "$outstanding",
"Claim_RequestType": "$requestType",
"Claim_Insurer_Name": "$claimedInsurerValue.insurerBasicInfo.name",
"Claim_Gross_Premium": {"$toDouble":"$claimedPolicyValue.premiumDetails.grossPremium"},
"Claim_Status": "$ClaimStatusValue.label",
"Claimed_Policies_id": "$policyName",
"Member_Type": "$claimedMembersValue.type",
"Relationship": "$claimedMembersValue.layout.children.children.children.children.value",
"DOB": {"$toDate": "$claimedMembersValueDOB.layout.children.children.children.children.value"},
"Claimed_Policy_Type": "$claimedPolicyValue.productType.name"
}}
]
after created th pipeline . how to make a dashboard with cross filtering...Created Date and client id