I am not able to look at the trip duration between 5000 and 10000, where the trip duration <5200 has only 6 documents. Can anyone help me out? Thanks in advance
Your filter is not showing a range. See example below.
{tripduration: {$gte: 5000,$lt: 10000}}