Hi,
Im trying to create this query in mongo, I can do some og it in the aggregation but not in a pipeline for charts.
any ideas?
SELECT m.attendees, count(m._id) 'meetings_calendar',
count(distinct(j.meetingID)) as 'meetee_meetings',
CASE
WHEN count(distinct(j.meetingID)) = 0 THEN 'new user'
WHEN count(distinct(j.meetingID)) between 1 and 2 THEN 'Not So Active User'
WHEN count(distinct(j.meetingID)) between 3 and 6 THEN 'Active User'
ELSE 'Boom User'
END AS userType
FROM meetings as m left join jobs as j on m._id = j.meetingID
GROUP BY m.attendees