Chapter 4 facets lab - metacritic field

I’m confused, I didn’t find a metacritic field, am I connected to the wrong database or something?
I might be a little confused because I’m doing more than one course at once, but, I’m pretty sure I’m in the aggregation database from the aggregations course…


Well, obviously I can’t tell where you are either. :wink:

But the “metacritic” field clearly exists in the namespace ‘aggregations.movies’ as shown here

db.movies.find( {“metacritic”: {$exists: true} } ).count()

I’d suggest that you see if that works for you; if not, you probably are in the wrong place.

Well, this is weird, I’m just going to look it again after finishing the other course I’m taking, thanks DHz!

Don’t feel bad if you miss this. It’s only in about 1/4 of records, so statistically looking at records with only 2 per page or so, there’s definitely a chance you’d see a record without.

MongoDB Enterprise Cluster0-shard-0:PRIMARY> db.movies.find( {“metacritic”: {"$exists": true} } ).itcount()
MongoDB Enterprise Cluster0-shard-0:PRIMARY> db.movies.find().itcount()
MongoDB Enterprise Cluster0-shard-0:PRIMARY>