Hi,
Can somebody please help me with a query by reading through the following:
Data format:
{
"_id": {
"$oid": "61f131817ce17fa2873fdd84"
},"primary_data": {
"first_name": "Tharun KC",
"email": "tharunkc93@gmail.com",
"phone": "+919663798289",
"gender": "Female",
"dob": "21-APR-2001",
"address": "Home : Flat No 1 Bldg No 901 Road No 1119 Road Name R 1119 Block No 711",
"is_active": true,
"created_on": "2022-01-24T05:00:03.182792Z",
"created_by": "tharun@hellospace.ai",
"modified_by": "tharun@hellospace.ai",
"data_set_id": 363,
"org_id": 2
},
"secondary_data": {
"provider_name": "Jalal Al Marzooq",
"visit_type": "OP",
"unit": "RBH",
"mrno": 1891414,
"bill_date": "23-JAN-22",
"department_name": "ENT",
"source_type": "CSV"
},
"tags": [],
"response_data": {
"share_date": "2021-12-09T08:49:49.511735Z",
"response_date":"2022-01-24T06:00:03.182792Z",
"channel":"SMS",
"share_name":"OPD - RBH",
"channel_name":"SmsCountry",
"survey_name": "OPD",
"response":[
{
"question": "How likely is it that you would recommend KIMSHEALTH to your friends and family?",
"answer": 10,
"question_type": "NPS"
},
{
"question": "Reception / Registration",
"answer": 3,
"question_type": "emotions"
},
{
"question": "Doctors",
"answer": 4,
"question_type": "emotions"
},
{
"question": "Nurses",
"answer": 4,
"question_type": "emotions"
},
{
"question": "Laboratory",
"answer": 4,
"question_type": "emotions"
},
{
"question": "Radiology",
"answer": 4,
"question_type": "emotions"
},
{
"question": "Emergency Room",
"answer": 4,
"question_type": "emotions"
},
{
"question": "Pharmacy",
"answer": 5,
"question_type": "emotions"
},
{
"question": "Food & Beverages",
"answer": 4,
"question_type": "emotions"
},
{
"question": "Facility",
"answer": 4,
"question_type": "emotions"
},
{
"question": "Would you like to add any comments?",
"answer": "Excellent ",
"question_type": "comment"
}
]
}
}
For Question type: NPS, the ratings are categorized in the following manner
a. 0-6: Detractor
b. 7-8: Passive
c. 9-10: Promoter
Calculation of NPS is based on the following formula:
NPS = %Promoters - %Detractors
I would like to represent NPS by date in mongo charts as below. NPS value can vary between -100 to +100
Can somebody please help me understand how I can achieve this using mongo charts.